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
 pls help		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tlem442
Starting Member

1 Posts
Posted - 07 May 2001 :  17:36:18  Show Profile
I tried to add the mod into my access db and I get this:

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.

any ideas. I think it's a simple error somewhere. I already redownloaded the mod_dbsetup.asp again ( dated 3/25/01)

thanks

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 07 May 2001 :  19:51:54  Show Profile
you need to change the strConnString you are using in config.asp to one of the ones labeled for use with Access2000.

Even though you are using an Access97 Database, it's still recommended to use one of the connection strings labeled for use with Access2000.

Basically the DEFAULT statement is not supported by the driver you are currently using.
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