Not sure why I get this connection error

[ah_1026]

Hi all,

my client have a program i wrote that connects to a database at start, for the past few months the program worked fine no error what so ever, and i gave them a newer version of the program and when they used the new .exe file they got the "runtime error 2147467259 (80004005) Cannot open database requested by the login. The login failed" Then they tried to use the previous version of the program and the error still occur. The update i did for the two software have nothing to do with the connection string, is basically some operation upgrade. In addition, it works fine on my computer. I am really confuse in what might be the cause of this error. If anyone can give me any suggestion it would be great. Great thx

[leinad31]

What DLLs were updated by installer?

[ah_1026]

nothing actually, all i did for the update was change some timer value and winsock data arrival condition. I didn't send them the whole installer, i just made a .exe with my VB and sent to them. So i doubt any DLL was updated

[leinad31]

Can the database be opened using other tools? What database is this? Access?

[ah_1026]

the database is SQL2005 express, other tool was able to open the database, and that tool is their previous software which was not written by me. That is why i am having difficulty understanding why my program does not work, as a matter of fact it works but all of a sudden can't run

[leinad31]

Before proceeding with possible solutions, mitigate risks first. Check what applications/data are in machine in question and back them up, ensure they can be recovered/reinstalled.

Once you have that covered, try creating an install package for your application rather than just copying an exe file.

[ah_1026]

thanks leinad...i actually have 2 approach for this, 1 is as you say create a new installation package and install it again at the client computer to see if it works and 2. recode my sql connection string, not sure if that will help but the current connection string didn't have user name and password in the string and i am changing it to include the user name and password to database. Just out of the question do you think my 2nd approach have any use?