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