MS-Access Oracle Connectivity.

[mohit00m]

Hi Guys,

I have been struggling to make my MS-Access to Oracle connectivity program work on one of the users PC.

Below code works fine on my PC, but due to Oracle Client version conflict keep getting "The Oracle(tm) client and networking components were not found error" on users pc. Tried re-installing all Oracle client instances , but keep getting same problem again and again.

So tying to understand what could be wrong, just to drill down the problem , was planning to find out different ways of Oracle-MS-Aaccess connectivity - without having to install oracle client or some sort of creating a package which installs Oracle and makes everyone happy. Any thought or comments would be great help ...


Set conn = CreateObject("ADODB.Connection")

With conn

.ConnectionString = "Driver={Microsoft ODBC for Oracle}; CONNECTSTRING=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vip.svr.test.jtcom.net)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=TC4U01)));User Id= tc4_uat1;Password= Pa55word;"

.Open

End With

Regards,

 

[PHV]

Have a look here:

http://www.connectionstrings.com/oracle

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JoeAtWork]

I would first establish whether you can make a connection to Oracle through ODBC Administrator. If you can't, then it is a basic connectivity issue that has to be worked out.