Hi,
I cannot make a connection to oracle database from VB6 using ado.
First i tried to make a dsn connection. The code that i have is:

Dim cn As ADODB.Connection
Dim strConnection As String
Dim adStatus As ADODB.EventStatusEnum
Set cn = New ADODB.Connection

strConnection = "DSN=atdb;UID=atedb;PWD=atdb;"
cn.Open strConnection
If adStatus = adStatusOK Then
MsgBox "Connected ok"
Else
MsgBox "Connection not made"
End If

Then i tried making a dsn-less connection.The code that i tried is :

strConnection = "Server=dwtest.world;driver={Microsoft ODBC for Oracle};UID=atdb;PWD=atdb;"
cn.Open strConnection

But it did'nt work either!I tried connecting through the
Visual Data Manager and the Data Environment. But it did not work. I know that the user_id, the password and the server name are right as i can log in through SQLPlus.
Am i missing out something? Please help..