Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle 7 and 8 Drivers for W2K
Message
 
 
À
21/08/2000 14:37:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00402327
Message ID:
00407481
Vues:
28
Good deal. Thanks for posting your solution.

>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.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform