Adding Other Databases To AbleCommerce 7.0

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
BryanWarmoth
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 44
Joined: Fri May 23, 2008 11:24 am
Location: Puyallup, Wa
Contact:

Adding Other Databases To AbleCommerce 7.0

Post by BryanWarmoth » Wed May 28, 2008 11:29 am

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
Bryan Bingham
Warmoth Guitar Products Inc.
bryan@warmoth.com
http://www.warmoth.com

User avatar
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

Post by jmestep » Wed May 28, 2008 1:05 pm

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

User avatar
BryanWarmoth
Lieutenant, Jr. Grade (LT JG)
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

Post by BryanWarmoth » Wed May 28, 2008 2:16 pm

Thanks for the reply. The connection strings are encrypted. How do I go about encrypting the extra connection string that I need.

Bryan
Bryan Bingham
Warmoth Guitar Products Inc.
bryan@warmoth.com
http://www.warmoth.com

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: Adding Other Databases To AbleCommerce 7.0

Post by Logan Rhodehamel » Wed May 28, 2008 4:08 pm

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
Image.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.

Post Reply