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
 Complete newbie needs help please!!
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tralesh
Starting Member

United Kingdom
6 Posts

Posted - 12 February 2001 :  04:54:21  Show Profile
I have just bejunb to use ASP so this will be really basic questions!!

My forum is installed etc on my web host, with the database supplied in my cgi-bin.

I have set the config area as below:
*********************************************
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/e:/barnaby/lost-order.com/forum/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=/e:/barnaby/lost-order.com/forum/cgi-bin/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_"

********************************************
However I get that 2147467259 error when I run setup.asp and this one when I try default.asp:
Microsoft JET Database Engine error '80004005'

Not a valid file name.

/forum/inc_top.asp, line 42


Any help for this complete nubie appreciated (I feel like an idiot asking all these questions - sorry!!)

Dave

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 12 February 2001 :  04:58:14  Show Profile  Visit HuwR's Homepage
this is your problem

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/e:/barnaby/lost-order.com/forum/cgi-bin/snitz_forums_2000.mdb;" '## MS Access 2000


if all your forum code is in
/e:/barnaby/lost-order.com/forum/
use this as your connection


strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = server.mappath("cgi-bin/snitz_forums_2000.mdb");" '## MS Access 2000



'Resistance is futile'
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.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07