SQL Server error

[Brooks Martin]

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

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

/custom/ASPDB.asp, line 19


Here's the code:
Set MyDb = Server.CreateObject("AspDB.PRO
MyDb.dbDSN = "DSN=Northwind2;UID=myuid;PWD=mypwd"
Mydb.dbSQL= "SELECT Contracts.ID , Contracts.Author, Contracts.Descriptive_Text, Contracts.Category, Contracts.Instructions FROM Contracts;"
Mydb.dbStatusBar="false"
MyDb.dbMode="dual-horiz"
MyDb.dbcolor="4,auto"
MyDb.dbNavigation="none"
MyDb.dbUnit=23
MyDb.dbGridInc=-1
MyDb.dbSelectBox="17, Contracts, Click to Select; #Contracts.ID# #Contracts.Author# #Contracts.Category#"
MyDb.ASPdbPro

[Frank]

Martin,

Complete line #1 and try again. If still have problem. Construct a system DSN and try it. If still have problem then post your findings. I'll help you get going !

Change
Set MyDb = Server.CreateObject("AspDB.PRO
To
Set MyDb = Server.CreateObject("AspDB.PRO&#34


Frank


On 12/24/98 10:56:28 AM, Brooks Martin wrote:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>

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

/custom/ASPDB.asp, line 19


Here's
> the code:
Set MyDb = Server.CreateObject("AspDB.PRO
MyDb.dbDSN =
> "DSN=Northwind2;UID=myuid;PWD=mypwd"
Mydb.dbSQL=
> "SELECT Contracts.ID , Contracts.Author, Contracts.Descriptive_Text,
> Contracts.Category, Contracts.Instructions FROM Contracts;"
>
Mydb.dbStatusBar="false"
>
MyDb.dbMode="dual-horiz"
>
MyDb.dbcolor="4,auto"
>
MyDb.dbNavigation="none"
>
MyDb.dbUnit=23
>
MyDb.dbGridInc=-1
>
MyDb.dbSelectBox="17, Contracts, Click to Select; #Contracts.ID#
> #Contracts.Author# #Contracts.Category#"
MyDb.ASPdbPro

[Brooks Martin]

That's how my code looked. I copied and pasted the first line incorrectly. I have no problem with DSN's as I use this same database in other applications.

I found that the following line solved the problem.

MyDb.dbDBType = "SQL"

Regards,
Brooks Martin

On 12/24/98 8:48:08 PM, Frank wrote:
> Martin,

Complete line #1 and try again. If still have problem. Construct
> a system DSN and try it. If still have problem then post your findings.
> I'll help you get going !

Change
Set MyDb =
> Server.CreateObject("AspDB.PRO
To
Set MyDb =
> Server.CreateObject("AspDB.PRO&#34


Frank


On 12/24/98
> 10:56:28 AM, Brooks Martin wrote:
> Microsoft OLE DB Provider for ODBC
> Drivers error '80040e14'
>

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

/custom/ASPDB.asp, line 19


Here's
> the code:
Set MyDb =
> Server.CreateObject("AspDB.PRO
MyDb.dbDSN =
>
> "DSN=Northwind2;UID=myuid;PWD=mypwd"
Mydb.dbSQL=
>
> "SELECT Contracts.ID , Contracts.Author, Contracts.Descriptive_Text,
>
> Contracts.Category, Contracts.Instructions FROM Contracts;"
>
>
Mydb.dbStatusBar="false"
>
>
MyDb.dbMode="dual-horiz"
>
>
MyDb.dbcolor="4,auto"
>
>
MyDb.dbNavigation="none"
>
>
MyDb.dbUnit=23
>
>
MyDb.dbGridInc=-1
>
>
MyDb.dbSelectBox="17, Contracts, Click to Select; #Contracts.ID#
>
> #Contracts.Author# #Contracts.Category#"
MyDb.ASPdbPro