Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-16 : 10:36:08
|
| Bobby Goluba writes "Hello, I have a question about an error I am getting when upsizing my Access Database back end to SQL Server 7.0. My server has the following configuration:Microsoft Windows 2000 Server, Service Pack 3SQL Server 7.0, Service Pack 4, OLAP Services Service Pack 3Microsoft Office 2000, Service Release 1When I attempt to upsize my database, the first four tables are upsized successfully, but the fifth table has the following error in a window that pops up called "Errors from Server": SQL that Caused Error(s): UT_CopyData Error(s): Server Error 0: Timeout ExpiredThe table that is having the error is very large, with 240972 records. I have tried to perform the upsizing after cutting the size of the table down to only 20000 records, and the error does not occur. I would like to know if there is a timeout parameter in SQL Server 7.0 that I can configure that would keep this timeout error from occuring while upsizing my database with the full table of 240972 records. I have already tried setting "remote login timeout" = 0 and "resource timeout" = 1000, but neither of these has helped. Thank you very much for any advice you can provide me!Take care!Bobby Goluba" |
|
|
bgoluba
Starting Member
1 Post |
Posted - 2002-09-19 : 14:16:16
|
| Hello Everyone,Microsoft sent me the following link to a Technet article that describes how to solve the timeout problem I was having with upsizing my Access 2000 database to SQL Server 7.0.[url]http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q295231&[/url]Take care!Bobby Goluba |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-09-19 : 15:56:54
|
| I've had luck using office xp but lots of problems with 97 or 2k. |
|
|
|
|
|
|
Error Upsizing an Access Database to SQL Server 7.0