By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,442 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,442 IT Pros & Developers. It's quick & easy.

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

P: 97
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:
Expand|Select|Wrap|Line Numbers
  1. 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.
Jan 24 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
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:
Expand|Select|Wrap|Line Numbers
  1. 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
Jan 24 '08 #2

P: 97
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!
Jan 25 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.