Page 1 of 1
Need help with database
Posted: Sat Aug 23, 2008 2:31 am
by chipbom11
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!!!
Re: Need help with database
Posted: Sat Aug 23, 2008 7:29 am
by jmestep
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.
Re: Need help with database
Posted: Sun Aug 24, 2008 4:40 am
by chipbom11
but how can i change file database.config map to the new database ? it was encrypted.
Re: Need help with database
Posted: Sun Aug 24, 2008 11:28 am
by cerami2
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.
Re: Need help with database
Posted: Sun Aug 24, 2008 12:24 pm
by chipbom11
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.

You have other solution ??
Re: Need help with database
Posted: Sun Aug 24, 2008 3:02 pm
by cerami2
nope Na da
Re: Need help with database
Posted: Mon Aug 25, 2008 1:41 am
by chipbom11
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

Re: Need help with database
Posted: Mon Aug 25, 2008 8:47 am
by jmestep
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.