connect to oracle db without oracle client in VB6

[dssengar]

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

[QVeen72]

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

[debasisdas]

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.