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: Database: MS Access
 '(unknown)' is not a valid path		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

phreakazoid
Starting Member

Belgium
9 Posts
Posted - 06 June 2001 :  09:11:13  Show Profile
Hi all,

I search the entire forum, and found several topics regarding to this error and they all have been resolved by putting the right path in the config.asp but here is MY story...

I installed the latest snitz forum on www.ultima.be/cisco (dutch) and I changed the config.asp to

'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\www.ultima.be\cisco\forum\tools\snitz2k.mdb;"

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"

When I run http:\\www.ultima.be\cisco\forum\setup.asp it says everything is installed correctly.

When I go to the default.asp it comes with this error..

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

I used the whereami.asp to triplecheck the location (i am owning the server) and it's correct.

You will probably see a username and password comming up and wondering that's the problem, well I made sure an account has change permissions on the db folder so it could create the LDB file..

I would greatly appreciate any help. If you want to help and need the U/P please mail me.

tonino.bruno@pandora.be

Doug G
Support Moderator

USA
6493 Posts
Posted - 06 June 2001 :  12:24:18  Show Profile
You are sure of the physical path to the db file? Having the complete url as part of the path is not common.

You can download a utility 'whereami' from the main Snitz page which will verify the actual path to your file.


======
Doug G
======
Go to Top of Page

phreakazoid
Starting Member

Belgium
9 Posts
Posted - 07 June 2001 :  06:24:17  Show Profile
Like I said in my original posting

"I used the whereami.asp to triplecheck the location (i am owning the server) and it's correct. "



We use url names for our web folders to make our administration somehow easier. On the same server I also have www.watnu.com as a folder, included in the path and it works fine.
Also replacing the full path with Server.Mappath("/cisco/forum/tools/snitz2k.mdb") doesn't work either..
Go to Top of Page

mrWize
deleted

119 Posts
Posted - 07 June 2001 :  17:30:29  Show Profile
Have U tried this:

Response.Write Server.MapPath("/cisco/forum/tools/")


That will print out the correct path to the folder .... if it exist =P

cya,
mrWize
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 07 June 2001 :  22:47:08  Show Profile
Do you have only one connection string uncommented? The error message you show isn't the one I'd expect to see for the connection string you're using.


======
Doug G
======
Go to Top of Page

phreakazoid
Starting Member

Belgium
9 Posts
Posted - 08 June 2001 :  04:03:39  Show Profile
To mrWize,

I really appreciate your effort to help me but please read the entire article as I am going to say for the third time, my path is correct. I am an ASP Developer myself have built lot's of ASP site's for company's..I used all the scripts provided by Snitz to determine the path to the folder and it's correct.

To Doug G,

I know what you referring to, but to rule out any mistakes I removed all the other connectionstrings as you can see in the first post I made.

I saw on the microsoft site that there is a new update on the MDAC 2.5 SP2 !! I am going to install that now and see what happenes.

I have a feeling there is a corruption somewhere...

thanx again for your effort...
Go to Top of Page

phreakazoid
Starting Member

Belgium
9 Posts
Posted - 08 June 2001 :  05:11:34  Show Profile
Guess what, after installing MDAC 2.5 SP2 (before 2.5 SP1) my second forum on the same site works fine !!!

So there was no problem with the PATH

Spread the word....
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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07