Tell me what you do.... ADODB -> OLEDB driver for ODBC -> MyODBC -> MySQL ADODB -> MyOLEDB -> MySQL
or anything else? first case: check "don't promt on connect" Did you create a data source? (First thing you don't need to do...) But whatever you do with VB, MS ADODB and MySQL - you will need time. (Many time ;-) ) Chris ----- Original Message ----- From: "Darrell A. Sullivan, II" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 9:04 PM Subject: Connecting to MySQL using OLEDB > Can anyone tell me if it is possible to connect to a MySQL server running on > Linux from a Windows Visual Basic application without setting up a DSN on > the Windows computer? > > I know this can be done with MS SQL Server and I have heard it can be done > with Oracle so I am wondering if there is a connection string that will work > with MySQL. Currently everything I try brings up a DSN setup screen and this > is something that I definitely do not want. > > Thanks for any help. > > Darrell > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php