Oracle Connections

[karlmcauley]

Oracle Connection Problem
Active Server Pages error 'ASP 0115'

Unexpected error

/dummy.asp

A trappable error (C0000005) occurred in an external object. The script cannot continue running.

I get the above error whilst trying to connect to an oracle 9i database.

Has anyone seen it before? Any Ideas on a remedy?

Cheers

PS i can post the connection code if you wish.

[karlmcauley]

strStudentID = Request.QueryString("StudID")

'connecting to the Live Oracle Database


sConnString= "Provider=MSDASQL.1;Password=password;Persist Security Info=True;User ID=ID;Data Source=DSN"


Set TheConnObject = Server.CreateObject("ADODB.Connection")


sConnString.Open TheConnObject

Set rs = Server.CreateObject("ADODB.Recordset")

rs.ActiveConnection = TheConnObject

%>

The error is being returned at "Set TheConnObject = Server.CreateObject("ADODB.Connection")"

Any ideas?

Cheers

[karlmcauley]

I have tested the connection through a VB application running on the server and i get it to return the required data......but come to put it into a web page through vbscript i get the error messages as displayed above.

Can someone help please.

Cheers

[karlmcauley]

I tried to edit the original request and say resolved in the title but it was not updating the title??

I went away and created a text file with a extension .udl which is a microsft data link file. I put in the necessary information and converted it back to text file and the connection string was there and it was MSDAORA.1

However, on another server the above connection string ("Provider=MSDASQL.1;Password=password;Persist Security Info=True;User ID=ID;Data Source=DSN") worked and connected to the exact same oracle 9 database.........which is why i have got so confused!!!

Thx anyway for your response.