Print Page | Close Window

HELP! Errors after ACCESS to SQL

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4498
Printed Date: 02 April 2026 at 2:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: HELP! Errors after ACCESS to SQL
Posted By: kl8ton
Subject: HELP! Errors after ACCESS to SQL
Date Posted: 24 July 2003 at 2:31pm

Most things work correctly but there are a few errors that I get in certain places on the forums.  Here is what I get when I try to register.  The error occurs after filling in user information and clicking the register button:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'Author_ID', table 'InsideStilesForums.dbo.tblAuthor'; column does not allow nulls. INSERT fails.
/webwiz/forum/register.asp, line 821

 

This next error happens when I try to add a user to my buddy list:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'Address_ID', table 'InsideStilesForums.dbo.tblBuddyList'; column does not allow nulls. INSERT fails.
/webwiz/forum/pm_add_buddy.asp, line 152

I checked the SQL tables and it is like the forum isn't trying to put a number in those fields.  Should I allow NULLS in the tables?  Or should I be looking somewhere else?  Please help!




-------------
Clayton



Replies:
Posted By: michael
Date Posted: 24 July 2003 at 2:41pm

open the db in enterprise manager and change the datatype to int for the id fields mentioned above, then change it to increment...



-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: kl8ton
Date Posted: 05 August 2003 at 12:39pm

Well that took care of those problems.  Thanks for your help.

Now I have some new ones that hopefully you can help me with.

After adding a new test user I click on the Members List button and get the following:

Error Type:
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null: 'CLng'
/webwiz/forum/members.asp, line 341

 

I also get the following error if I click on the membership admin button on the admin page.  It must have to do with this CLng field or value.

 

Error Type:
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null: 'CLng'
/webwiz/forum/admin/select_members.asp, line 279

 

Please help.  Thanks



-------------
Clayton


Posted By: WebWiz-Bruce
Date Posted: 05 August 2003 at 1:22pm

Often when upsizing from access to sql server unless you get it correct the default values, relationships, etc. are not carried over. This often happenes if you use a DSN to uypsize the database.

Start over again as you do need to get all the default values and raltionships correctly carried over to get the forum to function correctly.



-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: kl8ton
Date Posted: 06 August 2003 at 11:46am

Ok I started from scratch.  Made a new database, ran the MS SQL setup, i comletely configured the forums from the admin page, I registered a test user (so far all is well).

I went to test posting for the first time and I get this:

Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'CuLocation'
/webwiz/forum/post_message.asp, line 590

 

Any suggestions?



-------------
Clayton


Posted By: WebWiz-Bruce
Date Posted: 06 August 2003 at 12:00pm

I suggest using a program like http://www.flasfxp.com - www.flasfxp.com to upload your files as it looks like they are becoming corrupted. The forum should run fualtlessly with no errors and much bug testing has been done over the last 3 years to make sure it shouldn't crash.

The file you mention should read:-

.CursorType = 2

and no where should it say CuLocation



-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: kl8ton
Date Posted: 06 August 2003 at 12:10pm

THANK YOU THANK YOU

 

That worked.  That was the only thing that I couldn't do.

 

Thanks again.



-------------
Clayton



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net