| unable to connect to oracle [message #103573] |
Mon, 19 January 2004 02:35 |
lalrajkumar
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
I am connecting to oracle database through driver ORACLE ODBC DRIVER in asp.Here is my code
Dim mOraSession
Dim mOraDatabase
Dim mDynGetNames
Dim sSQL
Set mOraSession = CreateObject("OracleInProcServer.XOraSession")
Set mOraDatabase = mOraSession.DBOpenDatabase("oo4odriver2", "coaesg/esguser", 1)
sSQL = "Begin pkg_rectype.retrieve_data(:coa_data); end;"
Set mDynGetNames = mOraDatabase.CreatePlsqlDynaset(sSQL,"coa_data", ORADYN_DEFAULT)
It gives error
Oracle Automation (0x800A01B8)
Unable to make connection, ORA-12154: TNS:could not resolve service name
But the TNS entry is proper.Able to connect to database using other drivers like microsoft odbc driver for oracle...
Please help
Thanks
Raj.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
