SQL error

[Richard Hyams]

I have the following problem with my SQL database
and the following code

Set MyDb = Server.CreateObject("ASPdb.Pro") ` Create the ASP-db™ object (View or Pro)

Mydb.dbDSN="DSN=adr;UID=sa;PWD=future1996;"

MyDb.dbSQL="*"

MyDb.ASPdbPro


The first bit works. I.e I see a lsit of my tables but when I click on any table the following appears

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

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near `5`.

/marketing/test.asp, line 24

Is five the number of records being fetched ?

[Frank]

Richard,
This problem is fixed in the more recent versions. The cause is the identification of the database type (ACCESS/SQL). In the newer versions, You can use dbDBType="SQL". In your version please try using

Mydb.dbOptions("datewrap=`")

to get by until you get the latest version.

Frank

On 10/19/98 12:25:56 PM, Richard Hyams wrote:
> I have the following problem with my SQL database
and the following
> code

Set MyDb = Server.CreateObject("ASPdb.Pro") ` Create the ASP-db™
> object (View or
> Pro)

Mydb.dbDSN="DSN=adr;UID=sa;PWD=future1996;"

MyDb.dbSQL="*"

MyD
> b.ASPdbPro


The first bit works. I.e I see a lsit of my tables but when
> I click on any table the following appears

Microsoft OLE DB Provider for
> ODBC Drivers error `80040e14`

[Microsoft][ODBC SQL Server Driver][SQL
> Server]Line 1: Incorrect syntax near `5`.

/marketing/test.asp, line 24
>

Is five the number of records being fetched ?