Hi, > -----Original Message----- > From: D Nyberg [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 23, 2002 9:30 AM > To: [EMAIL PROTECTED] > Subject: Naming a Provider? > > > Guys, I'm very new to ODBC, so please bear with, okay? > > I'm looking at example code in a particular windows binding package, and > see the following: > > ... > -- Open Database > Open (DB_Control.Database, > "Provider=Microsoft.Jet.OLEDB.4.0; " & > "Data Source=..\..\tutorials\adotest.mdb"); > ... > > That statement succeeds in opening that mdb (Access) file for further > manipulation. I have no idea where they came up with the information > that the way you connect with an access database is to use the > incantation "Microsoft.Jet.OLEDB.4.0". Likewise, I have no idea what > comparable magic string would specify a mysql database. > > 1) What string would I substitute into that code sample to connect with > a mysql database instead of an access database?
It depends up on which provider and programming language you are trying to use. To know what connection string(s) can be used to access MySQL through (My)ODBC, refer to the following samples: http://www.mysql.com/products/myodbc/faq.html#SAMPLE_-_VB > > 2) What document should I have been looking at to discover that for > myself? MyODBC : http://www.mysql.com/products/myodbc/ ODBC : http://www.microsoft.com/data Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- 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
