Hi,

I installed mysql oledb provider in my system.

But Iam unable to connect to my sql using ADODB Object in ASP, its giving me following error
---------------------------------------------------------------------------------------------------
Error Type:
Provider (0x8000FFFF)
Catastrophic failure
/test/sampleconnection.asp, line 16

---------------------------------------------------------------------------------------------------

I wrote following code in ASP;
-------------------------------------------------------------
dim conn
connString="Provider=MySQLProv;server=192.168.1.7; port=3306;database=grades;uid=test;pwd=test"
set conn=server.CreateObject("ADODB.connection")
conn.Open()
---------------------------------------------------------------------------------

Please suggest me as soon as posssible.

Regard's
Krishna Prakash.K

Error Type says provider, you sure that the connection string is correct?

connection string exactly correct, because thats alreadt working with ODBC. I want it to shift OLEDB provider

please suggest