I am using the code:-
strCon = "Driver={Microsoft ODBC for Oracle}; " & "SERVER= abc; uid=abc;pwd=abc;"
Dim oCon As Object
Set oCon = New ADODB.Connection
Dim oRs As Object
Set oRs = New ADODB.Recordset
oCon.Open strCon
while connecting this with installed oracle client it works
but without oracle client it doesnt work, i need this work without oracle client
pls reply urgently needed
Hi,
Installing Oracle Client In all the Client Machine is a Must. Instal , Configure Net Connection, Without that, u cannot access Oracle from Server....
This is according to my exprnce, I would like to know if any body has connected to Oracle without OraClient being installed..
REgards
Veena
Oracle Client must be installed in the client side to connect to the server. Without that it is not possibe to connect to the server.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.