Newbie can't connect to MySQL from VB.NET

Preface: I spent one whole day on this. Read every KB article including: http://kb.discountasp.net/article.aspx?id=10085
Scanned all the relevant forum articles. I am a SQL DBA and an old VB programmer - a newbie at VB.NET.

I cannot connect to my MySQL DB in VB.NET
I tried using the DSN connection, the DSNless connection. Can't do it.
Can't execute an INSERT INTO, DROP TABLE, CREATE TABLE, or SELECT
Can't do it. Just can't do anything SQL related from VB.net.

Anyone have the actual connection string with maybe a line or two of SQLcode plus a text box or something?
A complete example that works?

The one in kb=10085 is full of errors when I paste it in.

TIA
Sorry in advance for the newbie question, but I did spend a lot of time looking it up first at least...

Post Edited (asus) : 11/6/2005 4:26:59 AM GMT

 

bruce said...
The KB article should work fine, what error are you getting?





Well the first thing that is noticeable is that this KB article is html text opposed to a VB program. Perhaps there is a way to view the VB.net program in HTML mode and push this straight in, I don't know, I'm new to VB.net. But by default VB.net doesn't power-up that way. If I post HTML in there, it doesn't know what the heck it is. So I dissected it many different ways and tried to make it what I thought it should be, having had years of previous client-server VB experience.

I did finally make it work, and don't want to sound ungrateful for any help I can get. But I'm pretty sure that with the addition of some instructions along with the KB article (100% code), we may be able to cut down on questions to the staff.

If you don't mind, I would liketo put together a step-by-step KB article that will get the newbie up and running with fewer failures.

Regards,


[/quote][/quote]

 

Bruce: I will do that. Thanks so much for your time.


Best regards.