Hello - I get the following error when I do the "mod-dbsetup" and select "Snitz Event Calendar...."
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.
I am on Windows Pro IIS and everything else is running fine. I am also using the MS Access 97 database
switch to the strConnString in config.asp that is labeled for use with MS Acess 2000 (the MS JET driver). The driver you are currently using doesn't support the DEFAULT command in the SQL.
Richard when I do that the forum doesn't run becasue I am using the database that came with the program. Can I change that file? I only have MSAccess 97 on my computer - does tha have anything to do with it???
Topic Locked
Posted - 02 May 2001 : 01:18:53
