I have given the connection string as

constr = "Provider=MSDASQL;DRIVER={MySQL ODBC 3.51
Driver};Server=localhost;UID=usrname;PWD=pwd;Database=databasename;Option=16387;"

I'm getting problem while establishing connection itself not while retrieving
data

Phanikumar ----- Original Message ----- From: Rahmat Hidayat To: Phani Kumar Cc: win...@lists.mysql.com Sent: Wednesday, July 16, 2003 11:22 AM Subject: Re: Data source name not found

have you specified your mysql odbc driver which you use ?and have you
specified data source name completed with database source(table) which you use?

Rahmat Hidayat http://mahasiswa.if.itb.ac.id/~if11016 toma...@yahoo.com toma...@yahoo.com Love Peace and Freedom

Phani Kumar <phan...@botree.co.in> wrote: hai,

I've win2k ,sql2k and mysql4.x running on my machine. I've installed myodbc for odbc connectivity. when i try to connect to mysql database using vb i'm able to do. but the same thing when i try to in ASP its giving the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /tems/chat/register.asp, line 8

thanx in advance for your help

Regards,

pk

-- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc?unsub=toma...@yahoo.com