>thank you for this informations.
>
>Can i find somewhere a good book which explains sql passtrough and how to access the database

I purchased 3 books to start my project. I read them all, but the only one I use now is the Hacker's Guide (Hentzenwerke Publishing). I don't know that there are enough passthrough commands to warrant purchasing a book on that topic alone.

Basically, you can make the connection using the SQLConnect() command (see the FoxPro help, you'll need to use SQLDisconnect() to release the connection). You can get more elaborate later, passing parameters, or using SQLStringConnect(), but calling SQLConnect() alone should prompt you to set up the ODBC connection. Once the connection is made, you'll want to save the connection handle that was returned, as that handle is required in the passthrough functions to follow.

After the connection is made, the passthrough commands are pretty basic; SELECT & INSERT INTO should get you going. Check the FoxPro help on SELECT-SQL and INSERT-SQL, and SQL-Passthrough for that matter...