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
 Data type mismatch in criteria expression???		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Zenfor
Junior Member

372 Posts
Posted - 12 September 2002 :  15:56:13  Show Profile
I read similar messages but am still stuck. I have the latest version and set it up just great.

I turned on NT authentication and it recognizes me just fine.

When any other person in my network trys they get this error:

Microsoft JET Databses Engine (0x80040E07)
Data type mismatch in criteria expression.
/asp/forum/register.asp, line 586

This is line 586:
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

Appreciate any help.

--Burt Lewis
Edited by - Zenfor on 13 September 2002 10:56:05

ASPDude
Starting Member

United Kingdom
41 Posts
Posted - 13 September 2002 :  15:59:27  Show Profile  Visit ASPDude's Homepage
Zenfor

I take it your using V3.4.02? I'm also getting this error and I've already asked the question earlier but no one has answered yet. So I'm still using V3.4.01. I still think there was a problem with the code release for .02 but I cannot seem to target were it was.

As your the second person to come along with this exact error I cannot fathom why no one else appears to have had the same problem or indeed come up with a possible solution.

Any help appreciated guys.

S
Edited by - ASPDude on 13 September 2002 16:00:38
Go to Top of Page

Zenfor
Junior Member

372 Posts
Posted - 13 September 2002 :  18:42:05  Show Profile
I have it working now. I think it happened when I put an @sign in the mail server name or possibly because I didn't leave it blank when I was using CDONTS mail.

It would have been nice if the error was more specific.

Thanks for responding.
Go to Top of Page

ASPDude
Starting Member

United Kingdom
41 Posts
Posted - 16 September 2002 :  05:14:43  Show Profile  Visit ASPDude's Homepage
Are you positive that's all you did? I've changed both of these so that it was either blank when using CDONTS or had an entry when using ASPEMail or JMail.

I still can't get it to work (even though I've now upgraded to V3.4.03!).

Any further advice you can offer Zenfor (or indeed anyone elses help is appreciated.)
Go to Top of Page

Zenfor
Junior Member

372 Posts
Posted - 17 September 2002 :  08:49:15  Show Profile
I turned off "Use NT auto logon". That I think made it work for me.
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.51 seconds. Powered By: Snitz Forums 2000 Version 3.4.07