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: Authentication: NT
 Registering		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ASPDude
Starting Member

United Kingdom
41 Posts
Posted - 05 September 2002 :  08:26:59  Show Profile  Visit ASPDude's Homepage
I have NT Authentication setup on my forum (V3.4.02) and have autologon enabled. Everything was working fine until today when I received a call from a user who said they had the following error when entering register.asp:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/snitz34/register.asp, line 586

Well line 586 in my register.asp looks like this:

my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

As I said, all users up until today have been able to register without having to register thru register.asp. They've simply been taken in with autologon.

Any ideas, advice appreciated.

S

Kal Corp
Average Member

USA
878 Posts
Posted - 05 September 2002 :  20:15:58  Show Profile  Visit Kal Corp's Homepage
try to have the code post the users info. Might have something not set correctly in the domain settings.

I had a user with no Full name set in the Domain account so the forums could not set a NULL

{VAS}-Kal Corp
VAS Development NetWork - Forums for old Snitz Mods!
Creator of all things {VAS}
Edited by - Kal Corp on 05 September 2002 22:45:41
Go to Top of Page

ASPDude
Starting Member

United Kingdom
41 Posts
Posted - 06 September 2002 :  05:46:27  Show Profile  Visit ASPDude's Homepage
Sorry everyone, I figured it out. I'd been messing with upgrading from a previous DB and it had reset some of the Allow Zero Length fields!!! Bah!!!

Sorted out now though.

Thanx for looking.
Go to Top of Page

ASPDude
Starting Member

United Kingdom
41 Posts
Posted - 06 September 2002 :  09:46:55  Show Profile  Visit ASPDude's Homepage
Thought we had this licked but it appears not. I'm fine as long as I stay in the V3.4.01 version but when I upgrade to V3.4.02 and then apply all the changes that have been highlighted in the bugs forum for V3.4.02 update then I still get the above error message.

Any help appreciated.
Go to Top of Page

ASPDude
Starting Member

United Kingdom
41 Posts
Posted - 10 September 2002 :  06:03:17  Show Profile  Visit ASPDude's Homepage
Has no one else come across this problem then?
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 1.83 seconds. Powered By: Snitz Forums 2000 Version 3.4.07