Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle 7 and 8 Drivers for W2K
Message
 
 
To
21/08/2000 14:37:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00402327
Message ID:
00407481
Views:
27
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
Previous
Reply
Map
View

Click here to load this message in the networking platform