Need help with database

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
chipbom11
Ensign (ENS)
Ensign (ENS)
Posts: 8
Joined: Sat Aug 23, 2008 2:26 am

Need help with database

Post by chipbom11 » Sat Aug 23, 2008 2:31 am

I had a version of ableCommerce on my computer throught localhost.
Now i want to move it on a host.
But there is a problem with database. i created a new database on hosting service and Connection string was encrypted.
How can i map my project with new database ?
i don't want to lost my businness.
Need yours help!!!

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Need help with database

Post by jmestep » Sat Aug 23, 2008 7:29 am

If you remember what database name, username, password you set up, you should be able to just move the database to the new host with that same name and credentials and the store should connect with it.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

chipbom11
Ensign (ENS)
Ensign (ENS)
Posts: 8
Joined: Sat Aug 23, 2008 2:26 am

Re: Need help with database

Post by chipbom11 » Sun Aug 24, 2008 4:40 am

but how can i change file database.config map to the new database ? it was encrypted.

User avatar
cerami2
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 103
Joined: Thu Nov 08, 2007 5:29 am
Location: Plymouth MN
Contact:

Re: Need help with database

Post by cerami2 » Sun Aug 24, 2008 11:28 am

If you have the final release version, you should be able to go to Configure -> Security -> Database in your merchant admin and see the value there.

chipbom11
Ensign (ENS)
Ensign (ENS)
Posts: 8
Joined: Sat Aug 23, 2008 2:26 am

Re: Need help with database

Post by chipbom11 » Sun Aug 24, 2008 12:24 pm

thanks cerami2, i have a solution for myself. i connect to the new db with the connection string non encryted, and then encryt like the way that cerami2 told. but i have contact with the hoster to have a full permison with the folder app_data. :D You have other solution ??

User avatar
cerami2
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 103
Joined: Thu Nov 08, 2007 5:29 am
Location: Plymouth MN
Contact:

Re: Need help with database

Post by cerami2 » Sun Aug 24, 2008 3:02 pm

nope Na da

chipbom11
Ensign (ENS)
Ensign (ENS)
Posts: 8
Joined: Sat Aug 23, 2008 2:26 am

Re: Need help with database

Post by chipbom11 » Mon Aug 25, 2008 1:41 am

but there is some problem i have this bug.

System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

somebody help me :(

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Need help with database

Post by jmestep » Mon Aug 25, 2008 8:47 am

So you can connect to the database, but you can't encrypt the connection string at the hoster? Ours is the same way on shared hoster and they have said it can't be done because they won't set the permissions that way. Our charge card info in the db is encrypted, though.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Post Reply