Integrating all databases for Sql
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7735
Printed Date: 30 March 2026 at 7:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Integrating all databases for Sql
Posted By: andrecp
Subject: Integrating all databases for Sql
Date Posted: 30 November 2003 at 7:55am
|
Is it possible to integrate all the databases for use with Sql. How difficult is it to configure all the modules to use one Sql database in place off all the MsAccess databases. |
Replies:
Posted By: michael
Date Posted: 30 November 2003 at 9:06am
|
If you mean, that you want to convert all webwiz apps to a sql version that is not hard to do, you can either merge tables with the same name or rename them and do the appropriate code changes. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: pmormr
Date Posted: 30 November 2003 at 9:32am
|
(or you could just download the SQL server version) ------------- Paul A Morgan http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/ |
Posted By: michael
Date Posted: 30 November 2003 at 12:07pm
|
not all applications have a sql version Paul ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: pmormr
Date Posted: 30 November 2003 at 12:19pm
|
i was talking about wwf ------------- Paul A Morgan http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/ |
Posted By: andrecp
Date Posted: 01 December 2003 at 12:44am
|
Hi Guys I know wwf has an sql version, I have downloaded it and am busy using it. It is just not very neat to have 6 different MSAccess databases all over the place. Default.asp calls common.asp which in turn connects Sql. I imported news.mdb into Sql renaming tblconfiguration to tblnewsconfiguration and changed in the code as well. I renamed all the other tables as well. Then I commented the connection to news.mdb out, because the connection to Sql gets made through common.asp (which gets called right at the beginning)...........but I get an error stating that there is no connection to the data source. |
Posted By: michael
Date Posted: 01 December 2003 at 8:00am
|
that is quite obvious then, make a connection to the database (open the connection) ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: andrecp
Date Posted: 01 December 2003 at 8:45am
|
Hi Michael Common.asp which gets called at the start from default.asp makes that connection, or am I wrong? Regards
|
Andre
Posted By: michael
Date Posted: 01 December 2003 at 5:26pm
|
doesent open it though as far as I remember ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: andrecp
Date Posted: 02 December 2003 at 12:11am
|
Hi Michael I will have a closer look. Regards Andre |