Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » ASP connection to Oracle
ASP connection to Oracle [message #76707] Wed, 14 May 2003 10:12 Go to next message
Jonathan Wheat
Messages: 1
Registered: May 2003
Junior Member
I followed the example in theis site to connect to and oracle database, and I get this error :

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[[Oracle]][[ODBC]][[Ora]]ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

/oracle.asp, line 3

This is my line 3 :
OraDatabase.Open "dsn=ASPOracle;uid=wheat;pwd=wheat;"

I created a System DSN named ASPOracle with a service name of asp_oracle. I can TNSPING asp_oracle from the webserver so I have no idea why it's complaining.

Any ideas ?
Re: ASP connection to Oracle [message #76721 is a reply to message #76707] Mon, 26 May 2003 05:15 Go to previous messageGo to next message
Anand
Messages: 161
Registered: August 1999
Senior Member
Hi Please check the site www.4duysfromrolla.com.
somedays ago this site has featured a letter on ASP with Oracle
Re: ASP connection to Oracle [message #76869 is a reply to message #76707] Tue, 27 January 2004 21:14 Go to previous messageGo to next message
Deepak
Messages: 111
Registered: December 1999
Senior Member
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[[Microsoft]][[ODBC driver for Oracle]][[Oracle]]
/

I have got the above error while connecting asp page to the database please guide me to so that I can recover from that error

T Deepak Reddy
bangalor-32
Re: ASP connection to Oracle [message #340386 is a reply to message #76869] Tue, 12 August 2008 09:51 Go to previous message
blackmamba11
Messages: 8
Registered: August 2008
Junior Member
The info for setting up a linked server is attached here.
Seems like there is an issue with the client on the sql server.

[Updated on: Tue, 12 August 2008 09:52]

Report message to a moderator

Previous Topic: Report Server
Next Topic: Oracle Database 10.1.2.0.2
Goto Forum:
  


Current Time: Thu Mar 28 09:43:22 CDT 2024