>Hi All:
> I have users who are using Win 95. They are using an application written in VFP 6.0. The back end of this application is Sql Server 6.5. The problem is that when one of the user try update some reocords and processing some other information, he/she would get disconnected from the server. I.E. when one of the user tried to print the report after saving the data, she was kicked off from the server. Now this only happens sometime, but still a big issue. Does this means that every time a user opens a different screen from the application, he/she would create a new connection to server? How can I solve this problem or what else could be causing this to happen?
>Thanks
If you are using remote view, then make sure
? DBGetProp(View_Name, 'View', 'ShareConnection')
returns true. If not, then:
DBSetProp(view_name, 'View', 'ShareConnection', .T.)
You can automate this:
lnRetVal = adbobjects(laViews, 'View')
for each lcView in laViews
DBSetProp(lcView, 'View', 'ShareConnection', .T.)
endfor
Just be careful so you do not set a connection for a view to be shared that you did not intend.
Mark McCasland
Midlothian, TX USA