Results 1 to 7 of 7

Thread: ODBC error

  1. #1
    Join Date
    Feb 2004
    Location
    Turkey
    Posts
    4

    Angry Unanswered: ODBC error

    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!..

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    Did you create a system DSN for your database? What is your connection string?

  3. #3
    Join Date
    Feb 2004
    Location
    Turkey
    Posts
    4

    Smile Sorry!

    Originally posted by gyuan
    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!
    Attached Files Attached Files

  4. #4
    Join Date
    Dec 2003
    Posts
    454
    When you creat DSN, did you user Login ID and Password? Write a test page with the simple query and see if it works.

  5. #5
    Join Date
    Feb 2004
    Location
    Turkey
    Posts
    4
    Originally posted by gyuan
    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.

  6. #6
    Join Date
    Dec 2003
    Posts
    454
    Did you try to execute the simple statement like SELECT TOP 1 * FROM TableName? Your query statement is not readable.

  7. #7
    Join Date
    Feb 2004
    Location
    Turkey
    Posts
    4

    Yeeeep!

    Originally posted by gyuan
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •