-
Oracle and .Net Advice needed
The following word doc explains the situation with screenshots
www.valont.com/DBproblem.doc
right click and save target as
Pls advice
Heres the Text version of my problem:
"Trouble accessing and extracting data from database.
Situation:
We’re supposed to connect to the test Database(Oracle 9i) in a remote server from a local PC using VB.net.
The 2 providers we tested are:
Microsoft OLE DB provider for Oracle
Microsoft OLE DB provider for ODBC drivers
We’re not sure if they are the correct ones to be used.
When we tested the connection with “Microsoft OLE DB provider for Oracle”. The following data link error was prompted.
Error message :
“Test connection failed becos of an error in initializing provider. Oracle 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 later client software installation. Provider is unable to function until these components are installed.”
Next we tested the connection with “Microsoft OLE DB provider for ODBC drivers”.( which is also another driver for .NET and Oracle). The connection test was successful. We are able to preview the tables in the DB
However, when we try to drag a table from the solution explorer into the web-form the following error was shown.
Error message : “You cannot use an OLE DB provider for ODBC drivers.”
Please recommend us any drivers you think would be appropriate to connect Microsoft visual studio .NET and Oracle DB that is currently being used.
Also should we install the driver in our local PC or in the remote server side where the DB is located?
Also we’re not sure about what the problem really is. Please advice us and provide us with any assistance.
"
thnx in advance
Last edited by valont; 03-12-2003 at 02:05 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|