Hello Everybody,

This is a 2 parts question. I have not worked with Sybase and Oracle thru
VB
before, and I am having problem getting a returned recordset from these two
databases (by the way, the similar code works on SQL Server).

Sybase Problem:
'//code starts
acnSybase.Open "Provider=MSDASQL.1;Password=(password);Persist Security
Info=True;" & _
"User ID=(userid);Data Source=(DSN)"
acnSybase.CommandTimeout = 3360

Set arsData = New ADODB.RecordSet
strSQL = "SELECT ......"
arsData.Open strSQL, acnSybase, adOpenDynamic, adLockOptimistic
'//code ends
I am getting error message of "ODBC driver does not support the requested
properties" at the arsData.Open line. The connection was tested okay.
There must be something on my arsData.Open that Sybase does not like, and I
don't know what it is.


Oracle Problem:
'//code starts (in different module)
acnSybase.Open "Provider=MSDASQL.1;Password=(password);Persist Security
Info=True;" & _
"User ID=(userid);Data Source=(DSN)"

acnOracle.Open "Provider=MSDAORA.1;Password=(password);User
ID=(userid);Data Source=(server name);" & _
"Persist Security Info=True"
acnOracle.CommandTimeout = 3360

Set arsData = New ADODB.RecordSet
strSQL = "SELECT ........ "
arsData.Open strSQL, acnOracle, adOpenDynamic, adLockOptimistic

Set acnMyDB = New ADODB.Connection
acnMyDB.Open "Provider=SQLOLEDB.1;Password=;Persist Security Info=True;"
& _
"User ID=sa;Initial Catalog=ATS;Data Source=(local SQL
Server name)"
acnMyDB.CommandTimeout = 3360

If arsData.EOF = True Then 'the data cannot be found in this database
acnMyDB.Execute "INSERT INTO ......" 'set a dummy record
Exit Sub
End If
'//code ends
Again, there is no problem with the connection to Oracle and no problem with
the arsData.Open. But my application hangs at the "If arsData.EOF"
statement. Does anyone know why?

Any help will be very much appreciated.