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: General / Classic ASP versions(v3.4.XX)
 Can not register new users
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

JEM618
New Member

62 Posts

Posted - 20 September 2002 :  19:50:58  Show Profile
Any suggestions?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Field 'FORUM_MEMBERS.M_SIG' cannot be a zero-length string.

/snitzforum3/register.asp, line 569

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 September 2002 :  19:58:09  Show Profile  Send ruirib a Yahoo! Message
You'll need to download your access DB, open it with MS Access, open FORUM_MEMBERS table in design mode and change the Allow Zero Length Property for the M_SIG field to Yes.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

nitrousonline
Starting Member

1 Posts

Posted - 21 September 2002 :  17:26:19  Show Profile
Since I don't have access and don't want to buy it...what now? Shouldn't the database have already come fixed?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 21 September 2002 :  17:28:23  Show Profile
the database that comes with v3.4.xx doesn't have this problem, it's older versions of the Access DB that did.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 September 2002 :  17:34:54  Show Profile  Send ruirib a Yahoo! Message
If this is a new forum, you can just use the DB that comes with the download. Otherwise I can convert it for you, if you want.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 21 September 2002 :  17:39:37  Show Profile
You can try the script snippet here to remove the "zero length string" property on all text columns.

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=33158

======
Doug G
======
Computer history and help at www.dougscode.com
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.33 seconds. Powered By: Snitz Forums 2000 Version 3.4.07