error in sql query

[parames]

Hi list..

Set Conn = Server.CreateObject("ADODB.Connection&quot
strDSN ="DRIVER={MySQL};SERVER=150.150.1.118;DATABASE=test;UID=root;PWD=;"
Conn.Open strDSN

Query = "select DAYOFWEEK('2002-03-01') as show_day"
Set RS = Conn.Execute(Query)
show_day = RS("show_day&quot

When i run this query, there is an error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver does not support this parameter
/test/quality.asp, line 20

line 20 ---> show_day = RS("show_day&quot

I'm using mySql database. When i run this query in mySql, there is an output. But, when i run this in asp page, error message prompted out..
What's the problem actually, and how to solve it. Please help..

Thanks a lot.

Best Regards,
Parameswari Sellaparma

 

[codestorm]

I'm not that familiar with mySQL, but I think the problem is with ADO.

Try using a command object to build the recordset, and experiment with different CommandType values (e.g. adCmdText, adCmdStoredProc).
codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>