Web Wiz Support and Community Forums : too many SQL connections opening https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 07:01:33 +0000 Tue, 04 May 2004 14:27:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10261 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[too many SQL connections opening : will do. thank you all. ]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post56060.html#56060 Author: rabend
Subject: 10261
Posted: 04 May 2004 at 2:27pm

will do.  thank you all.

]]> Tue, 04 May 2004 14:27:54 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post56060.html#56060 <![CDATA[too many SQL connections opening : in regards to getting data from...]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post56013.html#56013 Author: dj air
Subject: 10261
Posted: 04 May 2004 at 5:51am

in regards to getting data from access to SQL database,

there are lots of posts regarding this . i have replied to lots already. but if your host is a nice one, ask them if they can upsize the access database onto the SQL server

DO this one first before the below as you will have to wait for the upsize

in regards to the ms sql set up file

if you are using the upsize wizard method you will need to delete the code in the msSQL_server_setup.asp so only the stored procedures are left else you will get errors

go to the forum and in the address bar write on the end msSQL_server_setup.asp then fill in the details of the SQL server and presto its done.

]]> Tue, 04 May 2004 05:51:41 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post56013.html#56013 <![CDATA[too many SQL connections opening : You need to download the MS SQL...]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post56012.html#56012 Author: WebWiz-Bruce
Subject: 10261
Posted: 04 May 2004 at 5:50am

You need to download the MS SQL server version of Web Wiz Forums, the ms_sql_server_setup.asp file is part of that package.]]> Tue, 04 May 2004 05:50:54 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post56012.html#56012 <![CDATA[too many SQL connections opening : i apologize for the ignorance,...]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55991.html#55991 Author: rabend
Subject: 10261
Posted: 03 May 2004 at 5:37pm

i apologize for the ignorance, but what's the mssql server setup file, and how can i move the data from the access db to the sql server db? 

thanks.

]]> Mon, 03 May 2004 17:37:07 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55991.html#55991 <![CDATA[too many SQL connections opening : What&#039;s the file size of the...]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55977.html#55977 Author: dpyers
Subject: 10261
Posted: 03 May 2004 at 2:12pm

What's the file size of the access .mdb?

]]> Mon, 03 May 2004 14:12:48 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55977.html#55977 <![CDATA[too many SQL connections opening : run the mssql server setup file...]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55938.html#55938 Author: Semikolon
Subject: 10261
Posted: 03 May 2004 at 9:55am

run the mssql server setup file on the server and ask your host to move the data from the access db to the sql server db]]> Mon, 03 May 2004 09:55:39 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55938.html#55938 <![CDATA[too many SQL connections opening : ok, thanks. i guess i should upgrade...]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55933.html#55933 Author: rabend
Subject: 10261
Posted: 03 May 2004 at 8:35am

ok, thanks.  i guess i should upgrade then.

if i want to start using the MS SQL version instead of the Access one, how can i keep my users database (it's an .mdb file)?

]]> Mon, 03 May 2004 08:35:02 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55933.html#55933 <![CDATA[too many SQL connections opening : You should upgrade to the latest...]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55919.html#55919 Author: WebWiz-Bruce
Subject: 10261
Posted: 03 May 2004 at 4:49am

You should upgrade to the latest version as version 7.x does greatlyimprove performance by using less recordset and database objects.

You should also upgrade for security reasons as awell.

If you have an Access .mdb file, then you are using the Access version.Access uses a great deal of server resources as it is a flat filesystem.

The MS SQL server version 7.8 would increase peformance a great deal asit uses less database objects, stored procedures, application levelvariables to reduce database calls, and many other performanceenhancing features.
]]> Mon, 03 May 2004 04:49:35 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55919.html#55919 <![CDATA[too many SQL connections opening : hi all i&#039;m using the 6.28...]]> https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55890.html#55890 Author: rabend
Subject: 10261
Posted: 02 May 2004 at 6:10pm

hi all

i'm using the 6.28 version with, i believe, the MS SQL (though an .mdb Access file does open and keep info - so is that Access and maybe not MS SQL?) for about 18 months.  the average number of posts in the forum is about 20,000-30,000, which are deleted every month.  there are about 8000 registered users, though the number of actual active users is lower.

recently, the SQL admin of our web hosting notified me that the SQL machine is being exhausted by our forum, as there appear to be either multiple connections to the SQL opening for each user, or that the connections do not close appropriately.

i wanted to know:

1. is this bug known and maybe has a fix, or should i upgrade the forum altogether to the latest version. 

2. if so, are the 6.28 or the 7.8 versions built to handle the usage load i described above?

3. does the MS SQL 7.8 version use caching (my SQL guy told me to ask that)?

thank you,

rany

]]> Sun, 02 May 2004 18:10:23 +0000 https://forums.webwiz.net/too-many-sql-connections-opening_topic10261_post55890.html#55890