Help, anyone, as this problem occur only with some of our remote users. We have a VB6 frontend with a connection string connecting to our SQL server for updates . Remote users use the internet. Everything worked well until recently when some users get the "server is unavailable" message. The same users get the same message even if we tried with a different server, even when the client program is reinstalled. It looked like it has been blocked but there is no firewall on those PCs and they are not networked, Any ideas. Thank you.
Francis
Mon, 09 May 2005 05:48:21 GMT
Atrax #2 / 6
Connection to SQL server
they're not networked? no wonder they can't find the remote machine!
would you like to re-phrase your question?
________________________________________ I got bored with my old signature, so I changed it
Atrax. MVP, IIS http://rtfm.atrax.co.uk/
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
Mon, 09 May 2005 11:14:28 GMT
Francis Lo #3 / 6
Connection to SQL server
Sorry for the ambiguity. The client notebooks/pc are standalone machines which connects remotely to our server via the internet.
Floh
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
Mon, 09 May 2005 15:00:29 GMT
Dave War #4 / 6
Connection to SQL server
What connection string are you using
Quote:
> Hi,
> Help, anyone, as this problem occur only with some of our remote users. We > have a VB6 frontend with a connection string connecting to our SQL server > for updates . Remote users use the internet. Everything worked well until > recently when some users get the "server is unavailable" message. The same > users get the same message even if we tried with a different server, even > when the client program is reinstalled. It looked like it has been blocked > but there is no firewall on those PCs and they are not networked, Any ideas. > Thank you.
> Francis
Mon, 09 May 2005 15:25:17 GMT
Val Mazu #5 / 6
Connection to SQL server
Hi,
Are you able to connect to SQL Server from Query Analyzer?
-- Val Mazur Microsoft MVP
Quote:
> Hi,
> Help, anyone, as this problem occur only with some of our remote users. We > have a VB6 frontend with a connection string connecting to our SQL server > for updates . Remote users use the internet. Everything worked well until > recently when some users get the "server is unavailable" message. The same > users get the same message even if we tried with a different server, even > when the client program is reinstalled. It looked like it has been blocked > but there is no firewall on those PCs and they are not networked, Any ideas. > Thank you.
> Francis
Mon, 09 May 2005 21:12:03 GMT
Francis Lo #6 / 6
Connection to SQL server
Yes, we can.
Francis
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
Connection to SQL server