Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
oracle
- Thread starter wystan
- Start date
I only have VFP6 and don't have Oracle, but I think that the principle is the same. Create an ODBC connection to the database and remote views and go to town. The ODBC connections can be created directly in the Window's Settings Control Panel, or you can do it in VFP. I note that a book I have on VFP 3 mentions windows having 16 bit ODBC drivers for Oracle, so I assume by now they have 32 bit ones.
You can also use ADO to access foreign databases, but it's a bit more complicated than using ODBC.
Dave Dardinger
You can also use ADO to access foreign databases, but it's a bit more complicated than using ODBC.
Dave Dardinger
Hi!
Before creating the ODBC connection, you require to install the Oracle Client tools. Than run network configuration assistant and define the listener and the data service. Specify the data service name when creating the ODBS data source or specify it as a server name in the connection string for the connection in the VFP database.
Vlad Grynchyshyn
vgryn@softserve.lviv.ua
The professional level of programmer could be determined by level of stupidity of his/her bugs
Before creating the ODBC connection, you require to install the Oracle Client tools. Than run network configuration assistant and define the listener and the data service. Specify the data service name when creating the ODBS data source or specify it as a server name in the connection string for the connection in the VFP database.
Vlad Grynchyshyn
vgryn@softserve.lviv.ua
The professional level of programmer could be determined by level of stupidity of his/her bugs
- Status
Similar threads
- Locked
- Question