Hi Mark!
I'm going to use VFPRO 9 SP2.
I'm a newbie in ODBC and right know
I'm studying the 3 big standards for ODBC
(MSSQL, Oracle, MySQL) knowing the
differences/capabilities the pros/cons.
I'm from the middle old school from the
era of DOS dBase III Plus/Clipper and
I've been out of serious programming for
a while. VFPRO is easier for me because the
code language is similar to clipper.
So, if you can point me in the right direction
where I can find good documentation about SQL,
on the web, I will appreciate a lot.
Thanks for your reply.


>>Hi.
>>Is ODBC the best way to connect to Oracle?
>>Where I find the driver?
>>Thanks!
>
>First you need to install a Client from Oracle including the Windows Interfaces component (only done on a Custom Client install). Then you can use the ORacle ODBC driver or the Microsoft ODBC for Oracle driver that is typically installed with the MDAC kits (Microsoft Data Access Components) I think.
>
>Create a DSN found in the ODBC Data Sources under Administrative Tools. I also think I have an ODBC file in the UT downloads here that I developed for connecting using VFP.
>
>What dev tool are you going to use to connect to Oracle with?