>>I have an application which uses SQL Server as the back end. This application is running fine at several locations, but a new customer is running into a sporadic "connectivity error". The error has occurred a few times this week while running different forms/reports.
>>
>>Anyone have any ideas of the potential source for these errors? Is there anything on their network I need to check?
>>
>>Application is VFP7 sp3
>>SQL Server 7
>>Workstations are Win NT 4
>>
>>Kind Regards,
>>
>>Mat
>
>I take it that's VFP5 or 6 SP3, not VFP7.
>
>Are you going through SPT/Remote views or ADO? I would check DSN's to make sure they exist and are set up the same, and also the version of the ODBC/OLEDB drivers depending on your situation.
Yes,
That is VFP6. I am using a combination of SPT and Remote views. The DSN's appear to be ok since they are working most of the time? I have just requested from them version numbers of everything including the ODBC drivers. Thank you for the help.
If you can think of anything else, please throw it my way.
Kind Regards,
Mat