Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Vfp50 - Can I connect to a database on a Unix box ?
Message
 
 
À
08/07/1997 13:37:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00038933
Message ID:
00039003
Vues:
40
>
>Hi Vladimir and thanks for you answer...
>How does vfp get mapped to the unix box?

Robert:

You really can not map to the Unix in the Novell mapping sense of the word. I am also basing this reply on the assumption the database on the Unix is in ORACLE. First, you have to install SQL*Net (preferrably v2.x) and a TCP/IP address on the client. The Oracle ODBC drivers use SQL*Net to communicate between VFP and Oracle. The "listener" version of SQL*Net has te be running on the Unix server. This is handled/managed by your Unix Administrator and Oracle DBA. You also have to set up what is called a TNSNAMES.ORA file (for SQL*Net v2.x) on the client. The Oracle client products for Windows/Win95 CD-Rom is used to install and configure SQL*Net and whatever other Oracle Products you are licensed to install. All of this is usually placed in a C:\ORAWIN or C:\ORAWIN95 directory structure. The TNSNAMES.ORA file would be placed in a C:\ORAWIN(95)\NETWORK\ADMIN directory. Again, you would need an Oracle DBA to help properly set up this file.

Once all of this is done, you can identify the data source in your ODBC Administrator by adding an Oracle data source, name and connect string. The connect string is dependent on the Oracle SID in the TNSNAMES.ORA file.

Finally, you would create a new connection in VFP identifying this ODBC data source on the connection form. This connection is part of a Database Container, so you need to open a DBC first (or create a new one) then create a connection. You can then create a remote view using that connection.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform