472,950 Members | 2,254 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,950 software developers and data experts.

web app not connecting to oracle DB

I developed a web application about a year ago that connects to the Oracle
DB using MS ODBC for Oracle. But I had to move the whole application to a
brand-new PC . When I try to run I get the error:

"The Oracle(tm) client and networking components were not found. These
components are supplied by Oracle Corporation..."

I installed the Oracle client (v8i) and MDAC_TYP.EXE for any ODBC
components. Then I added Microsoft.Data.Odbc as a reference in the project.
What else should I do?

Thanks.
Nov 17 '05 #1
2 1614
I dont know much about oracle these days, but it used to use some horrible
tnsnames.ini file - or something like that - this file needed to have the
correct dsn entires listed for connecting to oracle. I would speak to your
DBA as he (she) will likely be able to help.

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"msnesw.microsoft.com" <VMI> wrote in message
news:%2***************@TK2MSFTNGP14.phx.gbl...
I developed a web application about a year ago that connects to the Oracle
DB using MS ODBC for Oracle. But I had to move the whole application to a
brand-new PC . When I try to run I get the error:

"The Oracle(tm) client and networking components were not found. These
components are supplied by Oracle Corporation..."

I installed the Oracle client (v8i) and MDAC_TYP.EXE for any ODBC
components. Then I added Microsoft.Data.Odbc as a reference in the
project. What else should I do?

Thanks.

Nov 17 '05 #2
the tnsnames file is definately the issue here, once your Oracle client is
working fine and dandy the Ole connection will work fine :o))
--
Of all words of tongue and pen, the saddest are: "It might have been"

Bill.Richards @ greyskin .co .uk
http://greyskin.co.uk
"John Timney (ASP.NET MVP)" wrote:
I dont know much about oracle these days, but it used to use some horrible
tnsnames.ini file - or something like that - this file needed to have the
correct dsn entires listed for connecting to oracle. I would speak to your
DBA as he (she) will likely be able to help.

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"msnesw.microsoft.com" <VMI> wrote in message
news:%2***************@TK2MSFTNGP14.phx.gbl...
I developed a web application about a year ago that connects to the Oracle
DB using MS ODBC for Oracle. But I had to move the whole application to a
brand-new PC . When I try to run I get the error:

"The Oracle(tm) client and networking components were not found. These
components are supplied by Oracle Corporation..."

I installed the Oracle client (v8i) and MDAC_TYP.EXE for any ODBC
components. Then I added Microsoft.Data.Odbc as a reference in the
project. What else should I do?

Thanks.


Nov 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Wayne Happ | last post by:
I have Oracle 9 running on a Linux RedHat Box V9.0. But I'm having trouble connecting from a windows machine via PL/SQL Develover. When I startup the application the instance name appears but...
0
by: Kong Li | last post by:
Follow up to this thread, the latest Oracle 9i release 2 patchset (9.2.0.5) fixed the handle count leak problem. The problem is in Oracle client component. Thanks. Kong ----- From: Kong...
1
by: yahibble | last post by:
Now, I am no Python expert but I have dabbled and I have spent a couple of days with another engineer unsuccessfully installing oracle drivers for MS ODBC on the win XP machine. It looked to me...
2
by: Mahesh.V | last post by:
Hi All I get the following error while connecting to the oracle database using ODBC. in my VB.NET application. Can any one help me out solving this problem server message (if any):...
2
by: python_eager | last post by:
Hi i am connecting my database oracle 9i. While connecting i am getting the following error connection = cx_Oracle.connect("myusername", "mypassword", "python") RuntimeError: Unable to acquire...
0
by: antonyliu2002 | last post by:
I am having a hard time connecting to an oracle database from within Visual Web Developer (VWD) 2005 Express Edition. Check out the screen snap shot here: ...
2
by: rcc.gamer | last post by:
Hello All, I am trying to connect a GridView to an Oracle table using the standard SqlDataSource. The process is fairly simple and there are detailed instructions from Microsoft ......
0
by: Temporary | last post by:
C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time I have a Web Service, written in C#, published on a Windows XT Web Server under IIS, which repeatedly connects to an...
1
by: kinnu | last post by:
hi, could any one help me with the steps of connecting the vb form with the oracle database/table. I could connect vb to access. as my collage project requires connecting of vb with oracle...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.