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
 Avatar install problem
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

geminione
Starting Member

39 Posts

Posted - 04 May 2001 :  20:51:41  Show Profile  Visit geminione's Homepage
after running mod_dbsetup i got the following:


Avatar Mod v2.0

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.

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

Creating table(s)...
CREATE TABLE FORUM_AVATAR2( A_HSIZE int NULL , A_WSIZE int NULL , A_BORDER int NULL )
Table created succesfully

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

Adding new records..
INSERT INTO FORUM_AVATAR2 (A_HSIZE, A_WSIZE, A_BORDER) VALUES (64, 64, 0)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
Column added successfully
Table(s) updated

I don't know what this means and am clueless about asp

thanks

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 04 May 2001 :  20:58:19  Show Profile
The reason you get that error is because you are using one of the strConnString in config.asp that are labeled for use with Access97 instead of the ones labeled for use with Access2000.

Even if you have an Access97 database, it's still recommended that you use one of the strConnString that are labeled for use with Access2000.

The specific problem is that DEFAULT is not supported in the SQL statement using the strConnString that you are currently using.
Go to Top of Page

geminione
Starting Member

39 Posts

Posted - 04 May 2001 :  21:54:00  Show Profile  Visit geminione's Homepage
gotcha.. thanks... i'll give it a whirl

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