Snitz Forums 2000 - Events mod v2 sr1 and access db problem

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Events mod v2 sr1 and access db problem

New Topic

Topic Locked

Printer Friendly

Author

Topic

efrat
Starting Member

25 Posts

Posted - 11 April 2002 : 16:13:50

I tried to install the events calander mod and this is the error I got:

Snitz Events Calendar v2 sr1

Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID int COUNTER NOT NULL , DATE_ADDED text (20) NOT NULL , START_DATE text (20) NOT NULL , END_DATE text (20) NOT NULL , EVENT_TITLE text (100) NOT NULL , EVENT_DETAILS memo NOT NULL , ADDED_BY int NOT NULL , PRIVATE int NOT NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.

any ideas what I should do?

efrat
Starting Member

25 Posts

Posted - 12 April 2002 : 12:20:10

anyone?? any ideas for solution or other ways to find solution?

Thank you, Efrat.

efrat
Starting Member

25 Posts

Posted - 14 April 2002 : 23:21:26

Problem solved:

The problem was that the declaration of the DB was wrong, and allthough all the rest worked the event wanted the right declaration.

Efrat.

Nezazi
Starting Member

2 Posts

Posted - 05 May 2002 : 18:24:58

I had this problem as well !

I took a guess at what erfat meant. My solution was to check that the Database connection string in config.asp is set to the right type for your database (access97 or access2000) etc

Switched mine across and it worked a treat

Now my next problem is .......

Nezazi
STILL LEARNING

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.4 seconds.