Re: MSDAORA and Oracle 8.1.7 - problems establishing connection

"TurkBear" <jgreco1_at_mn.rr.com> wrote in message news:kn04au0k2mt7rpcj17jdukqh7rm3902g02_at_4ax.com...
>
>
> matt.mcdonnell.90_at_bc.edu (Matt Man) wrote:
>
> >I am running the 8.1.7 Client from an NT box trying to connect to an
> >8.1.7 Server running on Win2K.
> >
> >Net8 Assistant has no problems connecting to the database and with
> >some troubleshooting, the Oracle ODBC driver works fine, while the MS
> >ODBC driver for Oracle however will not... is there a related issue
> >here?
> >
> >I've been pouring over the archived newsgroups for the past 24 hours
> >and still cannot find a solution to my problem. I have put in the
> >TRS_ADMIN registry key, I've double and triple checked my tnsnames.ora
> >file and I've even added the service name to my local hosts file
> >(although I'm confident that this doesn't change anything anyway)
>
> I'm assuming you meant to type TNS_ADMIN

I did....

> >
> >There's a chance I might solve this by using OraOLEDB.Oracle
> >instead... but I wonder if there isn't a simpler solution. Switching
> >to OraOLEDB.Oracle now would blow-up my testing efforts.
> >
> >Any help would be GREATLY appreciated.
> >
> >Matt Man
> I use the MSDAORA Provider for my asp pages and have had no problems
connecting to a variety
> of Oracle versions..
>
> The code I use in my pages is:
> <%
> Dim objDC, objRS
> ' Create and establish data connection
> Set objDC = Server.CreateObject("ADODB.Connection")
> objDC.ConnectionTimeout = 15
> objDC.CommandTimeout = 30
>
> 'Code to connect to Oracle Warehouse
> objDC.Open "Provider=MSDAORA.1;Password=secret;User ID=nosy;Data
Source=whs1;Persist Security Info=TRUE"

MSDAORA.1? what's the .1 for?

>
> SqlStrEmp = "Select distinct empl_nm,empl_nbr empnbr from
warehouse.hr_public order by empl_nm"
> Set RS1 = objDC.Execute(SqlStrEmp)
> .....
> %>
>
> where whs1 is the tnsnames.ora entry
>
> Works fine..
>
> What are you using to test your setup?
>

Well.. .that was sort of another question that I had. The code works fine for an 8.0.5 server, so I'm wondering if there's something else... but I'm not sure where to look.

>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Thu Mar 28 2002 - 04:48:37 CST