Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I finally got things working in W2K. It's a little tricky. The Microsoft Oracle driver will work, but it needs to be set up using the connection string builder. There is a problem in the VFP connection dialog because it does not ask you for the appropriate information; the final field asks for 'database' and not 'server'; however, if you try to connect leaving all the fields empty except the DNS, the Microsoft driver will give you a different dialog asking for "Server" rather than "Database" and this will work. You can set up a permanent connection using the connection string builder or the following syntax:
DRIVER={Microsoft ODBC for Oracle};UID=yourID;PWD=yourpassword;SERVER=yourserver.world;
I've tested the Microsoft driver against the Oracle driver and it's considerably faster. Retreiving 20,786 records from an Oracle database took 97 seconds with the Oracle driver and 42 seconds with the Microsoft driver.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement