Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Previous versions
 Path to db??
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 02 September 2004 :  10:17:16  Show Profile
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  Show Profile  Visit HuwR's Homepage
ask your webhost what the path should be
Go to Top of Page

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 02 September 2004 :  12:04:42  Show Profile
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
Go to Top of Page

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 02 September 2004 :  12:24:26  Show Profile
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
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 02 September 2004 :  13:08:33  Show Profile  Visit HuwR's Homepage
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.
Go to Top of Page

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 03 September 2004 :  06:47:35  Show Profile
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
Go to Top of Page

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 08 September 2004 :  04:45:06  Show Profile
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
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 08 September 2004 :  06:28:09  Show Profile
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 ~
Go to Top of Page

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 08 September 2004 :  07:14:12  Show Profile
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
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 September 2004 :  11:30:43  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 09 September 2004 :  10:53:57  Show Profile
OK - I'll attempt an upgrade. I didn't make that many mods!

Regards,
Hans
Go to Top of Page

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 09 September 2004 :  17:09:48  Show Profile
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
Go to Top of Page

Hans Henrik
Starting Member

Denmark
42 Posts

Posted - 09 September 2004 :  18:01:50  Show Profile
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
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 09 September 2004 :  18:21:05  Show Profile
Which host are you using ?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07