Oracle9i adodb ASP

[obislavu]

Hi,
I just running asp on the new installation of oracle9i. The Connection object is created successfully but the ,Open() is not working. The asp was working with oracle8i.
Could you help me ?
Thanks
george

 

[vbkris]

what is the error that is displayed?

Known is handfull, Unknown is worldfull

 

[obislavu]

Hi,
Thank you for your reply.
Here are the errors depending on the provider.
George
*****
Errors:
Data Provider := OraOLEDB.Oracle.1{
error is Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
}
Data Provider := MSDAORA.1
Error Type:{
Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle client and networking components were not found. These
components are supplied by Oracle Corporation and are part of
the Oracle Version 7.3.3 or later client software installation. Provider is
unable to function until these components are installed.
}

 

[vbkris]

o.k. this is a connection error, how do you connect to the database? do u use connection string or DSN file or ODBC?

Known is handfull, Unknown is worldfull

 

[obislavu]

Hi,
I use a connection string like :

' strconn="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=xasintfc;Password=ac;Data Source=hydro;Extended Properties="
' strconn="Provider=MSDAORA;User ID=xasintfc;Password=ac;Data Source=hydro"

There are no DSN defined.
Note that it is working well with Oracle 8i.
Thanks.

 

[onpnt]

from memeory oracle has version specific connection strings. so the fact that 8 was working I don't think has much relavance to this not working with 9. I'll search around for some strings and post if no one else comes with the solution

_________________________________________________________
_{$str = "sleep is good for you. sleep gives you the energy you need to function";
$Nstr = ereg_replace("sleep","coffee",$str); echo $Nstr;}

http://www.onpntwebdesigns.com

[/sub]

 

[vbkris]

do u think u can use a DSN file?

Known is handfull, Unknown is worldfull