I am trying to configure an old FPW 2.6 application to gether some data from two tables in a SQL 7.0 database. I have not been able to get connected with the DBConnect from the connectivity kit. The program connects fine with SQL 6.5, but gives a -2 handle when I change the Data Source to a SQL 7.0 server.

I don't have the exact error form the SQL 7.0 call, but it is something like this.

I do the DBConnect and it returns a -2 handle. I call DBError and get what I think was a 5701 error number and a message something like

ODBC 010000 (5701) [Microsoft ODBC] ..... context changed to 'masterdb'.

I think this is just saying the default database is masterdb because I can change the default database for either user or the dataset name and the message changes to list the new database name which says it is partially working because there is nothing in my FoxPro application about the database yet.

On the SQL server Executive Console I can see a new connection from my client running FPW 2.6, but since my handle is -2 I cannot issue any other commands from FPW including a disconnect. If I rerun the program, i get an additional connection showing up every time I run the program.

Has anyone successfully connected FPW 2.6 to SQL 7.0 or seen anything that indicates it is possible or impossible? I have searched every key word I can think of on the Jan 99 Technet with no clues.