Web Wiz Support and Community Forums : Access to SQL Import problems https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 10:11:13 +0000 Mon, 25 Oct 2004 18:55:46 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8150 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access to SQL Import problems : What a nightmare, I&#039;m going...]]> https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68223.html#68223 Author: steve
Subject: 8150
Posted: 25 October 2004 at 6:55pm

What a nightmare, I'm going back and forth with the host still ongetting all of my permissions set right.  I can basically doanything but write to the database now (no posting or registrations),but I've noticed it's gotten very very slow.  I have a 36 MBDatabase with 20,000 posts approx 500 users and 20-30 concurrent mostof the time.   My page loads on Access were usually 1 secondor under, now when using the MS SQL db it's over 6 seconds.  My dblog file is close to 60 megs (bringing my db size up to almost 100mb).  Is that normal?

Every part of it is much much slower.  I'm hosted with JodoHostand it is still not totally functioning correctly, so I'm giving it thebenefit of the doubt until it's totally working.

Any advice other than going back to Access?
]]> Mon, 25 Oct 2004 18:55:46 +0000 https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68223.html#68223 <![CDATA[Access to SQL Import problems : All you should need to do is upsize...]]> https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68138.html#68138 Author: WebWiz-Bruce
Subject: 8150
Posted: 23 October 2004 at 5:19pm

All you should need to do is upsize the Access database making sure all the default values etc. are moved across.

Then run the MS SQL server setup file, ignoring the errors about tablesetc. as they are already created. This will then create the storedprocedures for you on the SQL Server.

The only problem you may encounter is that the setup file will put indefault values, like extra admin and guest accounts etc. which you willneed to remove.

You could try editing the MS SQL Server setup file to remove all theparts that create the tables etc. and just leave in the part thatcreates the stored procedures.
]]> Sat, 23 Oct 2004 17:19:59 +0000 https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68138.html#68138 <![CDATA[Access to SQL Import problems : I&#039;ve been going back and...]]> https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68134.html#68134 Author: steve
Subject: 8150
Posted: 23 October 2004 at 5:06pm

I've been going back and forth with them and they tell me the problemshould be corrected with the MS SQL manager and when I go in to try,it's not.  

I'll just have to start forwarding my error messages to them and see ifthey can fix it manually.  It's frustrating not having the toolsto do this myself...

Here's a question I'd be surprised if you could answer, but do you haveany ideas on what setting should be changed from an access to SQLconversion with JodoHost?  I don't want to go through a 12-24 hourwaiting period with each error if I can help it.

Thanks Borg.
]]> Sat, 23 Oct 2004 17:06:02 +0000 https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68134.html#68134 <![CDATA[Access to SQL Import problems : If you are using Jodohost you...]]> https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68126.html#68126 Author: WebWiz-Bruce
Subject: 8150
Posted: 23 October 2004 at 2:26pm

If you are using Jodohost you may need to get tech support to changesomeof the permissions on the server to be able to run Web Wiz Forums.]]> Sat, 23 Oct 2004 14:26:51 +0000 https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68126.html#68126 <![CDATA[Access to SQL Import problems : I&#039;m in the same boat as you...]]> https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68080.html#68080 Author: steve
Subject: 8150
Posted: 22 October 2004 at 10:09pm

I'm in the same boat as you right now Joey.  I'm guessing you'reon Jodohost.  The conversion part isn't too tough, but the MS SQLManager they give you doesn't seem to function properly.  I sentin a ticket to see if they can correct it. 

I'm getting errors like these:

Microsoft OLE DB Provider for SQL Server error '80040e09'

EXECUTE permission denied on object 'wwfSpChkUserID', database 'xyz_db', owner 'dbo'.

/mypathtoforum/common.asp, line 499


]]> Fri, 22 Oct 2004 22:09:35 +0000 https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post68080.html#68080 <![CDATA[Access to SQL Import problems : Nobody can help me with this?...]]> https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post41950.html#41950 Author: Joey805
Subject: 8150
Posted: 17 December 2003 at 4:16pm

Nobody can help me with this? Is there at least a post or guide I can follow to upgrade from access to SQL? There has got to me some documentation somewhere. ]]> Wed, 17 Dec 2003 16:16:38 +0000 https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post41950.html#41950 <![CDATA[Access to SQL Import problems : OK I was able to get a little...]]> https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post41789.html#41789 Author: Joey805
Subject: 8150
Posted: 16 December 2003 at 10:48pm

OK I was able to get a little farther now. I tired using an older version of acccess rather than than the one that came with office 2003. I got it to go through the upsizing wizard. I guess what Im needing now are some steps in what order to do this in. I cant seem to find any writeups on this. These are the things I have tried.

1) manually creating the DB in SQL, and then running msSQL_server_setup.asp, the upsizing using access into this database. I get an error report that 4 tables did not upsize.

2) let the upsizing wizard create its own DB and successfully upsize all the data, then I try to log into it and I get an internal servel error. I then run msSQL_server_setup.asp and get several other errors. Then I am able to log into the DB and everything seems to be running fine. At this point in time, is everything working or should I worry about all the errors generated by msSQL_server_setup.asp such as the following:

 
Error Creating the Table tblCategory (it may already exsist)

Error Creating the Table tblForum (it may already exsist)

Error Creating the Table tblTopic (it may already exsist)

Error Creating the Table tblThread (it may already exsist)

Error Creating the Table tblAuthor (it may already exsist)

Error Creating the Table tblPMMessage (it may already exsist)

Error Creating the Table tblBuddyList (it may already exsist)

Error Creating the Table tblActiveUser (it may already exsist)

Error Creating the Table tblConfiguration (it may already exsist)

Error Creating the Table tblDateTimeFormat (it may already exsist)

Error Creating the Table tblGroup (it may already exsist)

Error Creating the Table tblPoll (it may already exsist)

Error Creating the Table tblPollChoice (it may already exsist)

Error Creating the Table tblEmailNotify (it may already exsist)

Error Creating the Table tblPermissions (it may already exsist)

Error Creating the Table tblGuestName (it may already exsist)

Error Creating the Table tblSmut (it may already exsist)

Error Creating the Table tblBanList (it may already exsist)

Error Creating one or more Indexs (it may already exsist)

Error Creating the Relationship between the tblAuthor and tblGroup tables (it may already exsist)

Error Creating the Relationship between the tblForum and tblCategory tables (it may already exsist)

Error Creating the Relationship between the tblPollChoice and tblPoll tables (it may already exsist)

Error Creating the Relationship between the tblBuddyList and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblEmailNotify and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblPMMessage and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblPermissions and tblForum tables (it may already exsist)

Error Creating the Relationship between the tblTopic and tblForum tables (it may already exsist)

Error Creating the Relationship between the tblGuestName and tblThread tables (it may already exsist)

Error Creating the Relationship between the tblThread, tblTopic and tblAuthor tables (it may already exsist)

Error entering default values in the Table tblAuthor

Error entering default values in the Table tblDateTimeFormat

Error Creating the Stored Procedure wwfSpSelectConfiguration (it may already exsist)

Error Creating the Stored Procedure wwfSpChkUserID (it may already exsist)

Error Creating the Stored Procedure wwfSpCategoryAll (it may already exsist)

Error Creating the Stored Procedure wwfSpForumsAllWhereCatIs (it may already exsist)

Error Creating the Stored Procedure wwfSpForumTopicCount (it may already exsist)

Error Creating the Stored Procedure wwfSpLastForumPostEntry (it may already exsist)

Error Creating the Stored Procedure wwfSpModeratorGroup (it may already exsist)

Error Creating the Stored Procedure wwfSpModeratorGroup (it may already exsist)

If someone would just walk me through the steps so I can get around these errors, that would be great.

 

Thanks,

Joey



Error Creating the Stored Procedure wwfSpForumPermissions (it may already exsist)

Error Creating the Stored Procedure wwfSpForumThreadCount (it may already exsist)

Error Creating the Stored Procedure wwfSpUpdateLasVisit (it may already exsist)

Error Creating the Stored Procedure wwfSpAuthorDesc (it may already exsist)

Error Creating the Stored Procedure wwfSpTimeAndDateSettings (it may already exsist)

Error Creating the Stored Procedure wwfSpCountOfPMs (it may already exsist)

Error Creating the Stored Procedure wwfSpDateOfLastUnReadPM (it may already exsist)

Error Creating the Stored Procedure wwfSpActiveUsersWhereIPis (it may already exsist)

Error Creating the Stored Procedure wwfSpAddNewActiveUser (it may already exsist)

Error Creating the Stored Procedure wwfSpUpdateActiveUser (it may already exsist)

Error Creating the Stored Procedure wwfSpDeleteActiveUser (it may already exsist)

Error Creating the Stored Procedure wwfSpDeleteActiveUserDoubleEntry (it may already exsist)

Error Creating the Stored Procedure wwfSpDeleteActiveUserDoubleEntry (it may already exsist)

Error Creating the Stored Procedure wwfSpUpdateViewPostCount (it may already exsist)

Error Creating the Stored Procedure wwfSpForumsAllWhereForumIs (it may already exsist)

Error Creating the Stored Procedure wwfSpTopicDetialsInTheLastXX (it may already exsist)

Error Creating the Stored Procedure wwfSpTopicDetialsAll (it may already exsist)

Error Creating the Stored Procedure wwfSpThreadDetails (it may already exsist)

Error Creating the Stored Procedure wwfSpPollDetails (it may already exsist)

Error Creating the Stored Procedure wwfSpAuthorLastPostDate (it may already exsist)

Error Creating the Stored Procedure wwfSpCountOfActiveUsers (it may already exsist)

Error Creating the Stored Procedure wwfSpCountOfActiveGuests (it may already exsist)

Error Creating the Stored Procedure wwfSpActiveToipcs (it may already exsist)

Error Creating the Stored Procedure wwfSpTopicEmailNotify (it may already exsist)

Error Creating the Stored Procedure wwfSpForumEmailNotify (it may already exsist)

Error Creating the Stored Procedure wwfSpBannedIPs (it may already exsist)

Error Creating the Stored Procedure wwfSpAuthorDetails (it may already exsist)

Error Creating the Stored Procedure wwfSpAuthorLastPostDate (it may already exsist)

Error Creating the Stored Procedure wwfSpDBinfo (it may already exsist)

SQL Server database is set up, but with Error!

]]> Tue, 16 Dec 2003 22:48:31 +0000 https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post41789.html#41789 <![CDATA[Access to SQL Import problems : I read alot of post about upsizing...]]> https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post41779.html#41779 Author: Joey805
Subject: 8150
Posted: 16 December 2003 at 8:15pm

I read alot of post about upsizing from Access to SQL so I decided to create a test server and give it a shot. After I get everything set up, I open the Access file and try to run the upsizing wizard. I get an error that says "Object variable or With block variable not set" so that ends the day there. I next try and do it through the import process within SQL. I run msSQL_server_setup.asp and it creates the tables and sets everything up. I am now able to get into the forum and navigate/post ect. Now I try and import the data using Import. I select all the tables and it starts its process. The final result being 7 tables successful and 11 failed. I figured because the tables may already be there. With that import I am able to get into the forum and see my data but there are alot of things missing like permissions and such. Overall, it did not import correctly so I try again, this time I dont run msSQL_server_setup.asp. Everything imported successfully this time. However the forum is locked and I cannot unlock it.

Can I get some help here. I did some searching first and did not find my answers.

I appreciate your help,

Joey

]]> Tue, 16 Dec 2003 20:15:37 +0000 https://forums.webwiz.net/access-to-sql-import-problems_topic8150_post41779.html#41779