| Author |
 Topic  |
|
|
rgarg
Starting Member
30 Posts |
 Posted - 07 September 2002 : 13:33:41
|
Hi,
I tried installing the Poll Mod for Snitz Forum ver 3.3.05 and got database error while trying to update the database using MOD Setup. I am using MS-Access 2000 in the background and the error message is -
Adding Column COUNT1...
ALTER TABLE Forum_TOPICS ADD COLUMN COUNT1 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Please let me know how to correct this error.
Thanks. |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
|
|
rgarg
Starting Member
30 Posts |
Posted - 07 September 2002 : 14:15:35
|
Hamlin,
The link you suggested does not solve the problem. I am able to connect to the db fine but have syntax problem with the ALTER stmt.
I removed 0 in the end and it worked fine. But, the Poll MOD caused problems because it expected 0 and thus had problem in counting. |
 |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 07 September 2002 : 14:21:29
|
The reason I supplied that link is because I thought you were using an access 97 connection string, in the post it states that using an access 2000 type connection string would solve most mod setup problems.
quote:
If you use the Access97 strConnString, they you will more than likely run into problems when using the MOD Setup.
quote:
Using the Access2000 strConnString, you should not encounter the problems with MOD SETUP that you have when using the Access97 strConnString.
|
Edited by - Hamlin on 07 September 2002 14:25:40 |
|
|
|
rgarg
Starting Member
30 Posts |
Posted - 07 September 2002 : 17:27:31
|
Hamlin,
I did some research on this and found that on using Provider=Microsoft.Jet.OLEDB.4.0, the same code works and does not give a syntax error for ALTER stmt. I was earlier using DSN name to connect to my Access 2000 db. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 September 2002 : 17:29:42
|
quote:
Originally posted by rgarg
Hamlin,
I did some research on this and found that on using Provider=Microsoft.Jet.OLEDB.4.0, the same code works and does not give a syntax error for ALTER stmt. I was earlier using DSN name to connect to my Access 2000 db.
That was precisely what Hamlin was recommending in the first place, by posting that link. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
rgarg
Starting Member
30 Posts |
Posted - 09 September 2002 : 08:42:34
|
Ruirib,
Technically, what would be the difference between using DSN to connect to Access 2000 db as opposed to using Provider=Microsoft.Jet.OLEDB.4.0 statement?
I know one  , MOD setup will work fine with Provider= ... stmt, but really why does it make a difference.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 September 2002 : 18:16:44
|
| The DSN uses the old drivers. The DSN is equivalent to using the Access 97 connection string (which does not work well the the mod setup). You can use the Access 2000 connection string, then after setting up your mods, use the DSN again. But the Access 2000 string is always the better in terms of performance. |
Support Snitz Forums
|
|
|
| |
Topic |
|
Topic Locked
