Snitz Forums 2000 - Faq Modification

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Faq Modification

New Topic

Topic Locked

Printer Friendly

Author

Topic

Reloadmaster
Starting Member

32 Posts

Posted - 26 June 2001 : 18:54:25

CREATE TABLE FORUM_FAQ( F_ID int COUNTER NOT NULL , F_FAQ_QUESTION VARCHAR (100) NOT NULL , F_FAQ_ANSWER memo NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.

Whats wrong?

Moved by Richard from Help: General

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 26 June 2001 : 19:50:16

Have you tried using one of the strConnString lines in your config.asp that is labeled for use with Access 2000 ? (they ones that use MS Jet 4.0 drivers)

Memorom
Starting Member

24 Posts

Posted - 14 July 2001 : 13:30:33

I am getting the same error...

Creating table(s)...
CREATE TABLE FORUM_FAQ( F_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , F_FAQ_QUESTION#VARCHAR (100)#NOT NULL# NOT NULL , F_FAQ_ANSWER#memo#NOT NULL# NOT NULL )
-2147217900 | Syntax error in field definition.

so it's not creating the table at all.

I am using the ...

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../db/snitz_forum_2000.mdb") '## MS Access 2000 using virtual path

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 14 July 2001 : 15:29:58

you are using an older version of mod_dbsetup, was there one supplied wih the MOD ?

Memorom
Starting Member

24 Posts

Posted - 16 July 2001 : 19:30:34

That did it Huwr...thanks.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.29 seconds.