HI,

I have a requirment to use the FP 2.6 Connectivity kit to access a SQL 7 version database. I have all of the original books from Microsoft on the CK as well as FP 2.6 Professional, I have not found much documentation on the actual code required to work with the SQL table. The SQL database I am working with is in production and accessed daily by a number of applications to include VFP so there is no real issue with it.

What I have tried has been:

Loaded DB-Library TSR of DBNMPipe.Exe (from the SQL V6.5 CD).
Started Foxpro 2.6
Set Library to FPSQL
(PC is runnning DOS 6.20 (only, no windows) using a P90 cpu)

I am trying to access a database named "FOXPROSQL" that resided on an NT Server on my network, the name of the server is DATA_NT.

I executed the command DBConnect("Data_NT", user id, password, "FoxproSQL") and got a valid file handle (1). I also performed a number of DBSetOpt() calls with got a valid return. However when I try DBTables() I get a valid return (1) but the results are empty. When I try a DBExec() of any type I get a -1 return.

Any suggestions would be greatly appreciated.
Jim