Web Wiz Support and Community Forums : SQL converstion issue https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 16:22:44 +0000 Sun, 28 Nov 2004 11:07:35 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12720 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL converstion issue : I&#039;m still trying to work...]]> https://forums.webwiz.net/sql-converstion-issue_topic12720_post70488.html#70488 Author: bruce
Subject: 12720
Posted: 28 November 2004 at 11:07am

I'm still trying to work out my Access > SQL conversionissues.  What I have found is that if I upsize my access db onetable at a time and only create the table structure of the TBLthreadand TBLtopic then I don't see the error and it works find. However once I import the data I start seeing the error above.  Itlooks like it is only the tblthread table causing me problems. All the other tables imported with out issue.]]> Sun, 28 Nov 2004 11:07:35 +0000 https://forums.webwiz.net/sql-converstion-issue_topic12720_post70488.html#70488 <![CDATA[SQL converstion issue : Hello, I&#039;m really hoping...]]> https://forums.webwiz.net/sql-converstion-issue_topic12720_post70402.html#70402 Author: bruce
Subject: 12720
Posted: 26 November 2004 at 2:29pm

Hello,  I'm really hoping someone can help me with this.

I'm doing a DTS import to convert my access db to SQL.  I have allthe tables imported and the board running except for when I try post(write to db) I get the following error.  I'm able to create newaccounts ok, but I can't post to the SQL db.

If additional info is required, I'll be happy to supply whatever is need.

Thanks in advance for any help!

This Website is Generating a "500" Error on the Server
The page you have requested cannot be displayed Due to an error

ASP Error occurred 11/26/2004 11:12:01 AM in ADODB.Recordset
Error number: -2146825037 (0x800A0CB3)
File: /gfboard/post_message.asp, line 747
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
]]> Fri, 26 Nov 2004 14:29:09 +0000 https://forums.webwiz.net/sql-converstion-issue_topic12720_post70402.html#70402