Author |
Topic  |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 02 September 2004 : 10:17:16
|
I have been using Snitz Forums (SF) for a year or two - with no problems. A couple of days ago my web hotel launched a new server - and I lost connectivity to the database! :( Unfortunately, when I installed SF, I didn't modify the 'active.asp' myself: Some kind person from the community ('ruirib'?) helped me out. The drawback is of course that now I'm somewhat (= even more) at a loss! 
The 'old' connect-string went like this:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\InetPub\wwwroot\oyfss.dk\snibas\fssdebat5.mdb" '## MS Access 2000
My main understanding problem lies with the first part of the string:
D:\InetPub\wwwroot... why 'D', why 'InetPub', why 'wwwroot'??
My new server name is:
ftp.oyfss.dk
, and all 'web stuff' resides in a folder, named
'public_html' - so (as an example) path to 'index' file would be:
ftp.oyfss.dk/public_html/index.htm? or maybe:
www.oyfss.dk/public_html/index.htm??
BTW: I also tried to use a 'virtual path':
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../snibas/fssdebat5.mdb") '## MS Access 2000 using virtual path
- but that didn't work either:
"Microsoft JET Database Engine error '80004005'
Not a valid bookmark.
/forum/inc_header.asp, line 114"
(line 114: my_Conn.Open strConnString)
Any good ideas would be highly welcomed! |
Regards, Hans |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 02 September 2004 : 11:11:55
|
ask your webhost what the path should be |
 |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 02 September 2004 : 12:04:42
|
quote: Originally posted by HuwR
ask your webhost what the path should be
Thanks, I did that (no reply so far) - but to me it would seem a lot simpler to use a 'virtual' path!? I wonder why it doesn't work (for me)??  (I recall similar problems last time: They were finally resolved - but only thanks to 'ruirib'!) |
Regards, Hans |
 |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 02 September 2004 : 12:24:26
|
Possible clue??: "Server.MapPath() error 'ASP 0175 : 80004005'
Disallowed Path Characters
/forum/config.asp, line 55
The '..' characters are not allowed in the Path parameter for the MapPath method."
My virtual path is: "Server.MapPath("../snibas/fssdebat5.mdb")"
But how can I indicate 'one level up' *without* '..'??  |
Regards, Hans |
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 02 September 2004 : 13:08:33
|
did you try removing the .. server.mappath is relative to wwroot if your db directory is outside wwroot then you caan't use server.mappath you must use a physical path.
Since your host made changes, you need to ask them, if they do not respond to such a simple question then I can only suggest you download all your files and find a better host. |
 |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 03 September 2004 : 06:47:35
|
As mentioned elsewhere,the host is having some (unspecified) ASP problems. He has promised(?) to have them resolved by Monday or Tuesday. 
I'll be back then - if my problems persist.
Have a nice weekend! |
Regards, Hans |
 |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 08 September 2004 : 04:45:06
|
My service provider has informed that the server is 'fully operational' again - and has also furnished a(n absolute) path to the db; and it works - so far so good! But my 'reply from the db' appears somewhat degraded, and it definitely doesn't look like it used to! I get the statistical overview: Topics - Posts - Last Post (when and from whom) etc. - but there are no provisions for LOGIN! (and the smiley after 'Happy Posting!' is not 'properly portrayed', i.e. showed in 'brackets and colon'!) Except for 'config.asp' I havn't modified any files - so I don't know where to look for errors!  I sincerely hope that someone can help solving these problems. |
Regards, Hans |
 |
|
Nikkol
Forum Moderator
    
USA
6907 Posts |
Posted - 08 September 2004 : 06:28:09
|
can you post a link to your forum? You should also either change the location of your db to outside the wwwroot or turn off the ability to browse files on your server, as I was able to download your db. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
 |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 08 September 2004 : 07:14:12
|
quote: Originally posted by Nikkol
can you post a link to your forum? You should also either change the location of your db to outside the wwwroot or turn off the ability to browse files on your server, as I was able to download your db.
Link: http://www.oyfss.dk/info activate the lower link ('Debat') of the menu to the left.
(The direct link would be: http://www.oyfss.dk/forum/default.asp )
By Golly - it works now!  I have no idea about what happened in the meantime ( - but I'm going to thoroughly 'interrogate' my service provider!)
Thanks for your security warning - I'll also discuss that issue with the service provider.
One (final?) question: Should I update the whole forum to the current version now? Are there any pitfalls/risks?? What are the (main) advantages? I suppose that existing subscribers and articles could 'survive' such action!(?) |
Regards, Hans |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 08 September 2004 : 11:30:43
|
You should definitely upgrade. If you have mods, you'd need to reinstall them (and that would be the biggest disadvantage). Otherwise, just follow the instructions in the readme and nothing will be lost. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 09 September 2004 : 10:53:57
|
OK - I'll attempt an upgrade. I didn't make that many mods! |
Regards, Hans |
 |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 09 September 2004 : 17:09:48
|
Now I seem to be back in the problem I described yesterday as 'degraded opening page' (no provisions for login etc)! Could someone kindly have a look at http://www.oyfss.dk/forum/default.asp and try to help out?? |
Regards, Hans |
 |
|
Hans Henrik
Starting Member
Denmark
42 Posts |
Posted - 09 September 2004 : 18:01:50
|
Surprise: Working again! I simply don't understand what's going on!?  I have postponed my upgrade till tomorrow: I want to ask some more questions, before I begin. |
Regards, Hans |
 |
|
wii
Free ASP Hosts Moderator
    
Denmark
2632 Posts |
Posted - 09 September 2004 : 18:21:05
|
Which host are you using ? |
 |
|
|
Topic  |
|