Re: Oracle connection through ASP

I had the same thing happened to me intermitently with PHP scripts. You might want to check if the Oracle environment variables are properly set up, at least ORACLE_HOME.

Tony

gururuud_at_hotmail.com (Ruud) wrote in message news:<4db2e9a.0209190222.1db59b55_at_posting.google.com>...
> Hello,
>
> I'm using an ASP script to connect to an ORACLE database. I'm trying
> to connect with the following script:
>
> <%
> Set cnnOracle = Server.CreateObject("ADODB.Connection")
> strConn = "Provider=MSDAORA.1; Data Source=myDataSource; User
> ID=myUserID; Password=myPassword"
> cnnOracle.Open strConn
> %>
>
> However, i'm receiving the following error message all the time:
>
> Error Type:
> Microsoft OLE DB Provider for Oracle (0x80004005)
> Error while trying to retrieve text for error ORA-12154
> /FundPartners/Corporate/crm/index7.asp, line 8 (LINE 2 IN THE LINES
> SHOWN)
>
> The SQLnet.log gives the following:
>
> Fatal NI connect error 12560, connecting to:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\WINNT\System32\dllhost.exe)(HOST=EXCHANGE)(USER=IWAM_EXCHANGE))))
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
> 8.1.7.0.0 - Production
> Time: 18-SEP-2002 16:42:18
> Tracing not turned on.
> Tns error struct:
> nr err code: 0
> ns main err code: 12560
> TNS-12560: Message 12560 not found; No message file for
> product=NETWORK, facility=TNS
> ns secondary err code: 0
> nt main err code: 530
> TNS-00530: Message 530 not found; No message file for
> product=NETWORK, facility=TNS
> nt secondary err code: 126
> nt OS err code: 0
>
>
> Also by connecting through ORACLE ODBC I'm getting the ORA-12154
> error. Using MS ODBC for ORACLE gives all kind of MS errors...
>
> Any suggestions??!?!?!?
>
> Thanx
Received on Thu Sep 19 2002 - 12:22:05 CDT