J
Jack
Hi,
I got a asp page where I am getting the following error. (Line 126 is
actually the
RS.open statement.)
ERROR MESSAGE
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'GrantID ='.
/gwis/Recalc.asp, line 126
THE FOLLOWING IS THE PART OF CODE THAT IS PRODUCING ERROR:
'New Connection
myDSN="DRIVER={Microsoft Access Driver (*.mdb)}; "
myDSN=myDSN & "DBQ=C:\gwis Data\fpdb\GWIS.mdb"
set CN=server.createobject("ADODB.Connection")
set RS=server.createobject("ADODB.Recordset")
CN.Open "myDSN"
RS.ActiveConnection=CN
SQL = "SELECT COUNT(*) AS reccount FROM CurrentQuarterTbl WHERE GrantID =
" & GrantID & ";"
RS.Open SQL
Any help is appreciated in advance. Thanks.
I got a asp page where I am getting the following error. (Line 126 is
actually the
RS.open statement.)
ERROR MESSAGE
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'GrantID ='.
/gwis/Recalc.asp, line 126
THE FOLLOWING IS THE PART OF CODE THAT IS PRODUCING ERROR:
'New Connection
myDSN="DRIVER={Microsoft Access Driver (*.mdb)}; "
myDSN=myDSN & "DBQ=C:\gwis Data\fpdb\GWIS.mdb"
set CN=server.createobject("ADODB.Connection")
set RS=server.createobject("ADODB.Recordset")
CN.Open "myDSN"
RS.ActiveConnection=CN
SQL = "SELECT COUNT(*) AS reccount FROM CurrentQuarterTbl WHERE GrantID =
" & GrantID & ";"
RS.Open SQL
Any help is appreciated in advance. Thanks.