ADO and Oracle 8.1.7

[Michael]

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

[Paul Clement]

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)

[Maurizio]

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