| Author |
 Topic  |
|
|
rschappn
Starting Member
Germany
18 Posts |
 Posted - 14 June 2001 : 10:32:07
|
Hi, I have a problem with the database path. I read a lot of the posts already but still runinto problems.
This is 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=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
I can access all directories on the server. The website will be http://summer2001.ehl.ch/forums/xxxx
my location on the server is (thats what I see in CuteFTP) /www/docs/summer2001/forum
the database will be in /www/docs/summer2001/fpdb/snitz_forums_2000.mdb
Unfortunately the whereami.asp did not show any result. What shall I do ???
|
|
|
Deleted
deleted
4116 Posts |
Posted - 14 June 2001 : 12:53:26
|
There are some inconsistencies in the info you gave:
quote:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
I can access all directories on the server. The website will be http://summer2001.ehl.ch/forums/xxxx
my location on the server is (thats what I see in CuteFTP) /www/docs/summer2001/forum
the database will be in /www/docs/summer2001/fpdb/snitz_forums_2000.mdb
If you have a pointer defined to /www/docs/summer2001 as http://summer2001.ehl.ch/ (it is, I checked it), your connection strings are correct (and your database is there, in http://summer2001.ehl.ch/fpdb, I saw it). Be warned, your database is not in a secure place, and don't forget to disable the browsing.
Your forum is in http://summer2001.ehl.ch/forum, but it shows some garbage and returns an error page. The last url shown is:
http://summer2001.ehl.ch/forum/<%%20=Request.ServerVariables(
It seems you played with code. I'll check where it can be in a couple of minutes.
Think Pink |
 |
|
|
Deleted
deleted
4116 Posts |
Posted - 14 June 2001 : 13:04:04
|
What OS is your server running?
Think Pink |
|
|
|
rschappn
Starting Member
Germany
18 Posts |
Posted - 15 June 2001 : 04:29:23
|
quote:
What OS is your server running?
Think Pink
Hi, to be honest, I do not know. Is there a way to find out ??? What I know is that the server is runningunder roxen challenger. Do you need further info ??
Thanks for the help
RENE
|
|
|
|
rschappn
Starting Member
Germany
18 Posts |
Posted - 15 June 2001 : 05:38:48
|
quote:
What OS is your server running?
Think Pink
OK, I asked and they told me it is FreeBSD 3.2. Does that help....??
|
|
|
|
Deleted
deleted
4116 Posts |
Posted - 15 June 2001 : 07:08:26
|
quote:
OK, I asked and they told me it is FreeBSD 3.2. Does that help....??
Two Questions:
1) Are you sure that they support ASP 3.0 ?
2) Did you make some changes to the code?
PS- there are 60 request.servervariables calls in snitz, so its not easy to find the place exactly.
Think Pink |
|
|
|
rschappn
Starting Member
Germany
18 Posts |
Posted - 15 June 2001 : 10:19:00
|
quote:
Two Questions:
1) Are you sure that they support ASP 3.0 ?
2) Did you make some changes to the code?
PS- there are 60 request.servervariables calls in snitz, so its not easy to find the place exactly.
Think Pink
Well, I just retransferred all files from the .zip back on the server. Still the same message (could not open db...). Am not sure whether they support ASP 3.0, but wait for an answer from them.
But is the path correct, when I now set it up with
strDBType = "access"
and
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
under
/www/docs/summer2001/fpdb/snitz_forums_2000.mdb
where
http://summer2001.ehl.ch/forum/xxxx
is the location of the forum itself??
RENE
|
|
|
|
Deleted
deleted
4116 Posts |
Posted - 15 June 2001 : 17:14:55
|
It seems they do not support ASP. I tried to multiple click the stop icon when the garbage is shown on the screen (before redirection). If I look the source, I even can see the comments of ASP.
So, If I'm not mistakin', I think you have to change your host to run Snitz.
Think Pink |
|
|
| |
Topic |
|
Topic Locked
