Installation bug(?)
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=400
Printed Date: 29 March 2026 at 3:41pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Installation bug(?)
Posted By: jsiddall
Subject: Installation bug(?)
Date Posted: 21 February 2003 at 4:35pm
While installing the forum (version 6.34) I ran into difficulty, which I think might be a slight bug of sorts.
In the "SQL_server_connection.asp" file I personalized all the data, including the connection string, which requires a couple of different parameters from the default (Initial Catalog vs. Database; Network Library=DBMSSOCN) which I don't understand, but our host says we need anyway.
Running "SQL_server_setup.asp" I kept getting errors, until I corrected the strCon variable there too. The included file was overridden in the setup file, causing a (slightly) difficult to diagnose error.
' strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Initial Catalog=" & strSQLDBName & ";Network Library=DBMSSOCN"
If this is an error, it would seem easily corrected (now that I know), if not, maybe a caveat should be put somewhere more clearly to personalize the string in two places (if it was written, I didn't find it before trying to install...maybe my fault).
-------------
improvised techno-geek (for lack of a better prepared substitute)
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 21 February 2003 at 8:23pm
The connection string works for 99.9% of users, I have not seen a connection string like yours, so most of the time it works fine. However, for a small minority thgings may not work to plan as different servers are setup in different ways and it is impossible to cater for all web servers, or even know all teh setups to beable to cater for all servers.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: jsiddall
Date Posted: 22 February 2003 at 1:58am
I realize you can't anticipate screwy connection strings from any or every user, and I hope I didn't sound as though I were complaining of that. I know that's my responsability to change since I have the screwy ISP.
My point was that I changed it where I understood the instructions indicated, but the "SQL_server_setup.asp" didn't take my personal connection string from the "SQL_server_connection.asp" file, and, essentially rewrote a new value of the "strCon" variable even though it had already been included by SSI at the beginning of the "SQL_server_setup.asp" file.
This seems a bit of a (not very major) bug, particularly since it only shows up in some situations (when the user has a non standard connection string - but you already indicate where to personalize it, so you seemed to have anticipated it anyway, but not all the way).
I do like the Forum a lot, and just thought this might be easily corrected (if it is even the same in 7beta), and so it would work for the 99.9 + 0.09% too.
Keep up the wonderful work, and I sent in a donation yesterday, as soon as I got the Forum up and was able to make sure it worked on our Server.
Best regards,
-------------
improvised techno-geek (for lack of a better prepared substitute)
|
|