| Author |
 Topic  |
|
davidkirk
Junior Member
USA
113 Posts |
 Posted - 23 July 2005 : 21:37:12
|
| I am trying to move my site host from its current location,reachable at http://www.gayrites.net/forum/default.asp to a new host, where I have published the site, using FrontPage 2003,reachable here: http://www.s130394599.onlinehome.us/forum/default.asp. I am an amateur; the forums were originally adapted for me by a friend who is unavailable to help me and my current contract is about to run out. I'd appreciate any help in getting the forums to work in the new location -- in simple dummy terms like: "open this file, find this line and change this word." Many thanks to all. |
David Kirk |
|
|
dabugster
Junior Member
USA
168 Posts |
Posted - 23 July 2005 : 22:11:10
|
The only thing you should need is to change the config.asp file.
Do you have a whereami.asp page?
|
 |
|
|
davidkirk
Junior Member
USA
113 Posts |
Posted - 24 July 2005 : 06:57:33
|
quote:
Originally posted by dabugster
The only thing you should need is to change the config.asp file.
Do you have a whereami.asp page?
Yes I do! Here are the contents of it:
<%
'#################################################################################
'## Snitz Forums 2000 v3.4.04
'#################################################################################
'## Copyright (C) 2000-04 Michael Anderson, Pierre Gorissen,
'## Huw Reddick and Richard Kinser
'##
'## This program is free software; you can redistribute it and/or
'## modify it under the terms of the GNU General Public License
'## as published by the Free Software Foundation; either version 2
'## of the License, or (at your option) any later version.
'##
'## All copyright notices regarding Snitz Forums 2000
'## must remain intact in the scripts and in the outputted HTML
'## The "powered by" text/logo with a link back to
'## http://forum.snitz.com in the footer of the pages MUST
'## remain visible when the pages are viewed on the internet or intranet.
'##
'## This program is distributed in the hope that it will be useful,
'## but WITHOUT ANY WARRANTY; without even the implied warranty of
'## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
'## GNU General Public License for more details.
'##
'## You should have received a copy of the GNU General Public License
'## along with this program; if not, write to the Free Software
'## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
'##
'## Support can be obtained from our support forums at:
'## http://forum.snitz.com
'##
'## Correspondence and Marketing Questions can be sent to:
'## manderson@snitz.com
'##
'#################################################################################
dim strPath, strCustomDatabaseName
strCustomDatabaseName = Request.QueryString("dbname")
if strCustomDatabaseName <> "" then
strPath = Replace(Request.ServerVariables("PATH_TRANSLATED"), "whereami.asp",strCustomDatabaseName)
else
strPath = Replace(Request.ServerVariables("PATH_TRANSLATED"), "whereami.asp","snitz_forums_2000.mdb")
end if
Response.Write "<html>" & vbNewLine & vbNewLine & _
"<head>" & vbNewLine & _
"<title>Where Am I?</title>" & vbNewLine & _
"</head>" & vbNewLine & vbNewLine & _
"<body>" & vbNewLine & vbNewLine & _
"<table border=""0"" cellspacing=""0"" cellpadding=""5"" width=""50%"" height=""50%"" align=""center"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td bgColor=""#9FAFDF"" align=""center"">" & vbNewLine & _
" <font face=""Verdana,Arial,Helvetica"" size=""2"">" & vbNewLine & _
" <p><strong><font size=""4"">Where Am I?</font></strong></p>" & vbNewLine & _
" <p></p>" & vbNewLine
if strCustomDatabaseName = "" then Response.Write(" <p><b>snitz_forums_2000.mdb</b> is used as an example database name.<br />If you have changed the name of your database, you'll need to change it in the <b>strConnString</b> example shown below, as well.</p>" & vbNewLine)
Response.Write " <p>Physical Path to Database: <b>" & strPath & "</b></p>" & vbNewLine & _
" <p>Example <b>strConnString</b>:</p>" & vbNewLine & _
" <p>This one will work with either Access97, Access2000 or Access2002:</p>" & vbNewLine & _
" <nobr><font color=""brown""><p>strConnString = ""Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath & """ '## MS Access 2000</p></font></nobr>" & vbNewLine & _
" <br /><p>Use the following only if you can't get the first one to work<br />One reason could be that your host doesn't have the MSJet Drivers installed:</p>" & vbNewLine & _
" <nobr><font color=""brown""><p>strConnString = ""DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strPath & """ '## MS Access 97</p></font></nobr>" & vbNweLine & _
" <p></p>" & vbNewLine & _
" </font>" & vbNewLine & _
" </td>" & vbNewLine & _
" </tr>" & vbNewLine & _
"</table>" & vbNewLine & vbNewLine & _
"</body>" & vbNewLine & vbNewLine & _
"</html>" & vbNewLine
%> |
David Kirk |
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 24 July 2005 : 07:11:24
|
| Put the whereami-file in your database folder and open it in your browser. The file produces the path to your db and it should be the same as you have put in your config-file. |
rf/www.avgifter.com |
|
|
|
davidkirk
Junior Member
USA
113 Posts |
Posted - 24 July 2005 : 07:40:27
|
| Thanks, Roger. It's getting warmer for me! Can you tell me where to find the config file and where I should be looking to make sure it is pointing to the right place? (Remember: "I know nothing, nothing!") |
David Kirk |
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 24 July 2005 : 11:34:07
|
Where to find config file .. . Ok, that really indicate that you need help.My first advice would be that you get basic info by reading readme.txt in the folder where your forum is and FAQ-forums on this site. It is possible and great fun to start from scratch but ask someone familiar with editing files and FTP etc to help you start the process of installing your site.
I am sorry to say but I am not teacher enough to give you step by step instructions, if you spoke Swedish I perhaps could have helped you out.
Someone else, please step in!
PS
I myself would have downloaded my folders (often two folders named FORUM and DATABASE) from my old host to my computer. Step numer two would be to upload the folders to my new host. After that I would run setup. Is that the way to do it?
DS
|
rf/www.avgifter.com |
Edited by - Roger Fredriksson on 24 July 2005 11:35:50 |
|
|
|
dabugster
Junior Member
USA
168 Posts |
Posted - 24 July 2005 : 12:21:30
|
David,
Did you put the whereami.asp file in your db folder and open it in the browser yet?
And ... do you have FTP access to the web site?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
davidkirk
Junior Member
USA
113 Posts |
Posted - 24 July 2005 : 15:59:10
|
Thanks guys. I'm doing a little better now.  I can surely understand your frustration if I couldn't even find my config file --which I since have done, realizing that my total ignorance surely made me nearly unhelpable. Here's what I have done so far ...
I got my host to allow the whereami.asp script to run. When I opened it in my browser, it told me to change the strConnString as follows, which I did:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\kunden\homepages\32\d130394576\fpdb\snitz_forums_2000.mdb" '## MS Access 2000
... except that for the "snitz_forums_2000.mdb" I substituted the actual name of my forum database -- which I know from having read some of the basics (again) that I should never reveal to another living soul.
Now when I try to open the menu of the form from the default page of the site, I get:
ADODB.Recordset error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
/forum/default.asp, line 108
I've checked a zillion Google hits on that error but all of the answers seem to be very, very specific to some other line of script that doesn't look anything like line 108 in the default.asp file.
Finally: once the FP extensions are installed on the server, FTP access to the site is impossible, unless I uninstall the FP extensions. I've triple-checked that with the host.
Next?  And many, many thanks!!
|
David Kirk |
Edited by - davidkirk on 24 July 2005 16:00:46 |
|
|
|
dabugster
Junior Member
USA
168 Posts |
Posted - 24 July 2005 : 16:07:24
|
Can you post a url to a copy of your default.asp in a txt file?
|
|
|
|
davidkirk
Junior Member
USA
113 Posts |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 24 July 2005 : 17:40:34
|
| I've seen that before with FP extensions, you can try FTP'ing through a command prompt. |
|
|
|
davidkirk
Junior Member
USA
113 Posts |
Posted - 24 July 2005 : 17:46:37
|
quote:
Originally posted by StephenD
I've seen that before with FP extensions, you can try FTP'ing through a command prompt.
Note to be fresh ... but ... maybe you can try FTP-ing with a command prompt!  |
David Kirk |
|
|
|
dabugster
Junior Member
USA
168 Posts |
Posted - 24 July 2005 : 18:04:31
|
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/default.asp, line 108
108 rsChk.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
Someone help me out here .... doesn't this error happen when there is an include file like inc_adovbs.asp is called twice on the same page?
Or something like that.
|
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 26 July 2005 : 09:31:26
|
| David, are you still struggling with your problem? |
rf/www.avgifter.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 July 2005 : 09:50:59
|
quote:
Originally posted by dabugster
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/default.asp, line 108
108 rsChk.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
Someone help me out here .... doesn't this error happen when there is an include file like inc_adovbs.asp is called twice on the same page?
Or something like that.
No, I don't think so. This is the error that usually appears when setup was not run, but that is not the case here. I must admit I don't know why this happens.
I would go for a completely new upload of the forum and the database, using FTP. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
