| Author |
 Topic  |
|
|
mafifi
Junior Member
USA
308 Posts |
 Posted - 19 May 2001 : 18:08:30
|
I get the following error with both Access 97 and Access 2000 when I run the mod_dbsetup.asp file from the Snitz Events Calendar v2 sr1. I am now using Access 2000, Snitz Forums 2000 v3.1 SR4 Setup-Fix dated 2/11/2001 and the mod_dbsetup.asp from the zip file. Here are the first few lines from my config.asp from the original Snitz download.
quote:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\html\users\media-2000com\database\snitz_forums_2000.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
Here is the error message:
quote:
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.
Help will be appreciated.
Thanks,
Mo |
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 24 May 2001 : 19:56:08
|
Resolved. Changed the ConnString from:
quote:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\html\users\mafifi\database\snitz_forums_2000.mdb" '## MS Access 97
To
quote:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\html\users\mafifi\database\snitz_forums_2000.mdb;" '## MS Access 2000
Thanks,
Mo |
 |
|
|
Niteridr
Starting Member
22 Posts |
|
|
mario van Ginneken
Starting Member
Netherlands
5 Posts |
|
| |
Topic |
|
Topic Locked
