Greting;

   Can as follow helps:

      DIM server_name as NEW STRING
      DIM service_name as NEW STRING

      server_name = <<name of the server where database located>>
	service_name = << service name (SID name) defined in the net 8
configuration>>

	connectionStr = "driver={ORACLE ODBC DRIVER};" & _
        "Data Source=server_name;Initial Catalog=service_name;User
Id=user_id;Password=user_passwd; "

Thanks.
-----Original Message-----
From: Corey Smith [mailto:corey.smith@t...]
Sent: 06 September 2000 22:28
To: professional vb
Cc: Doug Norberg
Subject: [pro_vb] Microsoft OBDC for Oracle


Hi everyone,
I am trying to distribute an application that uses ADO and Microsoft OBDC
for Oracle and I am getting an error message during the database open that
I can't seem to rectify,  the error is :  [Microsoft][ODBC driver for
Oracle][Oracle]Error while trying to retrieve text for error ORA-12154.
The documentation I've seen has all said that I haven't configured
tnsnames correctly but I know I have since I can log on with my development
 machine.   My distribution app loads MDAC 2.5 on the host machine so I
should have all the right ODBC drivers.
Does anyone know of a reason for this error message?
Any help would be greatly appreciated.
Thanks
Corey