Web Wiz Support and Community Forums : SQL Server problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 03:28:31 +0000 Wed, 25 May 2005 16:22:01 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15188 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server problem : hi, just seen your message well...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83910.html#83910 Author: dj air
Subject: 15188
Posted: 25 May 2005 at 4:22pm

hi, just seen your message

well i couldn't do the upsize to my server then tranfer to yours.
so i used the access database and made a dns for it.

then tranferred the tables one by one into a fresh copy that icreated.. so i imported the data from the access database into thetables of a bklank WWF SQL database (default set up).. and importedthoser records.

it all seems ok now
]]> Wed, 25 May 2005 16:22:01 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83910.html#83910 <![CDATA[SQL Server problem : upgrade is complete all details...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83909.html#83909 Author: dj air
Subject: 15188
Posted: 25 May 2005 at 4:20pm

upgrade is complete all details are tranferred and ive tested a new user and posted a new topic.

you can delete both the topic and aaron test user account.
]]> Wed, 25 May 2005 16:20:19 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83909.html#83909 <![CDATA[SQL Server problem : It seems like it&#039;s working....]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83908.html#83908 Author: imhotep
Subject: 15188
Posted: 25 May 2005 at 4:19pm

It seems like it's working. What exactly did you do? ]]> Wed, 25 May 2005 16:19:21 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83908.html#83908 <![CDATA[SQL Server problem : the all tables are over apart...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83904.html#83904 Author: dj air
Subject: 15188
Posted: 25 May 2005 at 3:47pm

the all tables are over apart from the poll, poll  choice and threads table . which is doing now.

i had a few problems but nothing major, i think it is almost done
]]> Wed, 25 May 2005 15:47:17 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83904.html#83904 <![CDATA[SQL Server problem : hi, right we have had a few problems...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83899.html#83899 Author: dj air
Subject: 15188
Posted: 25 May 2005 at 2:30pm

hi, right we have had a few problems but i think they are beingtranferred ok now.. i give a ETA of about 1/2 - 1 hour, ill reply whenfinished]]> Wed, 25 May 2005 14:30:32 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83899.html#83899 <![CDATA[SQL Server problem : i have nearly downoaded the database...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83894.html#83894 Author: dj air
Subject: 15188
Posted: 25 May 2005 at 1:27pm

i have nearly downoaded the database was interupted when i left it so is going to take a couple minutes.

then i will upsize the database to my local then tranfer to yours

]]> Wed, 25 May 2005 13:27:55 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83894.html#83894 <![CDATA[SQL Server problem : ive removed your details to stop...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83881.html#83881 Author: imhotep
Subject: 15188
Posted: 25 May 2005 at 11:14am

ive removed your details to stop spammers/ spiders.. ill do the up grade soon.. and ill send you an email when its done


Edited by dj air - 25 May 2005 at 12:20pm]]> Wed, 25 May 2005 11:14:39 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83881.html#83881 <![CDATA[SQL Server problem : contact me over MSN, and ill see...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83876.html#83876 Author: dj air
Subject: 15188
Posted: 25 May 2005 at 10:10am

contact me over MSN, and ill see what i can do. my MSN is in my proflei]]> Wed, 25 May 2005 10:10:17 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83876.html#83876 <![CDATA[SQL Server problem : A few things Trying to restore...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83874.html#83874 Author: imhotep
Subject: 15188
Posted: 25 May 2005 at 10:01am

A few things
 
  • Trying to restore the database is a no go. Says I don't have permissions to do so
  • I have upsized to a local server and am trying to transfer to the host.
  • The first table transfers over fine, but when I get to the "forum" table, I get the following error -
 
"Error for Destination row number 27. Errors encountered so far for this task: 1
 
String data length mismatch
[DBNETLIB][ConnectionRead (send()).] General network error. Check your network documentation"
 
If I was to give you the access database, would you be able to see if there is something wrong with it? Also if I set up something on my host's SQL Server for you to look at, would you be able to determine anything from that? I don't know what the problem is and I am following your advice verbatum.
]]> Wed, 25 May 2005 10:01:18 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83874.html#83874 <![CDATA[SQL Server problem : ok , do the following upsize...]]> https://forums.webwiz.net/sql-server-problem_topic15188_post83866.html#83866 Author: dj air
Subject: 15188
Posted: 25 May 2005 at 7:42am

ok ,

do the following

upsize the access Database to a SQL server ( you can try upsizing to the actual host ).

and see if that works.

OR if you have a local server try upsizing to that.

OR if you have a local server and a remote server upsize to your localserver then take a .bak file (back up) and restore on the remote server(web server)

or you can try a tranfer from one server to another by creating adefault version on the remote server (web server ) then import fromyour local server in the below order,

bring in part in brackets is what type of tranfer to do on the new server, bring in these one at a time

- category table (ammend table settings)
- forums (amend)
-  Author table (delete existing details)
- Prviate message table (amend)
- Topics (amend)
- threads (amend)
- Poll(amend)
- PollChoices (amend)
- EmailNotify(amend)

and then bring in the other tables apart from the configuration and time settings tbles as they can be configured

also when you select the tables to import make sure (MAKE SURE) that the 2nd to last [] is dbo

so you have the first part then on the end it needs top be [dbo][table name]

table name is the name of the table you are tranfrring (this part is on the section after selecting import tables and views.

select the tables 1 by 1 in the above order making sure about the dbo then run the tranfer.


]]> Wed, 25 May 2005 07:42:50 +0000 https://forums.webwiz.net/sql-server-problem_topic15188_post83866.html#83866