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: General / Current Version (Old)
 Help ... I'm a NEWBIE
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

NucleusWDS
Starting Member

United Kingdom
38 Posts

Posted - 20 April 2001 :  11:27:04  Show Profile  Visit NucleusWDS's Homepage  Send NucleusWDS an ICQ Message
I have ACCESS 2000 and IIS5 running on Windows 2000 Pro. I wanto setup Snitz2000 but after editing the 'config.asp' file I have a error. It can't find the database.
I already unzipped 'snitz_forums_2000.mdb' file and placed it in a read/writeable directory.

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 April 2001 :  11:44:05  Show Profile
Can you post the lines that you edited in config.asp
Go to Top of Page

NucleusWDS
Starting Member

United Kingdom
38 Posts

Posted - 20 April 2001 :  12:10:09  Show Profile  Visit NucleusWDS's Homepage  Send NucleusWDS an ICQ Message
This is the ERROR I get ...

The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.



Code : -2147467259


Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 April 2001 :  12:14:46  Show Profile
Can you post what you have in your config.asp file between the following code:

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

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
Go to Top of Page

NucleusWDS
Starting Member

United Kingdom
38 Posts

Posted - 20 April 2001 :  12:17:11  Show Profile  Visit NucleusWDS's Homepage  Send NucleusWDS an ICQ Message
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/snitz_forum_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Winston\Websites\AMD3D\forum\snitz_forum_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


I have ACCESS ... so which one to I uncomment

Go to Top of Page

NucleusWDS
Starting Member

United Kingdom
38 Posts

Posted - 20 April 2001 :  12:22:56  Show Profile  Visit NucleusWDS's Homepage  Send NucleusWDS an ICQ Message
Iused the 3rd line:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Winston\Websites\AMD3D\forum\snitz_forum_2000.mdb;" '## MS Access 2000

Is this correct?

Go to Top of Page

NucleusWDS
Starting Member

United Kingdom
38 Posts

Posted - 20 April 2001 :  12:29:10  Show Profile  Visit NucleusWDS's Homepage  Send NucleusWDS an ICQ Message
Sorted ... :)

Stupid me ... I had to double chck the line:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Winston\Websites\AMD3D\forum\database\snitz_forums_2000.mdb;" '## MS Access 2000

Phew ! ... that was long ...



Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 April 2001 :  12:34:58  Show Profile
Glad you got it sorted
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.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07