Web Wiz Support and Community Forums : Help with Error on SQL DB when running https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 15:15:13 +0000 Wed, 21 Jan 2004 02:14:07 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=9037 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Help with Error on SQL DB when running : Wierd, I&#039;m puzzled why the...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48066.html#48066 Author: Jesper
Subject: 9037
Posted: 21 January 2004 at 2:14am

Wierd, I'm puzzled why the table we created without setting the identity property ]]> Wed, 21 Jan 2004 02:14:07 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48066.html#48066 <![CDATA[Help with Error on SQL DB when running : Jesper wrote:ok... I&#039;ve...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48044.html#48044 Author: WebWiz-Bruce
Subject: 9037
Posted: 20 January 2004 at 7:12pm

Originally posted by Jesper Jesper wrote:

ok... I've figured it out.

There's a bug in the creation of tables on the MSSQL server on Borg's behalf.

The Author_ID column in the tblAuthors table is set to 'integer'. Inthe Access version this is 'autonumber'. I set the Identity property ofthe column to 'Yes', Identity seed to 1 and finally Identity incrementto 1.

That fixed that problem  ... I'm not too sure if that solution causes other problems ? Borg?



There isn't a bug in my SQL server creation file, see the followingline from the file sets the Author_ID field to interger; Indentity,incrementing by 1 and not allowing nulls:-

strSQL = strSQL & "[Author_ID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,"
]]> Tue, 20 Jan 2004 19:12:16 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48044.html#48044 <![CDATA[Help with Error on SQL DB when running : thank you all.. it did fix my...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48040.html#48040 Author: nguyencno5
Subject: 9037
Posted: 20 January 2004 at 7:02pm

thank you all.. it did fix my problem.. My forum is running on SQL now..


Thanksssssss!
]]> Tue, 20 Jan 2004 19:02:31 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48040.html#48040 <![CDATA[Help with Error on SQL DB when running : in access it should be integer...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48004.html#48004 Author: Semikolon
Subject: 9037
Posted: 20 January 2004 at 2:42pm

in access it should be integer (or int), but it should also be Identity Yes, key Yes, id seed 1 and id increment 1]]> Tue, 20 Jan 2004 14:42:06 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48004.html#48004 <![CDATA[Help with Error on SQL DB when running : ok... I&#039;ve figured it out. There&#039;s...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48001.html#48001 Author: Jesper
Subject: 9037
Posted: 20 January 2004 at 2:36pm

ok... I've figured it out.

There's a bug in the creation of tables on the MSSQL server on Borg's behalf.

The Author_ID column in the tblAuthors table is set to 'integer'. In the Access version this is 'autonumber'. I set the Identity property of the column to 'Yes', Identity seed to 1 and finally Identity increment to 1.

That fixed that problem  ... I'm not too sure if that solution causes other problems ? Borg?

]]> Tue, 20 Jan 2004 14:36:08 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post48001.html#48001 <![CDATA[Help with Error on SQL DB when running : if you pay an ISP for hosting...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47998.html#47998 Author: Semikolon
Subject: 9037
Posted: 20 January 2004 at 2:24pm

if you pay an ISP for hosting and they support ms sql, they will probabl help yopu with upgrading.. some do it for free, as access is a pain in the ass for the hosts, and some require an additional fee(it shouldnt be very much).. this is absolutely the best way to move to ms sql if you have data in your access database that you want to keep..

]]> Tue, 20 Jan 2004 14:24:15 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47998.html#47998 <![CDATA[Help with Error on SQL DB when running : I have the same problem... upgraded...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47995.html#47995 Author: Jesper
Subject: 9037
Posted: 20 January 2004 at 2:18pm

I have the same problem... upgraded from Access to MSSQL (at least I'm trying to )

 

]]> Tue, 20 Jan 2004 14:18:06 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47995.html#47995 <![CDATA[Help with Error on SQL DB when running : maybe.. have you changed any files?...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47973.html#47973 Author: Semikolon
Subject: 9037
Posted: 20 January 2004 at 12:54pm

maybe.. have you changed any files? other than the database?

]]> Tue, 20 Jan 2004 12:54:26 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47973.html#47973 <![CDATA[Help with Error on SQL DB when running : I had no problem with Access DB...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47868.html#47868 Author: nguyencno5
Subject: 9037
Posted: 19 January 2004 at 5:35pm

I had no problem with Access DB before.  I'm not sure how thishappen.  I just recently upsized my Access DB to Ms SqL.

can you think of any thing that could cause this?

Thanks!
]]> Mon, 19 Jan 2004 17:35:05 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47868.html#47868 <![CDATA[Help with Error on SQL DB when running : this means that you try to insert...]]> https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47845.html#47845 Author: Semikolon
Subject: 9037
Posted: 19 January 2004 at 3:02pm

this means that you try to insert an empty value, but the field in the database doesnt support it.. make sure you have filled in all the required fields in the registration form..]]> Mon, 19 Jan 2004 15:02:53 +0000 https://forums.webwiz.net/help-with-error-on-sql-db-when-running_topic9037_post47845.html#47845