Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

ODBC Question: How do you connect VB4 to oracle using 16-bit ODBC

We are trying to coonect VB4 to Oracle using 16-bit ODBC.  Standard code does not work.  Anybody have any ideas?  Do we have to use WIN95 APIs or is there standard way to get thru?
0
ramdan
Asked:
ramdan
  • 2
1 Solution
 
twardCommented:
You can use Oracle Objects for OLE which should be on the Client CDs with plenty of help.

I can also give some examples here, just let me know after installing Oracle Objects for OLE if you need examples, but the help that comes with it is pretty good.
0
 
ramdanAuthor Commented:
We need to use ODBC. Oracle objects for ole is too slow.

0
 
frankhommersCommented:
Hope this helps: And what "standard way" do you use?


Dim lDB as database
Dim lRS as recordset
Dim I as integer

   Set lDB = Workspaces(0).OpenDatabase("", False, False, "ODBC;")
   Set lRS = lDB.OpenRecordSet("SELECT * FROM yourtable", dbOpenDynaset, dbSQLPassThrough
Debug.Print "Contents of your query:"
While not lRS.EOF
  For I = 0 to lRS.Fields.Count - 1
  Debug.Print lRS.Fields(I)
  Next I
  lRS.MoveNext
Wend

0
 
twardCommented:
Oracle objects for OLE is no slower than ODBC.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now