| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 20 May 2002 : 11:51:11
|
Sorry, I misunderstood your folder organization.
To try to figure if the problem is with the connection string, just put it inside your forum folder, change its name to something hard to guess and change the conn string to:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("YourDBFileName"),
replacing YourDBFileName by whatever file name you choose
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 12:00:44
|
quote:
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.
Now, at least we're getting something from the server. Try my previous suggestion by placing the DB in your forum folder and let me know how it goes.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 12:03:01
|
(per your previous post)
putting database file within forum folder, I got this reply now;
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/forum/config.asp, line 58
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("xyz.mdb"),
-------------------------------------------------------------------------------------------^
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 12:12:50
|
Remove the ',' at the end. Sorry it was a typo.
quote:
(per your previous post)
putting database file within forum folder, I got this reply now;
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/forum/config.asp, line 58
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("xyz.mdb"),
-------------------------------------------------------------------------------------------^
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 12:18:26
|
I got this;
Home | Profile | Register | Active Topics | Members | Search | FAQ
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/forum/inc_functions.asp, line 717
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 12:42:02
|
Now, I'm getting happier. That's a permissions problem and your forum is already setup. You'd need to have your host change the folder permission to allow read/write access. I just wouldn't recommend that to be done in your forum folder.
Here is how I think you should proceed:
1. Add a Response.Write Server.MapPath("xyz.mdb") just before the line where your strConnString is defined, so that we know the actual physical path to the DB.
2. Move the database again to the starting folder. You can use the info obtained in 1 to deduce the actual physical to that folder and then will change the connstring to:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\yourDeducedPathWillcomeHere\xyz.mdb"
3. You can then ask your provider to grant read/write permissions on that initial DB folder to the Anonymous Internet user (IUSR_YOURMACHINENAME user).
Right now just do 1. and post the data here.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
bisala
Starting Member
26 Posts |
Posted - 20 May 2002 : 16:12:38
|
thanks Rui for your continous feedback and care,
my forum is operating now (at last).
despite the valuable help available here,
I think a tutorial or how-to on strings would be helpful and timesaving for newcomers.
it took half my day to solve it out.
thanks and best regards
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 16:52:50
|
quote:
thanks Rui for your continous feedback and care,
my forum is operating now (at last).
despite the valuable help available here,
I think a tutorial or how-to on strings would be helpful and timesaving for newcomers.
it took half my day to solve it out.
thanks and best regards
You are welcome  . There is a pretty good guide on connection strings. Just click the Installation Guide link in my signature to get there.
Enjoy your forum.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 19:18:59
|
Great article Doug. I just can't understand why that has been in 'hiding' all this time. It could have been put to good use quite a few times here. I just added it to my useful Snitz links list. You'll be getting more visitors from now on...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 20 May 2002 : 23:24:10
|
Thanks!
Someday I'm going to finish up with the FAQ site, right now it's difficult to find the FAQ list from an article link :(
======
Doug G
====== |
|
|
|
Topic |
|
Topic Locked
