Access to MS SQL

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
GeorgeB Members Profile Find Members Posts Newbie Joined: 31 May 2005 Location: Turkey Status: Offline Points: 9	Post Options Post Reply Quote GeorgeB Report Post Thanks(0) Quote Reply Topic: Access to MS SQL Posted: 01 March 2006 at 2:50pm
	Hi, I'm updating my access db to ms sql db. I'm receiving this error, when i want to post a new message. ADODB.Recordset error '800a0cb3' Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /forum_/post_message.asp, line 608 Thank you.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 01 March 2006 at 3:10pm
	This can happen if the migration process has not happened correctly.

GeorgeB Members Profile Find Members Posts Newbie Joined: 31 May 2005 Location: Turkey Status: Offline Points: 9	Post Options Post Reply Quote GeorgeB Report Post Thanks(0) Quote Reply Posted: 07 March 2006 at 1:28pm
	Thank you -boRg-. I converted with access upsizing wizard. Now, i can post a message without any error. But , i can not enter admin panel. It forwards me to insufficient_permission.asp Thank you.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 07 March 2006 at 2:32pm
	Make sure that the common.asp file in the admin area is pointing to the new database and that your browser and site can use session variables.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.