Hi,

This has nothing to do with your connection object or ASP !

Just correct your SQL stmt, and voila !

SELECT sysdate FROM DUAL;

(ps: There's no pseudo column date to select from dual !)

Cheers!
Kris

-----Original Message-----
From: Anil Kumar (IT - Extn : 4423)
[mailto:oracledba-ezmlmshield-x54904393.[Email address protected]
Sent: Tuesday, August 07, 2007 10:36 AM
To: LazyDBA Discussion
Subject: ODBC error

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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page