ADO error 3265

delorfra · Jun 7, 2001

Intranet Server : NT4/IIS4
Database : Oracle

I tried to access an Oracle Database through a system DSN set-up on the server (Microsoft Oracle driver) an get the

3265 ADO error message :
"Item cannot be found in the collection corresponding to the requested name or ordinal."

When I run the same program on my local W2K machine (

http://Localhost/connect.asp),

it works fine but not when run from the server (

http://ServerIP/connect.asp).

The DSN has been set up the same way on both machines then pointing to the same database, so no tables/fields mistypes involved.

here is my script :

<%@ Language=VBScript%>

<HTML>
<HEAD><TITLE>ASP CONNECTION TRIAL</TITLE></HEAD>
<BODY>
<%
ON ERROR RESUME NEXT
Set objConnection = Server.CreateObject("ADODB.Connection&quot

objConnection.Open "DSN=SGQS; UserId=sgqs; pwd=toto"
Set oRS=Server.CreateObject("ADODB.recordset&quot

SQL = "Select * from PILOTE"
oRS.Open SQL, objConnection
oRS.Movefirst
Response.Write oRS.Fields("CDPILOTE&quot

& " "

Response.Write SQL & " "

IF err.Number <>0 then
response.write "Number : " & err.Number & ""
response.write "Descr : " & err.description & ""
response.write "Source : " & err.source & ""
err.clear
end if

oRS.Close
set oRS=Nothing
objConnection.Close
set objConnection=Nothing
%>

</BODY>
</HTML>>

delorfra · Jun 7, 2001

For those interested.
The error message stopped when I decided to replace the DNS connection with an OLEDB connection.

Very strange ???

I am still interested if anybody knows why it did not work with DNS/IIS4 and worked with DSN/IIS5 or OLEDB/IIS4 or 5.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

ADO error 3265

delorfra

Programmer

delorfra

Programmer

Similar threads

Part and Inventory Search

Sponsor