>>>>I've got a legacy FPW 2.6 application that I'd like to be able to connect to SQL Server 2000. I've managed to dig up and install the old Connectivity Kit. In doing some research on this I've found that 16-bit applications can access 32-bit backends through the thunking layer. However, I've not been able to successfully create a connection.
>>>>
>>>>So the question is as follows:
>>>>
>>>>From what I've read the caller needs to adhere to ODBC 2.0 specs. From what I've been able to determine, all the ODBC files installed from the Connectivity Kit are version 1.0. Anyone know if this is correct and if version 2.0 files would work with the FPSQL.FLL?
>>>
>>>Is this link useful? http://support.microsoft.com/default.aspx?scid=kb;en-us;260817
>>
>>Thanks Al. I'll check it out tomorrow at the office.
>
>George;
>
>I wish you well on this endeavor. Thoughts of the Connectivity Kit bring back nightmares. Add the Distribution Kit. Imagine how much better it is today and less expensive for users of the Fox to create an application? Just buy a version of VFP and you get all these and more goodies in the box!
>
Tom,

Wouldn't argue for a second. However, there are other projects I've got to work on and was hoping that there was a quick fix I could implement. Normally, I would take the approach that you recommend. In this case, it's one part of a complex integrated system and I only need one piece of information on SQL Server.