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
 Confused!!!!!		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

jerseyralph
Starting Member

14 Posts
Posted - 15 June 2001 :  18:24:58  Show Profile  Visit jerseyralph's Homepage
I am new to ASP and scripting, so I am having a hard time with this. Here is how I edited my config script. I am getting the "Database Cannot Be Opened" message. Any suggestions would be great!

'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\governmenteducators.com\_private\snitz_forum_2000mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/_private/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://governmenteducators.com/db/snitz_forums_2000.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_"

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 15 June 2001 :  19:11:46  Show Profile  Visit HuwR's Homepage
Your problem is this

Source=http://governmenteducators.com/db/snitz_forums_2000.mdb;" '## MS Access 2000

you can't reference your db using a URL, it must be a physical path or a server mapped path like

server.mappath("/db/snitz_forums_2000.mdb")
Go to Top of Page

jerseyralph
Starting Member

14 Posts
Posted - 19 June 2001 :  06:50:02  Show Profile  Visit jerseyralph's Homepage
I made the following change:

'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\governmenteducators.com\_private\snitz_forum_2000mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/_private/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/db/snitz_forums_2000.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 am still getting the error message
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 19 June 2001 :  13:13:51  Show Profile
Go here http://forum.snitz.com/archive/default.asp?catid=11&cattitle=Forum+Setup+Tools and download the Where Am I? tool. Upload the file to the folder where database is in and go to the file using your browser. It will tell you the path you should use in your config.asp file.

- David
Go to Top of Page

jerseyralph
Starting Member

14 Posts
Posted - 20 June 2001 :  12:49:45  Show Profile  Visit jerseyralph's Homepage
Thanks, I figured it out without have to use the Where Am I file. I had the wrong line noted.
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.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07