ADO and Oracle 8.1.7


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: ADO and Oracle 8.1.7

  1. #1
    Michael Guest

    ADO and Oracle 8.1.7


    We are going to migrate from Oracle 7.3.1 to Oracle 8.1.7.
    With version 7.3.1 I used this connection string :

    DBTarget.open "PROVIDER=MSDAORA;DATA SOURCE=DatabaseName.world;USER ID=SYSADM;PASSWORD=SYSADM"

    this connection string worked well with Oracle 7.3.1, but when I try to execute
    the same program with the same connection string using Oracle 8.1.7, it doesn't
    work, it shows an error message telling me that it can't connect to the database.
    So I would like to know if I have to change the connection string to connect
    to an Oracle 8.1.7 database.

    Thank you all

  2. #2
    Paul Clement Guest

    Re: ADO and Oracle 8.1.7

    On 21 Dec 2001 09:54:35 GMT, "Michael" <mmga@libero.it> wrote:


    We are going to migrate from Oracle 7.3.1 to Oracle 8.1.7.
    With version 7.3.1 I used this connection string :

    DBTarget.open "PROVIDER=MSDAORA;DATA SOURCE=DatabaseName.world;USER ID=SYSADM;PASSWORD=SYSADM"

    this connection string worked well with Oracle 7.3.1, but when I try to execute
    the same program with the same connection string using Oracle 8.1.7, it doesn't
    work, it shows an error message telling me that it can't connect to the database.
    So I would like to know if I have to change the connection string to connect
    to an Oracle 8.1.7 database.

    Thank you all

    Shouldn't need to change the connection string. It sounds as if it's a configuration problem on the
    client. Is the TNSNAMES.ORA set up properly.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  3. #3
    Maurizio Guest

    Re: ADO and Oracle 8.1.7


    Try This :

    DBTarget.open "PROVIDER=OraOLEDB.Oracle;DATA SOURCE=DatabaseName.world;USER
    ID=SYSADM;PASSWORD=SYSADM"

    Regards

    Maurizio

    "Michael" <mmga@libero.it> wrote:
    >
    >We are going to migrate from Oracle 7.3.1 to Oracle 8.1.7.
    >With version 7.3.1 I used this connection string :
    >
    >DBTarget.open "PROVIDER=MSDAORA;DATA SOURCE=DatabaseName.world;USER ID=SYSADM;PASSWORD=SYSADM"
    >
    >this connection string worked well with Oracle 7.3.1, but when I try to

    execute
    >the same program with the same connection string using Oracle 8.1.7, it

    doesn't
    >work, it shows an error message telling me that it can't connect to the

    database.
    >So I would like to know if I have to change the connection string to connect
    >to an Oracle 8.1.7 database.
    >
    >Thank you all



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center