| Author |
 Topic  |
|
|
Seleck
Starting Member
Germany
14 Posts |
 Posted - 11 November 2003 : 04:11:22
|
Hi there,
I installed version V-3.1.4 und die V-3.4.03 on a Windows2000 server with + IIS and MS SQL with NT-Authentification as Intranet forum.
Version V-3.1.4 is working properly but i have problems with V-3.4.03. (This version is running totally separate from V-3.1.4)
Everey time registering as a new member you get following Error:
============================================================
Compilingerror in Microsoft VBScript- Error '800a03ea'
Syntaxerror
/iisHelp/common/500-100.asp, line 129
elseIf (objASPError.Description > "") Then
Microsoft OLE DB Provider for ODBC Drivers- Error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]the ZERO value cannot insert in the MEMBER_ID-columne of SNITZ2.dbo.FORUM_MEMBERS-Tabell. the columne do not allow Zero-Value. Error by INSERT.
/forum2/register.asp, line 599
=================================================================
I have already checked that the tabell allow the zero value, I also tried this with Access-database but same error.
It would be nice if someone help me here. i need this version running on our Intranet as soon as possible.
Thank you |
SEL
--------
http://www.bradseleck.com |
Edited by - ruirib on 11 November 2003 07:46:06 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 11 November 2003 : 05:06:09
|
The MEMBER_ID column should actually be an Identity column, you might want to double check that.
How did you install the forum ? did you use setup.asp to create the database tables ? |
Kiwihosting.Net - The Forum Hosting Specialists
|
 |
|
|
Seleck
Starting Member
Germany
14 Posts |
Posted - 11 November 2003 : 08:51:54
|
The MEMBER_ID column should actually be an Identity column, you might want to double check that.
How did you install the forum ? did you use setup.asp to create the database tables ?
No, I created a new database and convert the table with help of
DTS Import/Export Wizard of SQL Server.
Every thing work ok, it cause problem only with new registration |
SEL
--------
http://www.bradseleck.com |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 11 November 2003 : 09:07:42
|
You should always create the database using setup.asp as this will ensure all of the fields are created with their correct datatypes, I do beleive your registration problem is becuase your MEMBER_ID column isn't correctly set as an identity column.
You can always DTS the data into the database once setup.asp has been run (providing you don't create drop statements in your package).
When you say you tried this with an access database as well, was it the database supplied with the 3.4.03 zip file you tried ? (version 3.1 databases and 3.4 databases do have several differences) |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Seleck
Starting Member
Germany
14 Posts |
Posted - 12 November 2003 : 06:25:24
|
Hi Gremlin,
Thank you for the great help. I have created the Database with setup.asp and its working. What i still can't understand, why it caused problems with access database supplied with the 3.4.03 zip file.
I have another question for you:
User in our Intranet, where i am running snitz with NT-authentification, don't want to register again with username and password managed from snitz itsself.
Is there any solution or MOD, which allow to use snitz without 2nd loggin ?
Thankyou again for your kind help |
SEL
--------
http://www.bradseleck.com |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 12 November 2003 : 06:39:11
|
| use NT authentication instead of DB authentication. Users will still need to register, but their NT account will automatically log them into the snitz forum |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 12 November 2003 : 06:49:23
|
quote:
why it caused problems with access database supplied with the 3.4.03 zip file.
I can't think of any reason why it would have done that with the supplied database as well, is it possible you were perhaps still actually using the MS SQL Database and didn't realise ? |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Seleck
Starting Member
Germany
14 Posts |
Posted - 14 November 2003 : 06:18:38
|
No Gremlin, i checked it again , i define strDBType and strConnString correctly for accessdatabase
well thank you a lot anyway. |
SEL
--------
http://www.bradseleck.com |
|
|
| |
Topic |
|
Topic Locked
