DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: Oracle and .Net Advice needed

  1. #1
    Join Date
    Feb 2003
    Posts
    4

    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
  •  


Click Here to Expand Forum to Full Width