Re: Connect to Oracle via ASP/ADO on NT IIS Web Server

Which version of oracle are u using?

As far as I recall .. u need at least Oracle 7.3.3 (Anyone - plz correct me if i m wrong)

It is possible to edit tnsnames.ora file manually (in a text editor).

SALz
//

In article <8o6mqp$po1$1_at_new-proxy.bscc.bls.com>,   "Michael Gardner" <gardnerm_at_bscc.bls.com> wrote:
> Here's what I know from reading learnasp.com and askasp.com:
> - Have SQL*Net installed on NT IIS Server
> - Configure tnsnames.ora file using SQL*Net
> - Use MS ODBC Driver 2.5xxxx rather than Oracle supplied
 driver
>
> The confilct:
> Oracle's site says SQL*Net is replaced by Net8. Can't find
 and info
> on above asp sites on Net8. They do have walkthroughs setting up with
> SQL*Net.
>
> I have about 20 Oracle disks that our in house Oracle "Expert" gave
 me, none
> of them appear to have SQL*Net. I downloaded and installed the Oracle
> Enterprise manager (253 meg!). It also installed Net8. I went
 through the
> setup and can see the database with SQL Plus. When I go to Control
 Panel,
> ODBC, Create New, Pick the "MS ODBC for Oracle 2.5xxx", I still get
 the
> error: "Oracle client and networking components were not found..."
>
> Bottom line:
> If Net8 replaces SQL*Net, why can't I create the ODBC
 connection? Do I
> still have to use SQL*Net instead? If so, where can I get it. I
 can't find
> it on any of the Oracle CDs, or on their site. I'm looking for the
 minimum
> Oracle component install to have to put on the IIS machine.
>
> Thanks for the help.
>
> P.S. Isn't there a faq on this anywhere? Seems like it would be a
 common
> thing.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 25 2000 - 16:42:09 CDT