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
Adding Other Databases To AbleCommerce 7.0
- BryanWarmoth
- Lieutenant, Jr. Grade (LT JG)
- Posts: 44
- Joined: Fri May 23, 2008 11:24 am
- Location: Puyallup, Wa
- Contact:
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Adding Other Databases To AbleCommerce 7.0
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.
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
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
- BryanWarmoth
- Lieutenant, Jr. Grade (LT JG)
- Posts: 44
- Joined: Fri May 23, 2008 11:24 am
- Location: Puyallup, Wa
- Contact:
Re: Adding Other Databases To AbleCommerce 7.0
Thanks for the reply. The connection strings are encrypted. How do I go about encrypting the extra connection string that I need.
Bryan
Bryan
- Logan Rhodehamel
- Developer
- Posts: 4116
- Joined: Wed Dec 10, 2003 5:26 pm
Re: Adding Other Databases To AbleCommerce 7.0
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.)
Cheers,
Logan
.com
If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
Logan

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.