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