Good days!

I have received this message when I compile my ASP code.

ODBC does not support the requested operation
line 29

line 28 and 29 are,


28-set rcsnokta=Server.CreateObject("ADODB.Recordset")

29-rcsnokta.open sql,connection,1

Please help me!..

Did you create a system DSN for your database? What is your connection string?

I see that you have difficulty with not to see the all code.I am sending to you the entire asp code with attached file ariza.txt.

Thanks for your helpful behaviour!

When you creat DSN, did you user Login ID and Password? Write a test page with the simple query and see if it works.

no I did not. I created the database and used it in an another asp code.It works,but I have written a few asp code that have the same statement. They have given the same ODBC error.

Did you try to execute the simple statement like SELECT TOP 1 * FROM TableName? Your query statement is not readable.

I wrote the simple sql statement,then it works properly. Does the error stem from the wrong-typed sql statement? This is end of my questions.

Thanks for your help and have a nice day!