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
 Events Calendar Setup
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

cranderson
Starting Member

2 Posts

Posted - 24 May 2001 :  14:59:00  Show Profile
Get this error information on running the mod_dbsetup.asp....

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.

--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum.

Aznknight
Senior Member

USA
1373 Posts

Posted - 24 May 2001 :  15:31:52  Show Profile  Send Aznknight an AOL message  Send Aznknight an ICQ Message
if you're using acces database then use the access 2000 connection string. It'll work on access 97 db as well. That should fix your problem.

- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Go to Top of Page

mafifi
Junior Member

USA
308 Posts

Posted - 24 May 2001 :  20:32:43  Show Profile  Send mafifi an ICQ Message
It worked for me. Try this:
quote:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\html\users\mafifi\database\snitz_forums_2000.mdb;" '## MS Access 2000




The above line will also work with Access 97

Thanks,

Mo
Go to Top of Page

cranderson
Starting Member

2 Posts

Posted - 25 May 2001 :  14:26:45  Show Profile
Thanks "A & M"...worked like a charm.
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