Re: Oracle Database and VB6

Hi Ralph ,

Actually , i am not sure . Any undesired problem using ODBC to connect to Oracle Database ? Other ways to connect to Oracle beside ODBC ?
I have another questions :
Did i need to install Oracle Client in client PC so that VB6 can connect to Oracle DB via ODBC ? Or i just setup the ODBC data source name and the Oracle ODBC driver in the client PC and everything are OK , similar to connectiong to Access Database .

Thanks

- weetat



Ralph wrote: 
"weetat" <test@xxxxxxxxxxxxxx> wrote in message
news:uwzKpFbkFHA.3656@xxxxxxxxxxxxxxxxxxxxxxx

Hi all ,

   I am using VB 6 in W2K SP 4 OS .
   Any sample code in connecting to Oracle Database in the VB 6 ?
   Where can i download the Oracle ODBC driver so my program can
connect to the Oracle Database in my VB 6 application ?

Thanks in advance.

- weetat 


Are you sure you want to use ODBC?
If so this (though a little dated) will get you started with DAO and ODBC.
http://www.ilook.fsnet.co.uk/vb/vboracls.htm

You will find drivers on your Oracle Client CD. You can download the latest
Oracle drivers/providers etc, from the Oracle Support Site. Your admin
should be able to fetch them for you if you don't have access. There are
also MS versions included with the MDAC as well as some excellent 3rd party
stuff ($$$$).

If you do a Google query for sample code you should find something in the
aproximately half-million results that will be returned to help you craft
your solution.

Be aware that Oracle provides a number of different access methods/libraries
(ODBCDirect, ODBC, OO4O, OLE DB, ...), not all of them support the same
features nor will exhibit the same performance for similar features -
depending on data types and other factors you may want to use an alternate
scheme.

hth
-ralph



.