Web Wiz Forums - SQL converstion issue

Print Page | Close Window

SQL converstion issue

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=12720
Printed Date: 11 April 2026 at 4:21pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL converstion issue

Posted By: bruce
Subject: SQL converstion issue
Date 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 all the 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 new accounts 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.

Replies:

Posted By: bruce
Date Posted: 28 November 2004 at 11:07am

I'm still trying to work out my Access > SQL conversion issues. What I have found is that if I upsize my access db one table at a time and only create the table structure of the TBLthread and TBLtopic then I don't see the error and it works find. However once I import the data I start seeing the error above. It looks like it is only the tblthread table causing me problems. All the other tables imported with out issue.