General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only