Dear All,

I tried to connect to Oracle by ASP as follow.

1>Dim conn,param,rs,sql
2>set conn=Server.CreateObject("ADODB.Connection")
3>param="driver={Oracle ODBC driver}"
4>conn.Open param & ";ODBC;DSN=ora;UID=abc;PWD=abc;"
5>sql="select * from table-1"
6>set rs=conn.execute(sql,dbSQLPassThrough)
7>response.write rs.fields(1).name
8>response.write "=" & rs.fields(1).value

All processes works fine except line <8>.
It seems no current record, but there are data in that table.

Where is the bug or syntax error?

Thanks you all!!