Results 1 to 2 of 2

Thread: Not specified

  1. #1
    SQL error on calling ASPdbFree method Guest

    Not specified


    In my test environment, I am using SQL 7. My page containing the calls to the ASPdbFree component is running fine. But when I deploy my site using SQL 6.5, that page returns an error:

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '10'.

    /ISO/main.asp, line 189


    Line 189 is the 'dbHistory.aspDBFree' call.
    Why is this so?
    Is the component compatible to SQL 6.5?

    Need help, urgent.

    Thanks

    GV

  2. #2
    Frank Guest

    Not specified (reply)


    Always define the type of database you are using -

    X.dbDBType="SQL"

    for SQL

    FK


    ------------
    SQL error on calling ASPdbFree method at 1/25/00 1:01:45 AM


    In my test environment, I am using SQL 7. My page containing the calls to the ASPdbFree component is running fine. But when I deploy my site using SQL 6.5, that page returns an error:

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '10'.

    /ISO/main.asp, line 189


    Line 189 is the 'dbHistory.aspDBFree' call.
    Why is this so?
    Is the component compatible to SQL 6.5?

    Need help, urgent.

    Thanks

    GV

Posting Permissions

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