Coordinating Visual Basic with mySQL

Post by **glossy** » Tue May 24, 2005 12:37 pm

i've been looking around on google for a while now, but i can't seem to find any decent resources for connecting a visual basic app to a mySQL database... all the examples are using exactly the same code which doesn't explain itself at all, nor does it seem to work for executing more than one query after a wait.

Basically, I'm writing a huge php song library, but retrieving >10,000 songs, weeding out a few of the broken ones, retrieving ID3 info from each one and putting it all into a database, then executing plenty of sql queries to INSERT each song into the database tends to take a while... So, I'm using Visual Basic to do all the really intensive stuff, and leaving php for the browsing and front-end part, which is good because it is allowed to take >5 minutes without everything dying on itself, but horrible due to complete lack of documentation.

I'd be using C++, but I'm really out of practice with it and would rather just get this part of the project done without relearning everything, plus the new stuff.

Any help, links, suggestions, "are you mad!?", etc. would be greatly appreciated, thanks guys

Post by **Dave** » Tue May 24, 2005 12:40 pm

I only connect to mssql, but as far as I'm aware all you need is ADO, a proper driver and the ability to deal with the quirks of the SQL langauge and you're ready to go

Post by **diego** » Tue May 24, 2005 12:43 pm

I worked with Oracle and PostgreSQL for the last 6 months, so if you need any help and if I find any time, send me a p.m. - I'll be happy to help you out.

PS: Cunt

Post by **Dave** » Tue May 24, 2005 12:49 pm

Oracle is retarded. I couldnt get my .NET application to work with it, so I had to build a privileged COM+ app to act as a proxy between the website and the database.

Post by **diego** » Tue May 24, 2005 12:53 pm

Well, it definitely has its downsides but the whole instances-management makes it worth it. Plus, it kinda pays a little better... for now at least.

Post by **bitWISE** » Tue May 24, 2005 2:56 pm

You didnt search very hard did you Dave?

http://www.oracle.com/technology/softwa ... index.html

They also have a JDBC that I've used to create Java based load testing scripts.

Post by **Dave** » Tue May 24, 2005 3:02 pm

bitWISE wrote:You didnt search very hard did you Dave?

http://www.oracle.com/technology/softwa ... index.html

They also have a JDBC that I've used to create Java based load testing scripts.

You're an idiot. I installed all of that, but because of permission errors, the ASPNET user on the webserver doesnt have the necessary access to use the oracle client. It's a known issue.

Post by **GONNAFISTYA** » Tue May 24, 2005 3:09 pm

Fuckin nerds.

Post by **Foo** » Tue May 24, 2005 6:32 pm

use ODBC.

Post by **PhoeniX** » Tue May 24, 2005 6:34 pm

http://www.planet-source-code.com/vb/sc ... 0&lngWId=1 ?

Post by **Billy Bellend** » Tue May 24, 2005 6:35 pm

i think if you thouroghly explain everything to Visual Basic on the benifits of sayd corodination with mySQL, things shoul fall right into place. :yes:

Post by **ilum0s** » Tue May 24, 2005 6:36 pm

Foo wrote:use ODBC.

:icon14:

Pick up MyODBC here

Post by **bitWISE** » Tue May 24, 2005 6:49 pm

Billy Bellend wrote:i think if you thouroghly explain everything to Visual Basic on the benifits of sayd corodination with mySQL, things shoul fall right into place. :yes:

hahahaha i love you plained