FoxPro ODBC connect to Sybase System 10

[Keith Marrs]

We are trying to connect FoxPro 2.6a on a Macintosh (not a power mac) to
Sybase System 10 via ODBC. The FoxPro connectivity kit included ODBC
drivers for SQL Server but indicated that these would not work with
System 10, which we proved true. We acquired a System 10 driver from
Intersolv, but still haven't had any luck.

Has anyone had success with this combination, or is there another way
to get FoxPro to work with Sybase? The new driver from Intersolv does
work with Microsoft Query and the Intersolv example application.

I'd appreciate any suggestions.

Thanks,
Keith Marrs
Washington University School of Medicine

[Ken North]

> ma...@osler.wustl.edu (Keith Marrs) writes:
>
> Has anyone had success with this combination, or is there another way
> to get FoxPro to work with Sybase? The new driver from Intersolv does
> work with Microsoft Query and the Intersolv example application.

If you are able to use Query and another example application then it appears that you have a valid ODBC infrastructure (driver
manager, drivers and data sources). The problem appears to be in your FoxPro application code.

Listing 12.3, page 458 of my book (Windows Multi-DBMS Programming, John Wiley & Sons, ISBN 0471-01676-4) is example
FoxPro code for connecting to an ODBC data source with the Connectivity Kit. Listing 12.4 shows how to get a list of tables and
12.5 shows how to execute a remote (ODBC) query.

The book includes examples for a variety of languages (C++, Visual Basic, PowerBuilder, etc.). All were tested using Windows
but the FCK code should be portable than some of the other languages.

>>>>

Ken North

Resource Group, Inc.
2604B El Camino Real, #351
Carlsbad, CA 92008-1214
FAX: 619-729-5127
e-mail: kenn...@interserv.com or 71301...@compuserve.com