Web Wiz Support and Community Forums : Problems upgrading to free version of 9... https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 21:40:23 +0000 Sat, 01 Mar 2008 20:27:18 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25377 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Problems upgrading to free version of 9... : I just got off the phone with...]]> https://forums.webwiz.net/problems-upgrading-to-free-version-of-9_topic25377_post131709.html#131709 Author: cgacfox
Subject: 25377
Posted: 01 March 2008 at 8:27pm

I just got off the phone with the hosting company and was able to set permissions for read and write in the original database folder. Now it works just fine. Thanks.]]> Sat, 01 Mar 2008 20:27:18 +0000 https://forums.webwiz.net/problems-upgrading-to-free-version-of-9_topic25377_post131709.html#131709 <![CDATA[Problems upgrading to free version of 9... : i just moved everything back the...]]> https://forums.webwiz.net/problems-upgrading-to-free-version-of-9_topic25377_post131708.html#131708 Author: cgacfox
Subject: 25377
Posted: 01 March 2008 at 7:55pm

i just moved everything back the way it was and this is v8 that I currently have. I just can't connect to it. I am not sure how to change the code to get it to go outside the forum to the database.]]> Sat, 01 Mar 2008 19:55:26 +0000 https://forums.webwiz.net/problems-upgrading-to-free-version-of-9_topic25377_post131708.html#131708 <![CDATA[Problems upgrading to free version of 9... : ...and changing code to connect...]]> https://forums.webwiz.net/problems-upgrading-to-free-version-of-9_topic25377_post131707.html#131707 Author: cgacfox
Subject: 25377
Posted: 01 March 2008 at 7:47pm

...and changing code to connect to the database.
 
I believe that I am running v7 or maybe v8 of the forum and have been hosting the site the forum is on myself until recently when I switched to godaddy.com. I set up a DSN with them but have not been able to change the code on the common.asp and database_connection.asp pages to get the forum to work. I thought that since v7 is no longer supported, I would switch to the free version 9. I have downloaded and followed all the steps. However, I cannot get the upgrade to work because I have no idea what the physical server path or the path from this application to database would be. The database is now outside the forum in a folder called bane_db under the main root of the site. Write permissions have been set up properly, or so I was told. I am using Access and I know that it should not be used in a live production but I don't know how to use MySql or Sql Server. I would like to continue to use Access since I am used to it. Here is what I found on godaddy's site for help with "Connecting to an Access Database Using File DSN and ASP/ADO".  This looks totally different than the code in the database_connection.asp file. Please help me upgrade to v9 and get the forum running again!!! Cry
 
<%
Dim oConn, oRs
Dim qry, connectstr, sDSNDir
Dim db_name, db_username, db_userpassword
Dim db_server, dsn_name

dsn_name = "your_dsn_name"
fieldname = "your_fieldname"
tablename = "your_tablename"

sDSNDir = Server.MapPath("_dsn")

connectstr = "filedsn=" & sDSNDir & "/" & dsn_name

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr
qry = "SELECT * FROM " & tablename

Set oRS = oConn.Execute(qry)

if not oRS.EOF then
while not oRS.EOF
response.write ucase(fieldname) & ": " & oRs.Fields(fieldname) & " "
oRS.movenext
wend
oRS.close
end if

Set oRs = nothing
Set oConn = nothing

%>
]]> Sat, 01 Mar 2008 19:47:34 +0000 https://forums.webwiz.net/problems-upgrading-to-free-version-of-9_topic25377_post131707.html#131707