Page 1 of 1
Adding Other Databases To AbleCommerce 7.0
Posted: Wed May 28, 2008 11:29 am
by BryanWarmoth
Is there a way to include another database into the AbleCommerce solution or can you only use the database that is included? I am migrating an old system to AbleCommerce and would like to use another MS SQL Server database for some of the features that are not related to the products we are selling.
Thanks,
Bryan
Re: Adding Other Databases To AbleCommerce 7.0
Posted: Wed May 28, 2008 1:05 pm
by jmestep
You can use another database for things, but you would need to add the connection string, etc to your Able project. It should be basic C#/ .net code as far as how to do that.
Re: Adding Other Databases To AbleCommerce 7.0
Posted: Wed May 28, 2008 2:16 pm
by BryanWarmoth
Thanks for the reply. The connection strings are encrypted. How do I go about encrypting the extra connection string that I need.
Bryan
Re: Adding Other Databases To AbleCommerce 7.0
Posted: Wed May 28, 2008 4:08 pm
by Logan Rhodehamel
In your install, can you get to the Configure -> Security -> Database menu and see if it has a checkbox for encrypting the connection string? If so, you can uncheck it, save it, then go make modifications to database.config. (I believe you could then return to database.config and check the encryption option - but no guarantee on that one.)