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
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
