Error in connection...The ConnectionString property has not been initialized

[gggram2000]

Hi, I'm using visual studio 2005 with sql server 2005. I made a program on my computer that works great. I wanted to transfer the same project through a remote connection to another computer, I transfered the debug file with the executable file and everything, I already have the same project on that computer but it was an earlier one I had made so I wanted to update it. The issue was, since I changed my database values, i wanted to transfer the two database files to replace both .mdf and .ldf files. When I did that on the same folder, I did overwrite the older one i had with my newer one. Then when I tried opening the executable file, it gave me this error:

Error in connection...The ConnectionString property has not been initialized

it also said on another table, the application has encountered a problem and needs to close...etc. Since I did overwrite the files I can't get them back, but I have a backup of the old one...how can I restore it, or what can I do to fix this problem? Please it's urgent.

[ck9663]

Hi, I'm using visual studio 2005 with sql server 2005. I made a program on my computer that works great. I wanted to transfer the same project through a remote connection to another computer, I transfered the debug file with the executable file and everything, I already have the same project on that computer but it was an earlier one I had made so I wanted to update it. The issue was, since I changed my database values, i wanted to transfer the two database files to replace both .mdf and .ldf files. When I did that on the same folder, I did overwrite the older one i had with my newer one. Then when I tried opening the executable file, it gave me this error:

Error in connection...The ConnectionString property has not been initialized

it also said on another table, the application has encountered a problem and needs to close...etc. Since I did overwrite the files I can't get them back, but I have a backup of the old one...how can I restore it, or what can I do to fix this problem? Please it's urgent.

using your sql manager, do a complete backup of your database. copy that backup file to the destination station. using the sql manager on that station, restore your database using the backup of the source database. you might also need to modify the connectionstring on the destination machine. make sure the sql server name is correct.

-- ck

[gggram2000]

using your sql manager, do a complete backup of your database. copy that backup file to the destination station. using the sql manager on that station, restore your database using the backup of the source database. you might also need to modify the connectionstring on the destination machine. make sure the sql server name is correct.

-- ck

Hey thanks ck! I did that and it was giving an error about not having access...so what i did is go into configuration manager and in services I changed the logon from network to local service and it restored fine. Appreciate ur help!

Cheers!