I am using a simple application to check the connection from VB6 to Oracle 10g and I getting this error and these are the connection parameters I entered as
Global Const Oracle_Conn= "Provider=OraOLEDB.Oracle;
Source=xxxx999;initial catalog=DVDB01;Fetch Size = 200; CacheType=File;"
and this the code I wrote for fetching the data . Can anyone please tell me where I am going wrong as earlier I had another issue so I un-installed Oracle and re-installed it but since then
I am getting this porblem. Anyhelp would be greatly appreciated .
Private Sub Command3_Click()
Private Sub get_Oracledata()
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim strSQL As String
Set cnn = New ADODB.Connection
cnn = Oracle_Conn
'cnn.CommandTimeout = 400 ' added
MsgBox "conn open now"
strSQL = "Select count(*) from tbl_T108"
rst.Open strSQL, cnn
If (rst.RecordCount > 0) Then
MsgBox " true"
MsgBox " False"