| Author |
 Topic  |
|
bisala
Starting Member
26 Posts |
 Posted - 20 May 2002 : 02:59:40
|
using access database on an asp supporting web,
my forum files are in www.xxx.com/html/forum folder
my database is in www.xxx.com/dbroot folder , which is read and write enabled
what should be my strConnstring line?
the forum worked ok offline in my localhost,
but loading into web I moved the dbroot folder one level up for security, now I am puzzled with the string...
thanks
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 20 May 2002 : 03:05:31
|
Though I recomend a non-virtual path if you can use it. This one will work.
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../../dbroot/snitz_forums_2000.mdb")
 Nathan Bales
Snitz Exchange | Do's and Dont's |
 |
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 03:31:00
|
thanks nathan but not it is not resolved.ý get hhtp 500 error
here is the my config.asp
-----------
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../../dbroot/snitz_forums_2000.mdb")
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 7
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 2000
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 03:51:30
|
the error message is this;
An error occurred on the server when processing the URL. Please contact the system administrator.
I can see from the ftp program that the mdb file is read and write enabled.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 04:22:21
|
quote:
An error occurred on the server when processing the URL. Please contact the system administrator.
I can see from the ftp program that the mdb file is read and write enabled.
This looks like a server related error and you should contact your system administrator. Anyway the mdb file permissions cannot be determined through an FTP client. They can only be determined through the Windows interface (usually Windows Explorer).
A link to your forum would be useful.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 05:07:58
|
I contacted the host, they verified that the server is Ok, my account is asp supported, my database file is read and write enabled and there should not be a problem.
Now, how should I proceed?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 05:30:53
|
It's very hard for you to proceed at all getting that error message with all the pages you try to open...
Maybe posting a text version of config.asp would help. And what definitely could help was to contact your host to make sure they have your server configured to send detailed ASP error messages to clients. Otherwise it's almost impossible to figure out what is the error that is stopping you from seting up the forum.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
digmind
Junior Member
Greece
177 Posts |
Posted - 20 May 2002 : 06:44:26
|
I'm not sure if this will help a lot but this is how i got the same
thing to work, i have my forum in root/aspfor1/
and the database is in root/databases/
i am running 2 forums and the databases exist there. only fis is in the names. I saw Nathan put two sets of ../../ i'm not sure if i'm doing it correct but it works. i also back and forth with this. I'd make usre your virtual directory and path are going to your root folder. that's the sys admin's job. then take what he gives you as a root and work from there.
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../database/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
Thrylee Thea Mou
Olympiake Mou
Thryle 7 |
|
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 09:58:43
|
thanks for the tips friends,
no one them worked, my host says they can't help me further.
I tried most of the strings, but before giving up,
could someone indicate a non-virtual path string for me ?
I repeat, I have two main folders in my web ; html and dbroot, access file is in dbroot and is write and read enabled,
my forum files are under www.xxx.com/html/forum folder.
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 20 May 2002 : 09:58:48
|
quote:
but not it is not resolved.ý get hhtp 500 error
It appears to be a server error, but may actually be in the coding within your pages somewhere. I've had a few 500 errors also, but after rechecking my coding, found the errors and was able to correct them. If the forum weren't able to find your database, you should've received a different error so your connection string may or may not be working. It could be something simple like the path within your page to the config.asp or some other included page may be incorrect. This is a problem I've ran into several times since my files aren't all in the forums directory, but correcting the paths to the included files fixed the 500 error for myself anyway.
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 20 May 2002 : 10:17:54
|
What is your host Operating System? There are some Unix asp emulators that don't run VBScript, the language Snitz is coded in.
You can make a simple one-line test file in notepad.
<% response.write "My Test Here" %>
Save this page to your web as testing.asp (or any name you want) and then open it in your browser, you should see the test string in your browser.
======
Doug G
====== |
|
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 11:14:31
|
doug,
my host is NT,
the test you mentionned worked, no problem.
as I told before, before going online I tested all my web in my xp pro localhost. all my html and asp pages worked ok.
then I uploaded to my site by ftp.
when connected I got a html directory, I put forum folder within html directory.then I created another directory at the same level with html directory and named it dbroot.I put my access2002 database within it. my html pages work ok but cann not get asp pages to work.
my host say they can not help mr further....
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 11:39:39
|
quote:
when connected I got a html directory, I put forum folder within html directory.then I created another directory at the same level with html directory and named it dbroot.I put my access2002 database within it. my html pages work ok but cann not get asp pages to work.
If that is your folder structure, your conn string should be:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../dbroot/snitz_forums_2000.mdb")
Looks to me that you had an extra "../" in your initial string.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 11:44:04
|
as far as I understand,
my config.asp is here:
E:\FTP_HOME\MYSITE.COM\HTML\FORUM
my access file is here
E:\FTP_HOME\MYSITE.COM\DBROOT
the previous test demonstrated that I can run an asp within
E:\FTP_HOME\MYSITE.COM\HTML\FORUM
I am quite a newbie with directory strings, please come up with alternatives,
I can move my database to another directory.....
|
|
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 11:49:53
|
I tried yours, Rui,
I received this;
Server.MapPath() error 'ASP 0175 : 80004005'
Disallowed Path Characters
/forum/config.asp, line 58
The '..' characters are not allowed in the Path parameter for the MapPath method.
|
|
|
|
Topic |
|
Topic Locked
