Connecting with VB?

[ideasworking]

Hello,

I just installed my first MySQL system nad now I'm trying to connect a vb app I'm building. I downloaded and installed the MyODBC driver 3.51 and I can see it in the ODBC administration. However I do not see the driver listed in the OLE DB providers list of Visual Basic.

How do I connect to the MySQL database from my vb app?

TIA
Lou

 

[vbkris]

so why not use ODBC?

Known is handfull, Unknown is worldfull

 

[ideasworking]

Thanks,

The problem was... I was receiving an error "10061 Can't connect to localhost". At the time I started this thread it never occured to me that localhost was not my MySQL server name. I changed the name in the ODBC connection to the name of the MySQL server and now everything works.

Cheers!
Lou