| Author |
 Topic  |
|
|
matthstrife
Starting Member
5 Posts |
 Posted - 20 February 2005 : 01:44:23
|
Here is my problem: I'm a first time user and just did a fresh new install of the forum, edited the config file and when I get to the setup it still says that strDBtype is not set... What could be the problem here? Could it be because I'm running it on my own machine and IIS isn't set up properly?
I ran a search but found nothing satisfactory or I maybe missed something because my search was perhaps too narrow, I hope I'm not reposting something that has been posted before. |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 20 February 2005 : 01:48:47
|
To me it is an error withthe way that you have setup your config.asp file. You need to select Access, MSSQL or MySQL and the right string to go along with it. If you need more help on it, it is in the readme file in the zip. I hope it helps.
|
Cheers,
David Greening |
 |
|
|
matthstrife
Starting Member
5 Posts |
Posted - 20 February 2005 : 02:04:52
|
Here is the DB selection part of my config file (some types left out because it would make the post too long, of course)
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## 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("db\asp_forum.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\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("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
this should be correct, no?
edit: i changed the backslashes to slashes but it changed nothing, even added one before 'db'. Still says that strDBType is not set |
Edited by - matthstrife on 20 February 2005 02:08:36 |
|
|
|
TStewartFan
Junior Member
190 Posts |
Posted - 20 February 2005 : 08:23:44
|
It isn't from this line. Scroll up a bit and uncomment the line as below:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
|
If You Have to Ask, You Wouldn't Understand. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
matthstrife
Starting Member
5 Posts |
Posted - 20 February 2005 : 13:13:18
|
| Yes, the file is the forum folder, I edited it directly from that folder after unzipping. I really am clueless now... |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 20 February 2005 : 13:17:20
|
quote:
Originally posted by matthstrife
Yes, the file is the forum folder, I edited it directly from that folder after unzipping. I really am clueless now...
Did you try using the 3rd connection string (the direct path)  |
eXtremeGossip  |
|
|
|
matthstrife
Starting Member
5 Posts |
Posted - 22 February 2005 : 00:19:30
|
Well. I didn't try the direct connection but I DID reboot my computer, fixed the strDBType not set problem... now it only seem like I have to create the tables manually. I'll try the direct path method and edit my post if it doesn't work.
Edit: Ok, used the direct path connection and it changes nothing. The FORUM_CONFIG_NEW has been created, but that's all, there are no other tables and the setup page returns me a long page of errors with "13 critical errors" at the bottom. A lot of the errors given is that an output table can't be found. Tables such as FORUM_FORUM, FORUM_BADWORDS and so on. I've set permissions Read and Write for Everyone on the folder containing the DB.
Re-edit: Ah... wait, I just re-read the instructions and it says I need to extract the DB provided in the .rar file if I want to use access... I feel dumb now. Well thanks a lot for the help! And sorry if somehow it ended as a 'waste' of time.  |
Edited by - matthstrife on 22 February 2005 00:55:53 |
|
|
|
jrjr2u
Starting Member
46 Posts |
Posted - 22 February 2005 : 12:50:27
|
quote:
Originally posted by matthstrife
I've set permissions Read and Write for Everyone on the folder containing the DB.
You will need write permissions for IUSR_Machinename - where machinename is the name of your server. |
|
|
|
matthstrife
Starting Member
5 Posts |
Posted - 23 February 2005 : 00:53:39
|
| I think that by default it's that way... but anyway when I re-edited my post it was because the problem was solved. Can't believe it was just a matter of restarting my computer. For the missing tables problem it was because I had created a .mdb from scratch instead of using the one provided in the archive... |
|
|
| |
Topic |
|
Topic Locked
