-
Getting errors in ASPDBFree
I have downloaded the ASPDBfree version.
It runs absolutely fine on Microsoft Access Database asp-test.mdb.
But when i try to connect it to SQL Server 6.5 Database. The connection to the database is getting established. But the fetch from the database is always failing. I am getting the following error message.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '10'.
/samar/smartdb.asp, line 120
Can anyone help me solving this problem?
Thanks
Samar
-
Getting errors in ASPDBFree (reply)
Samar,
Just add this line:
mydb.dbDBType = "SQL"
That will fix it.
Mark.
------------
Samar Gupta at 12/15/99 7:52:03 AM
I have downloaded the ASPDBfree version.
It runs absolutely fine on Microsoft Access Database asp-test.mdb.
But when i try to connect it to SQL Server 6.5 Database. The connection to the database is getting established. But the fetch from the database is always failing. I am getting the following error message.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '10'.
/samar/smartdb.asp, line 120
Can anyone help me solving this problem?
Thanks
Samar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|