Hi, > -----Original Message----- > From: Frankie Cooke [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 15, 2002 9:48 AM > To: [EMAIL PROTECTED] > Subject: My ODBC Error > > > Hello All > > I can currently connect to a Mysql database on my local machine, a windows > o/s. However, when I try and do this on unix - get the error: > > Vbscript Runtime error 'ASP 0185 : -2147467259' > Data source name not found or no default driver specified > > include/dbconnectcrop.asp,line 11 > > > Line 11 is the where I am opening the connection. I feel that I have not > matched the driver name. Is the driver MyODBC called something different > on Unix, other than MySQL. Below is my conenction string. > > <% > > ' Connect to MySQL database for passwords & section documents > > Dim dbconnect, anyRs, insComm > > set dbconnect=Server.CreateObject("ADODB.Connection") > > dbconnect.ConnectionString="Driver=MySQL;server=localhost;Database=cropwise; > " > > dbconnect.Open > > %> > > Thanks for any help > > Frankie >
You said you are trying to connect to server running on Unix, but your ADO connect string has localhost. Any way, For more information on how to establish a remote connection using MyODBC, refer to the following link: http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:4326:200112:pnidmlbpjaokppdkhnhp 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