I was looking through the code and noticed if you are running the Sql Server version there are a couple of lines in the code that you can comment out (or wrap in an if then statement checking for Sql version).
I wouldn't even bring it up but the server.mappath is an expensive method because it has to read the file system each time it is called.
So, unless Borg says different, I'm going to comment out the following 2 lines in the common.asp file. (Only for SQL SERVER version!)
1) strDbPathAndName = Server.MapPath("admin/database/wwForum.mdb") 'This is the path of the database from this files location on the server
2)strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName 'This one is for Access 2000/2002 .
Borg,
Actually, you might just want to move:
'Set the diffrent variables for diffrent database types
If strDatabaseType = "SQLServer" Then %>
up a few lines to right under :
Set adoCon = Server.CreateObject("ADODB.Connection")
and then add a "Not" since you are already testing for SqlServer anyway.
Edited by kmacy
Topic Options
Post Options
Thanks(0)
