|
 |
asp_databases thread: ASP to Oracle connectivity
Message #1 by Mangalam Ganesh <mangalamr@y...> on Tue, 22 May 2001 00:54:27 -0700 (PDT)
|
|
I have Oracle ODBC drver installed on my web server
(IIS).
-DSN has been created.
-For security reasons i CANNOT install oracle client
on this machine.
-I am trying to connect to the db using a connect
string in my ASP.
-Its gives me error
Microsoft OLE DB Provider for Oracle error '80004005'
The Oracle(tm) 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 greater) client software installation. You will be
unable to use this provider until these components
have been installed.
/abc/database.asp, line 6
Whats the Solution to this???
Thanks & regards,
Mangalam.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
Message #2 by "Charles Feduke" <webmaster@r...> on Tue, 22 May 2001 08:30:49 -0400
|
|
> The Oracle(tm) 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 greater) client software installation. You will be
> unable to use this provider until these components
> have been installed.
Back when I [foolishly] tried to use Oracle with something other than
Oracle software (VB), I ran into this same exact problem. It simply would
not let me connect. At that time I made the assumption that all clients
would have to have Oracle client software installed on their machines to use
my program, which made little sense to me.
I tried to find a solution, but couldn't. The real show stopper was when I
installed SQL Navigator, a 3rd party tool that works with Oracle server-side
software, but simply would not run without the Oracle client installed.
If you find the way to do it off list, then please share.
- Chuck
> -----Original Message-----
> From: Mangalam Ganesh [mailto:mangalamr@y...]
> Sent: Tuesday, May 22, 2001 3:54 AM
> To: ASP Databases
> Subject: [asp_databases] ASP to Oracle connectivity
>
>
> I have Oracle ODBC drver installed on my web server
> (IIS).
>
> -DSN has been created.
> -For security reasons i CANNOT install oracle client
> on this machine.
> -I am trying to connect to the db using a connect
> string in my ASP.
> -Its gives me error
>
> Microsoft OLE DB Provider for Oracle error '80004005'
>
> The Oracle(tm) 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 greater) client software installation. You will be
> unable to use this provider until these components
> have been installed.
>
> /abc/database.asp, line 6
>
> Whats the Solution to this???
>
> Thanks & regards,
> Mangalam.
>
>
>
Message #3 by "Dallas Martin" <dmartin@z...> on Tue, 22 May 2001 09:52:51 -0400
|
|
I don't think you can connect to an Oracle DB without SQLNET installed
on the client. The Oracle client side driver looks for two configurations
files
on the client.
----- Original Message -----
From: "Charles Feduke" <webmaster@r...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, May 22, 2001 8:30 AM
Subject: [asp_databases] RE: ASP to Oracle connectivity
> > The Oracle(tm) 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 greater) client software installation. You will be
> > unable to use this provider until these components
> > have been installed.
>
> Back when I [foolishly] tried to use Oracle with something other than
> Oracle software (VB), I ran into this same exact problem. It simply would
> not let me connect. At that time I made the assumption that all clients
> would have to have Oracle client software installed on their machines to
use
> my program, which made little sense to me.
>
> I tried to find a solution, but couldn't. The real show stopper was when
I
> installed SQL Navigator, a 3rd party tool that works with Oracle
server-side
> software, but simply would not run without the Oracle client installed.
>
> If you find the way to do it off list, then please share.
>
> - Chuck
>
> > -----Original Message-----
> > From: Mangalam Ganesh [mailto:mangalamr@y...]
> > Sent: Tuesday, May 22, 2001 3:54 AM
> > To: ASP Databases
> > Subject: [asp_databases] ASP to Oracle connectivity
> >
> >
> > I have Oracle ODBC drver installed on my web server
> > (IIS).
> >
> > -DSN has been created.
> > -For security reasons i CANNOT install oracle client
> > on this machine.
> > -I am trying to connect to the db using a connect
> > string in my ASP.
> > -Its gives me error
> >
> > Microsoft OLE DB Provider for Oracle error '80004005'
> >
> > The Oracle(tm) 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 greater) client software installation. You will be
> > unable to use this provider until these components
> > have been installed.
> >
> > /abc/database.asp, line 6
> >
> > Whats the Solution to this???
> >
> > Thanks & regards,
> > Mangalam.
>
Message #4 by "Philip Tham" <philipt1@h...> on Tue, 22 May 2001 09:47:36 -0500
|
|
This is what we do in making connection to Oracle DB from MS Web Server:
From MS-Server level:
1) Your Oracle DBA has to install the TNS service on your web server
2) You will then create a DNS name if you wish.
From Oracle DB level:
1) Your DBA has to setup an account for your web server to access via TNS
From your ASP page level:
1) use the DNS connect or
2) make direct connection example: using MS ODBC for Oracle
conn.Open "PROVIDER=MSDASQL;" & _
"DRIVER={Microsoft ODBC for Oracle};" & _
"SERVER=your TNS name;" & _
"USER ID=theuserid;PASSWORD=thepassword;"
I hope this help a little
Philip
----- Original Message -----
From: "Dallas Martin" <dmartin@z...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, May 22, 2001 8:52 AM
Subject: [asp_databases] RE: ASP to Oracle connectivity
> I don't think you can connect to an Oracle DB without SQLNET installed
> on the client. The Oracle client side driver looks for two configurations
> files
> on the client.
>
>
> ----- Original Message -----
> From: "Charles Feduke" <webmaster@r...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Tuesday, May 22, 2001 8:30 AM
> Subject: [asp_databases] RE: ASP to Oracle connectivity
>
>
> > > The Oracle(tm) 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 greater) client software installation. You will be
> > > unable to use this provider until these components
> > > have been installed.
> >
> > Back when I [foolishly] tried to use Oracle with something other than
> > Oracle software (VB), I ran into this same exact problem. It simply
would
> > not let me connect. At that time I made the assumption that all clients
> > would have to have Oracle client software installed on their machines to
> use
> > my program, which made little sense to me.
> >
> > I tried to find a solution, but couldn't. The real show stopper was
when
> I
> > installed SQL Navigator, a 3rd party tool that works with Oracle
> server-side
> > software, but simply would not run without the Oracle client installed.
> >
> > If you find the way to do it off list, then please share.
> >
> > - Chuck
> >
> > > -----Original Message-----
> > > From: Mangalam Ganesh [mailto:mangalamr@y...]
> > > Sent: Tuesday, May 22, 2001 3:54 AM
> > > To: ASP Databases
> > > Subject: [asp_databases] ASP to Oracle connectivity
> > >
> > >
> > > I have Oracle ODBC drver installed on my web server
> > > (IIS).
> > >
> > > -DSN has been created.
> > > -For security reasons i CANNOT install oracle client
> > > on this machine.
> > > -I am trying to connect to the db using a connect
> > > string in my ASP.
> > > -Its gives me error
> > >
> > > Microsoft OLE DB Provider for Oracle error '80004005'
> > >
> > > The Oracle(tm) 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 greater) client software installation. You will be
> > > unable to use this provider until these components
> > > have been installed.
> > >
> > > /abc/database.asp, line 6
> > >
> > > Whats the Solution to this???
> > >
> > > Thanks & regards,
> > > Mangalam.
> >
>
|
|
|
View Cart
