>>Ultimately I'd like to be able to do the SQL Server query within the VFP app directly but I don't have any experience using VFP and SQL Server. I'm probably the only person that still does anything in our IT department with FP/VFP. We have people that do that kind of thing in VB but I'd rather stick with VFP. I have access to the VB code used to get the data I can use as a starting point. If anyone has some articles I could read on how to do SQL Server (I think it's SQL Server 2000) queries with VFP I'd love to read them. I have used SQL queries on native FPW tables a lot but I haven't used any of the SQL features added in VFP 6.
>>
>>Any help would be greatly appreciated.
>
>Larry,
>Check strconv(), filetostr(),strtofile().
>SQLServer queries are not hard.
>ie:
>

>lnHandle=SQLStringConnect('DRIVER=SQL Server;SERVER=servernamehere;DATABASE=pubs;Trusted_Connection=Yes')
>SQLExec(lnHandle, "select * from employee", 'myEmployee')
>SQLDisconnect(lnHandle)
>
>select myEmployee
>browse
>

>Cetin

The VB code that is used apparently uses something called "Microsoft ActiveX Data Object 2.5 Library". Is there a way for my VFP app to use this or something like it? I'd like to avoid having to add an ODBC DSN on each machine that uses my app.