| Author |
 Topic  |
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
 Posted - 05 December 2001 : 06:23:00
|
Alright All,
I'd just like to ask if you all know about these problems or if it is just this happens to me....?
Any mod I install which requires adding tables to the database I get table creation errors which stop me from running the mods, I know my database is not corrupt or anything like that because the same thing happens on cleanly installed test fotums I have made, I have also tried with a 97 database & a 2000 database but this makes no difference.
Is this a recognized problem ir is it something I'm doing wrong?
I want to install more mods but everytime I do I have call you guys for help and feel guilty about taking up so much of your time.
So I guess the question is... is it me?
Cheers, Doughnut.
...............................................
Snitz 3.3.03, hosted by 121, access 2000 database.
Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2.
Forum: www.carp-uk.net/forum |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 December 2001 : 06:47:45
|
It's the connection string (strConnString) you are using.
Just about every single MOD (at least the ones that I have released), in the instructions, tell you that you should be using the strConnString that is labeled for use with Access 2000.
If you are using one that looks like this:
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
then you are going to have problems. This driver does not support the DEFAULT property when creating or modifying fields in the database tables.
Use one of the strConnString lines that look like this:
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
and you'll save yourself alot of headaches. |
 |
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 05 December 2001 : 07:21:38
|
Ha Ha,
Im gonna give that a go now!
...............................................
Snitz 3.3.03, hosted by 121, access 2000 database.
Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2.
Forum: www.carp-uk.net/forum |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 05 December 2001 : 07:31:33
|
God!!!!
I wish I asked this question a long time ago 
This just confirms what I thought, you are a genius Richard!
Thanks, Richard you have just solved my biggest headache with Snitz.
...............................................
Snitz 3.3.03, hosted by 121, access 2000 database.
Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2.
Forum: www.carp-uk.net/forum |
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 05 December 2001 : 09:23:20
|
Richard, when releasing the next version, the config.asp file should list the Access 2000 connection strings first.
Additional support files - http://www.snitz.info
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 05 December 2001 : 11:27:02
|
How about just including an Access 2000 database in the ZIP instead of an Access 97 DB? Or perhaps both with the side note that some MODs work/install better on Access 2000?
Roland
- here to help when possible -
http://www.frutzle.com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 December 2001 : 14:55:58
|
| The database in the next release is going to be an Access2000 one. We'll also rearrange the order of the strConnString's, listing the most preferred first. |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 05 December 2001 : 15:30:47
|
Okiedokie 
*now is this a cool 900th post or what? * |
|
|
|
Rasco
Advanced Member
Germany
3192 Posts |
Posted - 05 December 2001 : 15:42:17
|
Yeah, that`s it. Didn`t know that also. Had a problem with a mod. Will try the strConnString
tomorrow. 
|
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 05 December 2001 : 17:34:14
|
I wasn't the only one then
...............................................
Snitz 3.3.03, hosted by 121, access 2000 database.
Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2.
Forum: www.carp-uk.net/forum |
|
|
|
Rasco
Advanced Member
Germany
3192 Posts |
Posted - 06 December 2001 : 05:53:45
|
Gna, didn`t work. Can`t get Access 2000 to work with the server.
|
|
|
| |
Topic |
|
Topic Locked
