>I often get this problem, i have a Database on SQL Server, and i access this via DSN and remote views in foxpro, can someone help me with this problem?
It can be many reasons for this. Server does not work ( not running),tcp/ip protocol in your net failed, number connection on the server was exided allowered number and many others. ( check share connection property, if it is not, any new open remote view uses new connection and soon all fail)
If you will work not with remote views, but with sqlpathtrough , you can close connection and open when it neccesary by
public con
con=sqlconnect()
If con>0, you can work,
if con<0, analize aerror with code 1526, and look the reason