SQL Server problem

Post Reply

Page <123 4 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 7:05pm
	i have tried from XP before and i think there was a bug because i could never get it to work from XP (Access XP trhat is).. but have with 2003 you need to upsize to one server then it shouold be ok .. if its inhouse.. if you upsize the hosting computer. else you may have to upsize to one computer then the other... i think you can just send table by table creating as you go. one thing actually to check is what the table owner will be of the new tranferred tables.. within DTS check the tranform button and see what the desitnation Creator is ,, it should be DBO.. or what ever you are logged in as. DBo is best

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 11:30pm
	Everytime I try to import each table individually, I get this screen Error Source: Microsoft OLE DB Provider for SQL Server Error Description: Unspecified Error Connection failure Context: Error Calling GetRowSet to get DBSCHEMA_PROVIDER_TYPES schema info. Your provider does not support all the schema rowsets rewuired by DTS **************************** The only way i can get the information into the database is to choose the option "Copy objects and data between SQL Servers." If I try the first option, "Copy tables and views from the source database," I get connection errors like the one above and only 1 to 3 tables will create in the database. I can't choose which tables to upload first. I have to do them all at once in order to get them up there. But we are back at the same problem I had at the beginning, I can't update tables. What am I doing wrong?
	Man Know Thyself

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 23 May 2005 at 12:26am
	I forgot to mention also that when I finish uploading contents using the third method mentioned earlier, it gives me this message: "Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server" What objects weren't carried over? How can this be resolved?
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 23 May 2005 at 6:09am
	after upsizing the database, i then think i used the third option. after selecting the 3rd option i am presented with a list of tables within the copy from SQL DB, you should be able to select/deselect what ones are sent. and also edit the destination details.. like the db owner. the send them one by one in the order on the other page., the error i was getting when tranferring from one SQL server to another was about the threads table, you need to make sure all tables are owned by DBO, and that the threads table ise sent after the topics table. its because of the FAK's

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 24 May 2005 at 6:55pm
	I am getting this error message when trying to upload the tblThreads table from SQL Server to SQL Server Error for Destination row number 1. Errors encountered so far for this task: 1 String data length mismatch [DBNETLIB][Connection write (send()).] General network error. Check your network documentation Any ideas of what could be the problem? I actually installed Office 2003 this time and applied all updates.
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 24 May 2005 at 7:09pm
	look at my last post within the main thread on upsizing, i give a description on the process using Access 2003 and 2 SQL server and with just oine, that error ussually means that it was taking to long to send the data over.if you can the best way by the looks of it is to take a .bak from the old server and restore it on the new server.

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 24 May 2005 at 11:38pm
	I have tried every method suggested to me and I still can't update any tables. Is is something in the relationships or something that is being changed? I don't know enough to recognize any changes but I am still getting this message: ADODB.Recordset error '800a0cb3' Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /forum2/forum/post_message.asp, line 746 Why isn't this working. I will give my database up to see if someone else has the same problem with the database.
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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 local server 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 a default version on the remote server (web server ) then import from your 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.

Post Reply	Page <123 4 >

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