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

lockstock
Starting Member

United Kingdom
13 Posts

Posted - 30 June 2010 :  10:00:10  Show Profile  Visit lockstock's Homepage
Hi,

Made a school boy error by not backing up the forum when adding new files.

1) Saw there was an upgrade from 3.4.06 to 3.4.07

2) Downloaded it and began to transfer the files manually in batches of three then checked to see if the web site was okay.

3) Got to the config.asp file and of course that is when the error message kicked in. :-

There has been a problem...

Your strDBType is not set, please edit your config.asp
to reflect your database type.



The forum is :- http://www.leedsu-forum.org.uk/


I have attempted to follow the instructions in the config.asp file, but to no avail.


Can anyone help, I don't have an old 3.4.06 config.asp file. However I do have a 3.4.04 file but that also has errors in, ( it allows me to see the website and its contents but not the posted comments etc.)

Edited by - lockstock on 30 June 2010 10:01:40

Carefree
Advanced Member

Philippines
4124 Posts

Posted - 30 June 2010 :  10:09:23  Show Profile
In "config.asp" look for the following lines (appx 55-57 ):


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


You need to remove the apostrophe from the front of the line which applies. In the case of Access, line 56.
Go to Top of Page

lockstock
Starting Member

United Kingdom
13 Posts

Posted - 30 June 2010 :  14:52:57  Show Profile  Visit lockstock's Homepage
Thanks for the reply CF


I have done that but I am still getting the same error message.


How do I address the next statement below that, at present I have altered line 63

'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""dbase/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbase\snitz_forums_2000.mdb" '## MS Access 2000 using physical path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(2../private/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbase\snitz_forums_2000.mdb" '## MS Access 97 using physical path
'strConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("dbase/snitz_forums_2000.accdb") '## MS Access 2007 using virtual path
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "Provider=SQLNCLI;server=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 2005 w/ SQL Native Client
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '## MySQL w/ MyODBC v3.51
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "DSN_NAME"

Edited by - lockstock on 30 June 2010 14:53:42
Go to Top of Page

Carefree
Advanced Member

Philippines
4124 Posts

Posted - 30 June 2010 :  15:33:03  Show Profile
Look in the functional (with errors) "config.asp" file and copy the uncommented (missing apostrophe) line which defines the "strConnString" variable into your new "config.asp" file.
Go to Top of Page

lockstock
Starting Member

United Kingdom
13 Posts

Posted - 30 June 2010 :  15:49:31  Show Profile  Visit lockstock's Homepage
Hello again- CF

www.leedsu-forum.org.uk


Got a little bit further,I can now see the forum again, but when you click on a topic, you cannot open it and I am getting this message

Microsoft VBScript runtime error '800a01c3'

Object not a collection

/topic.asp, line 1349


NB: I have only uploaded half the new files 3.4.06 up 3.4.07, could this be the problem?


Is there any way you could sort this out from your end? In years gone by, the mod from Portugal used to help us out.

Edited by - lockstock on 30 June 2010 15:56:51
Go to Top of Page

Carefree
Advanced Member

Philippines
4124 Posts

Posted - 30 June 2010 :  17:09:26  Show Profile
Having only uploaded half the files could definitely have an impact lol. Since I have no idea which were uploaded and which were not, we could be fixing an error at a time for quite a while. It would be best to finish the upgrade and upload all of the new files, then we can see what has to be done. Do not re-upload config.asp
Go to Top of Page

lockstock
Starting Member

United Kingdom
13 Posts

Posted - 30 June 2010 :  17:32:29  Show Profile  Visit lockstock's Homepage
Okay,

As you can see, I am a bit of a novice when it comes to all of this, I do my best, but some times it's akin to wading through treacle.

I will finishing uploading all the files from the upgrade folder 3.4.06 up 3.4.07. and then report back.


Cheers
Go to Top of Page

lockstock
Starting Member

United Kingdom
13 Posts

Posted - 30 June 2010 :  17:55:59  Show Profile  Visit lockstock's Homepage
Wahey,


back up and running. It was the missing files :-)


Lost some of the mods though, calendar, who is online. the section that allows you to separate the run of the mill topics from the more important topics.

The above 3 are the ones that readily spring to mind and stand out as missing, I cannot remember if the latter is a mod or just a function with in the forum.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2016 Snitz™ Communications Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000 Version 3.4.07