Hi,
Newbie to form. I'm using ADODB and recordset with SQL to get data from an Oracle server. I can get the data but for some reason it's only pulling the first field from the database. I've been using a watch on rst.fields to see what i'm retrieving. Any ideas?
Dim Cnt As New ADODB.Connection
Dim rst As New ADODB.Recordset
dim glob_oracleConnect as string
dim ID_ref as string
glob_oracleConnect= "Provider=msdaora.1;Data Source=xxxxx;User Id=xxxm;Password=xxx;"
ID_ref = "DN001"
SQLString = "SELECT * FROM ATOLLADMINUMTS.CDMACELLS "
'Open connection to the database
Set Cnt = New ADODB.Connection
Cnt.Open glob_oracleConnect
'Open recordset based on Orders table
rst.CursorType = adOpenDynamic
rst.CursorLocation = adUseClient
rst.LockType = adLockOptimistic
rst.Open SQLString, Cnt, , , adCmdText
Bookmarks