Trying to simply connect to Oracle with VBscript/ASP - and I cannot.
538640May 22 2008 — edited May 27 2008This is rather embarrassing. I am pretty fluent with ASP and VBscript, and I have written many a web application connecting to Microsoft SQL Server. Now I have a need to connect to an Oracle database, and I'm beating my head against the wall.
1) Web server is Windows Server 2003 SP1
2) Using ASP (not ASP.NET) & VBscript
3) I have installed the Oracle drivers on the server - it is version 10g
4) The administrator of the Oracle database to which I want to connect has created a username and password for me to use from within my code
5) Here is the code I am trying to run:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=MSDAORA;Data Source=XXXXXXX;User Id=YYYYYYY;Password=ZZZZZZZ;"
That's it. 2 lines of code just trying to establish a connection. Using the user name and password provided to me by the administrator, and for Data Source I am using the IP address of the Oracle server (like I have done in the past when connecting to SQL Server). I receive the following error message when viewing this in a browser:
Microsoft OLE DB Provider for Oracle error '80004005'
ORA-12154: TNS:could not resolve the connect identifier specified
Evidently, the Data Source I am using is not correct, but I was provided no other information from the admin. This is the first time any of us have tried to connect to Oracle using ASP/VBScript, so the administrator isn't sure what I need to do ... any help would be so appreciated.