Getting errors in ASPDBFree

[Samar Gupta]

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

[Mark H.]

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