ODBC Visual FoxPro

[ConvertFromOldNGs]

by Peter Gallagher >> Fri, 24 Mar 2000 4:53:04 GMT

Hi, looking for someone who might know how to get the ExternalDatabase connection working for Visual FoxPro. I know that this is one of the Jade Unsupported "OEM" databases, however that has not stopped us connecting to other non-supported ODBC sources in the past.

The External Database wizard works fine - The problem comes when actually trying to get the data from inside a method
E.g. using an external Customer Table

vars
exDB : ExternalDatabase;
exCustomerSet : ExCustomerSet;
exCustomer : ExCustomer;begin

exDB := app.getExternalDatabase("ExternalDB");
exDB.open;
create exCustomerSet;
foreach exCustomer in exCustomerSet do
endforeach;
exDB.close;
end;

This doesn't work, like it does for ODBC links that we do have working...

Error Code 8000, ODBC error HYC00

Any thoughts...

Peter Gallagher

[ConvertFromOldNGs]

by James Plank Icon Communications >> Fri, 24 Mar 2000 6:00:43 GMT

We moved from Foxpro 2.6 to Visual Fox to Jade
Wanted to do exactly as you, but the only sucess we had was via Access97 linking to the Fox files, and this wasnt adequate.I gave up trying to access the legacy Fox data.
Good hunting

[ConvertFromOldNGs]

by Krull >> Mon, 27 Mar 2000 4:13:32 GMT

Peter,

If you can supply some further information, we may be able to help. The output from a JADE SQL and an ODBC trace will show the cause of the problem. The relevant diagnostic tracing can be enabled as follows:

1) To enable JADESQL tracing:
Add a parameter JADESQL=1 to the [JadeLog] section of your JADE INI file; if the [JadeLog] section doesn't exist add that first. Initiate a JADE node with an ini= parameter on the command line (the ini= parameter ensures that the Jade tracing module uses the correct INI file).
2) To enable ODBC tracing: Select the tracing tab from the Windows ODBC Data Source Administrator Applet. On this tab, enter a log file path if required (and Apply); click the 'Start Tracing Now' button when you want to start tracing and 'Stop Tracing Now' to stop tracing.

The JADE SQL trace output is sent to the JOMMSG log and the ODBC trace output is sent to the specified log file.