ops, sorry jay, i forgot this...
do you install mysql in your web server? if you install it on your web server, so i think you should install the odbc driver for mysql in your web server... and after that u can use your asp script to make connection to your mysql database.... have a nice try :-) Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com ----- Original Message ----- From: Jay Fields <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net > I've installed the windows version of mysql. I configured nothing. > This is the code I'm trying to use to access mysql from an asp web service > (in vb): > --------- > <WebMethod()> Public Function dbConnect() As String > Dim connString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _ > "SERVER=localhost;" & _ > "DATABASE=test;" & _ > "UID=test;" & _ > "PASSWORD=test;" & _ > "OPTION=3" > Dim MyConnection As New OdbcConnection(connString) > Try > MyConnection.Open() > MyConnection.Close() > Return connString > Catch e As Exception > Return e.Message > End Try > End Function > ---------------------- > It's returning the following exception: ERROR [IM002] [Microsoft][ODBC > Driver Manager] Data source name not found and no default driver specified > > Any ideas? > > --------------------------------------------------------------------- > 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