Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Choose Oracle Version

Reply
Thread Tools

Choose Oracle Version

 
 
Colin Steadman
Guest
Posts: n/a
 
      08-17-2004
I've just had a problem with an ASP page not connecting to
one of our Oracle databases. It turns out that the web
server has Oracle 8.1 and Oracle 9.2 installed and that my
ASP page was trying to connect with Oracle 8.2. The
TNSNAMES.ORA file for this version of Oracle is not
maintained and did not have the correct entry I need.

Is it possible to force my ASP pages to use Oracle 9.2
until the migration is complete and Oracle 8.1 is removed?

My connection string looks like this:

Session("PROVIDER") = "Provider=OraOLEDB.Oracle;Data
Source=ht;User Id=" + Request.form("username")
+ ";Password=" + Request.form("password")

TIA,

Colin


 
Reply With Quote
 
 
 
 
Cowboy \(Gregory A. Beamer\) [MVP]
Guest
Posts: n/a
 
      08-17-2004
The TNSNames.ora has to be maintained for this server, as there is no way to
tell ASP to use only the 9.2 server on a particular box with multiple
instances, at least none that I know of. The MS world realizes it is looking
at Oracle, but really does not care whether the instance is 8.1 or 9.2.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Colin Steadman" <(E-Mail Removed)> wrote in message
news:781e01c48449$41669f20$(E-Mail Removed)...
> I've just had a problem with an ASP page not connecting to
> one of our Oracle databases. It turns out that the web
> server has Oracle 8.1 and Oracle 9.2 installed and that my
> ASP page was trying to connect with Oracle 8.2. The
> TNSNAMES.ORA file for this version of Oracle is not
> maintained and did not have the correct entry I need.
>
> Is it possible to force my ASP pages to use Oracle 9.2
> until the migration is complete and Oracle 8.1 is removed?
>
> My connection string looks like this:
>
> Session("PROVIDER") = "Provider=OraOLEDB.Oracle;Data
> Source=ht;User Id=" + Request.form("username")
> + ";Password=" + Request.form("password")
>
> TIA,
>
> Colin
>
>



 
Reply With Quote
 
 
 
 
Colin Steadman
Guest
Posts: n/a
 
      08-18-2004
"Cowboy \(Gregory A. Beamer\) [MVP]" <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> The TNSNames.ora has to be maintained for this server, as there is no way to
> tell ASP to use only the 9.2 server on a particular box with multiple
> instances, at least none that I know of. The MS world realizes it is looking
> at Oracle, but really does not care whether the instance is 8.1 or 9.2.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA




OK Gregory, thank you.

Colin
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Where to get stand alone Dot Net Framework version 1.1, version2.0, version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? MowGreen [MVP] ASP .Net 5 02-09-2008 01:55 AM
Re: Where to get stand alone Dot Net Framework version 1.1, version 2.0, version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? PA Bear [MS MVP] ASP .Net 0 02-05-2008 03:28 AM
Re: Where to get stand alone Dot Net Framework version 1.1, version 2.0, version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? V Green ASP .Net 0 02-05-2008 02:45 AM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
Oracle adapter don't work with Oracle 10.1.0.2 v. Client vaidas gudas ASP .Net 1 10-11-2004 01:11 PM



Advertisments