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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.