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
 strConnstring looks for database in webroot
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Cobia
Starting Member

United States
39 Posts

Posted - 27 June 2008 :  14:25:52  Show Profile
As an anonymous searcher I have reviewed the faq and several hundred specific postings in the support area. I like the snitz forum format of other sites.

I have a problem or Brinkster is causing a problem, because many of the snitz forums are up and running.

I can not get the strconnstring to recognize the database location. I have the database in the root <dir> under database <dir> and the other files are in the webroot <dir>.

Most attempts to connect shows an error which directs the config file to look in the webroot for the database and I am unsure of the fix for this problem.

If I put the database in the webroot file, the connection to the database works and this creates other problems.
How can I stop the strconnstring from looking in the webroot <dir>.
http://ctyner.brinkster.net I will change the database name. The database is also empty.

I contacted brinkster and verified the database file has read write permissions, they told me the permission was assigned, but I wonder.


Error description and connection string
Error Description :
'c:\inetpub\database\secretdbname.mdb' 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
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\database\secretdbname.mdb" '## MS Access 2000

Error Description :
'E:\Sites\Pungo5\ctyner\webroot\ctyner\database\secretdbname.mdb' 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.
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/ctyner/database/secretdbname.mdb") '## MS Access 2000 on Brinkster




Error description and connection string
Server.MapPath() error 'ASP 0172 : 80004005'
Invalid Path
/config.asp, line 57
The Path parameter for the MapPath method must be a virtual path. A physical path was used.
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("c:/database/secretdbname.mdb") '## MS Access 2000 on Brinkster

Error description and connection string
Error Description :
'E:\Sites\Pungo5\ctyner\webroot\database\secretdbname.mdb' 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.
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database\secretdbname.mdb") '## MS Access 2000 using virtual path
Error description and connection string
Error Description :
'E:\Sites\Pungo5\ctyner\webroot\database\secretdbname.mdb' 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.
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/secretdbname.mdb") '## MS Access 2000 using virtual path


Thanks for the help.<

Edited by - Cobia on 27 June 2008 14:27:06

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 June 2008 :  21:00:17  Show Profile  Send ruirib a Yahoo! Message
You should check Brinskster's documentation to find out the conn string to use. You may find it hard to use Snitz at Brinkster, though.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Cobia
Starting Member

United States
39 Posts

Posted - 28 June 2008 :  21:38:56  Show Profile
ruirib,
thanks for the response. I have come to the same conclusion. I have been on the phone and chat line with the host, They can not stop the strconnstring from seeking the database in the webroot dir.

If I put the database in the webroot the forum works, unfortunatly this is a problem in itself.

I like the look and performance of other sites powered by snitz, so my only thing now is to move on to another host.

This is a great source of information for those of us that need that little nudge in the right direction. You guys are great, thanks again.

My problem is now solved...new host.<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 June 2008 :  21:44:34  Show Profile  Send ruirib a Yahoo! Message
The upside is that you may find it hard to get a worse host than Brinkster.<


Snitz 3.4 Readme | Like the support? Support Snitz too
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.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07