up vote 0 down vote favorite
share [g+] share [fb]

Subject: SQL Server 2000 Enterprise Edition, windows XP Log-in fail for odbc sql server user computer name/guest

I am connecting for several computer with the VB6 application with following connection string "PROVIDER=MSDASQL;driver={SQL Server};server=Computer Name.;uid=;pwd=;database=Test Name;"

BUT, just Three Computer not Log-in. This three (connected with each other) are completely separate in other Room.

I checked all possible options. Besides, which option is missing??? Please Help me...

link|improve this question
feedback

1 Answer

up vote 0 down vote

If you can log in with some computers using that connection string, then it looks to be correct, so your potential problems here are:

  • The computers do not have network connectivity to the SQL server
  • The computers do not have the required SQL Server driver available
  • There are firewall issues.

It would be useful if you could provide any error message you may be getting.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.