Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - migration from accesss to SQL serv
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

migration from accesss to SQL serv

 Post Reply Post Reply Page  12>
Author
Lazaro View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Lazaro Quote  Post ReplyReply Direct Link To This Post Topic: migration from accesss to SQL serv
    Posted: 14 October 2003 at 3:33am

 

Hi I was runnigh WWF 7 Access version, and I've tryed updating to WWF 7.5 SQL server.

So I've migrated my old database access, and when i run my new SQL server forum all seems to go ok until I try to post a new message. The I get a quite strange error

ADODB.Recordset (0x800A0CB3)

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/forum/post_message.asp, line línea 746

I Don't know wich can be the error. Any Suggestions?

 

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2003 at 3:41am
The SQL server and access versions are slightly different, make sure that you have set the database type to SQL srever and have also created all the stoored procedures required for the SQL server version on teh SQL server.
Back to Top
Lazaro View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Lazaro Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2003 at 3:56am

I have done both things (I've also execite de MSsql_server_setup.asp)

I can browse th forum , but when trying to post it gives me this error.

I will try to convert my database again and will tell you

Thanks!

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2003 at 4:06am
Also try re-uploading the files again as you may have a corrupted file.
Back to Top
Lazaro View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Lazaro Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2003 at 4:34am

 

Thanks Borg I also had tryed this.

Now I have made some progress:

what i did was to migrate the database and then execute Mssql_server_setup.

Now. I have firstly executed the MSsql_server_setup and after this I migrated the database. It gave some errors, but Now I can post, but the problem is that the users were not migrated; so there are no users in the forum and i can not log in.

Any Idea of how to migrate users and to go trough the error!

Thanks again!

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2003 at 5:46am
Do a search of the forum to find how othere users have done this.
Back to Top
Lazaro View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Lazaro Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2003 at 6:53am

Thanks again Borg;

But I am not finding anything about this issue with the search function even when I have tryed it for several minutes! - maybe due to my bad english and my vocabulary limitations -

I will continue trying to find something about this issue; but meanwhile could someone give a link to the topic in wich this issue is solutioned - I swear you that I've tryed hard but i can't findit -

Thans a lot!

Back to Top
huwnet View Drop Down
Senior Member
Senior Member


Joined: 30 May 2003
Location: England
Status: Offline
Points: 1375
Post Options Post Options   Thanks (0) Thanks(0)   Quote huwnet Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2003 at 8:02am
Try going to the next page of posts. I know there are some about what you want there. One of them has a link about how to do it.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
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.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.