Print Page | Close Window

Problems upgrading to free version of 9...

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=25377
Printed Date: 03 April 2026 at 9:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Problems upgrading to free version of 9...
Posted By: cgacfox
Subject: Problems upgrading to free version of 9...
Date 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

%>



Replies:
Posted By: cgacfox
Date 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.


Posted By: cgacfox
Date 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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net