Quake3World

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

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

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

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.

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.

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.

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.

Fuckin nerds.

use ODBC.

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

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:

Foo wrote:use ODBC.

:icon14:

Pick up MyODBC here

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