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: MOD Implementation
 My Avatar MOD problem
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

BrianTT
New Member

57 Posts

Posted - 18 June 2001 :  06:22:23  Show Profile
When I run the DB_setup file, I get this error on the top line:

Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int COUNTER NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.

--------------------------------------------------------------------------------

Anyone know the reasons for this?

I edited all the files the way the read me said, but I noticed when I was editing the topic.asp file the line with the '<br>' didnt line up with the other 2 that were below it...Could this have anything to do with the error?

The Avatar shows up in admin options but dosent work all the way and admin is the only thing that I can find that has anything to do with them...

Any help?




RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 18 June 2001 :  07:23:46  Show Profile
The reason you get that error is because of the strConnString you are using in config.asp

You are using one labeled for use with Access97 instead of one labeled for use with Access2000. Change to one of the ones labeled for use with Access2000 and you won't get that error.
Go to Top of Page

BrianTT
New Member

57 Posts

Posted - 18 June 2001 :  07:38:15  Show Profile
I tried that, but my forum wont work at all then...As far as I can tell,I'm only allowed to use the Access 97 StrConnString...

I'll try again though, maybe I'm doing something wrong...

Go to Top of Page

BrianTT
New Member

57 Posts

Posted - 18 June 2001 :  08:55:16  Show Profile
Nope, I cant get and of the strConnString lines to work, only the access 97 one...

Is 97 the only one I am able to use or could I be doing something wrong?I'm using a Brinkster account if that means anything...

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 18 June 2001 :  15:37:47  Show Profile
What is your brinkster account name?

Here is what you should use:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\YOURUSERNAME\db\snitz_forums_2000.mdb") & ";"  '## MS Access 2000


just replace YOURUSERNAME with your Brinkster username.
Go to Top of Page

BrianTT
New Member

57 Posts

Posted - 18 June 2001 :  18:40:54  Show Profile
Thanks! I got it working now and dont notice any problems...

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.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07