Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

my problem here is very weird compared to other that I found on this forum. The VB program is created with VS2010 from computer "A". It work perfectly. Connection to SQL Server and MYSQL DB. But when I copy the whole file to computer "B" where SQL Server is installed and is used by the program I mentioned before. SO I open with the VS 2010 and debug the program. This time the program can't connect to database. Error " No connection to database. Error trying to connect to user "user" ". Where "user" is the name of user.

FYI, everything maintain the same, IP, username, password, database. Only the location I open the proggram. Besides, I also check the firewall, mssql,ssma but still no connection.

What could cause this type of problem? Thanks in advance.

share|improve this question
    
You may need to change the IP to localhost. –  NickW Jun 14 '13 at 9:05
    
Still the same problem. No connection to Db. :( –  dswong Jun 14 '13 at 9:17
    
So, do you get a particular error number back? –  NickW Jun 14 '13 at 9:31
    
Also, the user you added to MySQL, it should be user @ <somehost> what host did you add? Also, what are you using, MySQL or SQL Server? –  NickW Jun 14 '13 at 9:38
    
yes its this. "no connection possible to DB: an error link to network or specific authorisation when trying to make a connection to sql server. The server is unavailable or inaccessible.Verify that the name is correct and the server is configure to authorise distance connection.(provider: Named Pipes Provider,error: 40-Impossible open a connection to sql server)". that is the error box. But I still don't get the reason why. –  dswong Jun 14 '13 at 9:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.