| Author |
 Topic Search  Topic Options
|
ask023 
Groupie
Joined: 16 February 2003
Status: Offline
Points: 130
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Access DB -> SQL DB...Please help me!
Posted: 05 August 2003 at 1:09am |
Hello, All!
Recenly I migrated v7.01 Access DB (2002) into MS SQL 2000 SP3 using Access XP Upsize Wizard. Also I prepared user who have "owner" rights on SQL DB. I used all default options during UPSIZE process...
Next, I try to load my board via WEB and see the error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Could not find stored procedure 'wwfSpSelectConfiguration'.
/board2/common.asp, line 247
I double checked that I have permissions to SQL DB...Moreover, if I create new DB through msSQL_server_setup.asp - all work fine.
I found at this forum that I "need to run the sql server setup file in the sql server version as you need to create the stored procedures on the sql server". I run msSQL_server_setup.asp and see a lot of errors, but my board start work!!
Could you tell me please, is it normal way to migrate Access->SQL? Should I skip all errors when msSQL_server_setup.asp work?
Thank you in advance!
Best wishes,
Sergey
Edited by ask023
|
 |
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 August 2003 at 1:41am |
|
The sql setup file creates all the tables as well as the stored procedures. The errors that you got were probably the creation of the tables because you didn't say anything about deleting the upsized tables.
If the forums are working correctly then don't sweat it.
|
|
|
|
ask023
Groupie
Joined: 16 February 2003
Status: Offline
Points: 130
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 August 2003 at 1:52am |
Thank you! Yes, I didn't say anything about deleting the upsized tables...
Could you tell me please, should I set such parameters or msSQL_server_setup.asp will process already existed DB correctly (with some "normal" error messages)?
|
|
ask023
Groupie
Joined: 16 February 2003
Status: Offline
Points: 130
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 August 2003 at 6:02am |
Dear All!
Does anyone run msSQL_server_setup.asp after UPSIZE WIZARD? Should I change something in this asp to prepare just migrated DB?
Thank you!!
|
|
Takhir
Newbie
Joined: 01 March 2003
Location: Belgium
Status: Offline
Points: 26
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 August 2003 at 7:11am |
- msSQL_server_setup.asp
- alter all tables
- Enterprise Manager DTS
|
|
ask023
Groupie
Joined: 16 February 2003
Status: Offline
Points: 130
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 August 2003 at 9:48am |
Thank you!
Could you tell me please, what I need to alter all tables ?
If I use commands like DELETE FROM or TRUNCATE TABLE for all tables, I got several errors in DTS import - something about "Violation of PRIMARY KEY constraint...Cannot insert duplicate key in object "tblDateTimeFormat" etc
Thank you in advance!
|
|
ask023
Groupie
Joined: 16 February 2003
Status: Offline
Points: 130
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 August 2003 at 10:27am |
Dear All,
Just found Bruce recommendations about Access->SQL conversion:
http://forums.webwiz.net/forum_posts.asp?TID=580&KW=upsize
One small question - is it normal to see a lot of errors (about existed DBs) when we "run the SQL server setup file to create stored procedures on the SQL server"? Can we relay on such method?
Thank you!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 August 2003 at 10:34am |
It will show errors if the tables already exsist.
Maybe another way if you are worried about the errors is to first run the SQL setup script, then delete all the forum tables in the database, then run the upsize wizard. That way you don't have to worry about the error messages that say, 'either an error or the table already exsist'
|
|
|
|
