SQL ODBC error 80040e14

[Klaus P Springer]

I just started with ASPdb-Pro (and SQL). I used the attched code successfully with MS Access. When I tried to switch to MS SQL 6.5 (after 'upsizing&#39 I received: ODBC Driver error '80040e14' ... [SQL Server]Line 1: Incorrect syntax near '1'. The error occurs only when I enter a valid userid/password combination in my form...
Any help would be greatly appreciated !

Set MyDb=Server.CreateObject("ASPdb.Pro&#34
MyDb.dbQuickProps="4711;Darwinet.System;;form; "
Session("myUnit&#34 = Session("MyUnit&#34 + 1
MyDb.dbUnit=Session("myUnit&#34
MyDb.dbFormTableTag=" "
MyDb.dbSQL = "SELECT * FROM Users WHERE UserID='" & Session("myUserID&#34 & "' AND Password ='" & Session("myPassword&#34 & "'"
MyDb.dbFormDisplayFlds = "-1"
MyDb.dbNavigation= "none"
MyDb.dbStatusBar=false
MyDb.dbSuppressMsg=true
MyDb.dbExportFlds = "0,1,2,3,4"
MyDb.ASPdbPro

[Frank]

Add -> MyDb.dbDBType="SQL" for MS-SQL "ORACLE,Server" for ORACLE server etc...



On 2/17/99 6:28:21 PM, Klaus P Springer wrote:
> I just started with ASPdb-Pro (and SQL). I used the attched code
> successfully with MS Access. When I tried to switch to MS SQL 6.5 (after
> 'upsizing&#39 I received: ODBC Driver error '80040e14' ...
> [SQL Server]Line 1: Incorrect syntax near '1'. The error occurs
> only when I enter a valid userid/password combination in my form...
Any
> help would be greatly appreciated !

Set
> MyDb=Server.CreateObject("ASPdb.Pro&#34

> MyDb.dbQuickProps="4711;Darwinet.System;;form; "

> Session("myUnit&#34 = Session("MyUnit&#34 + 1

> MyDb.dbUnit=Session("myUnit&#34
MyDb.dbFormTableTag=" "

> MyDb.dbSQL = "SELECT * FROM Users WHERE UserID='" &
> Session("myUserID&#34 & "' AND Password ='" &
> Session("myPassword&#34 & "'"
MyDb.dbFormDisplayFlds =
> "-1"
MyDb.dbNavigation= "none"

> MyDb.dbStatusBar=false
MyDb.dbSuppressMsg=true
MyDb.dbExportFlds =
> "0,1,2,3,4"
MyDb.ASPdbPro