Hi,
I have connected my client to Oracle 8i database through following
connection string in ASP
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString= "DRIVER={Microsoft ODBC for
Oracle};UID=[username];PWD=[password];SERVER=ssdb;"
conn.open
but, when I trying to execute sql statement in ASP I am getting
following error. Kindly suggest to come out of this error
set rs=Server.CreateObject("ADODB.recordset")
sql = "select date from dual "

set rs=Server.CreateObject("ADODB.Recordset")
rs.Open sql,conn
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expression

/online/files/tobe/test.asp, line 38

Oracle LazyDBA home page