I have written a macro, that gets connect to a database run a query and copy the recordset in to an excel. Its working fine in my PC and when I tried to run in others PC its give the above error.
This the code that I have written to connect to DB:
Dim oconn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL, strsql1, As String
strSQL = " select * from srprod_strategic_all_val"
strsql1 = "select * from srprod_strategic_all_Inval"
Set oconn = New ADODB.Connection
oconn.Open "Provider=msdaora;Data Source=CALPRO.WORLD;User Id=PRESTAGE;Password=pre#pr33;"
/* its giving error at the above line when I run in others PC*/
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
rs.LockType = adLockOptimistic
rs.Open strSQL, oconn, , , adCmdText
The total eoor message is:
Run-time error 2147467259 (80004005)
The Oracle(tm) Client and Networking Components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3(or greater) Client Software Installation.
Provider is unable to function until these components are installed.
Could anyone please help me in resolving this?