Hi Andreas,
MSDE is limited in the number of simultaneous connections it will support (I believe the number is 5). Beyond that it will begin slowing down all the connections. Maybe VFP7 is not releasing the connections in a timely manner and that is blowing by the limit?
Do you see this happening with the full SQL Server product?
>Is that normal ?
>
>I use Win98, MSDE, Visual Foxpro 7.0. I work with remote views in my application. After creating the connection, and a simple view to specific table on MSDE, the connection to the sql-server is fast. But when developing and testing the application, each time when a view is opened, the "opening" time of the view is a little bit slower (approx. 3 to 5 seconds).
>
>If I delete the connection and rebuild the connection, the "opening" time of the view is fast again.
>
>What can be possible reason for that ?
>
>Bye,
>-Andreas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only