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-03-11 : 00:39:27
|
| john writes "I've been having a major problem with SQL Server 7's (desktop edition) DTS (importing) facility. In my 1st few weeks of trying to make use of the DTS import, i couldn't get past the 'FINISH' button. The system simply hangs as soon as i press that button. Does it have anything to do with the fact that the database that i'm trying to import is an Access 2000 database?Anyway, A few weeks after, i was able to succesfuly import Access 2000 databases. That would've put to rest that problem DESPITE THE FACT THAT I NEVER KNEW WHAT CAUSED THE PROBLEM IN THE FIRST PLACE.However, recently, we just aquired a Pentium4 unit and out of curiosity, i decided to try installing SQL Server7 (desktop edition). Once again, i tried to import an Access 2000 database. And just like before, i couldn't get past the FINISH button. " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-11 : 08:41:45
|
| Try installing Service Pack 3 on your SQL Server installations. Also try installing the latest MDAC components, you can get them here:http://www.microsoft.com/data/download.htmGet either MDAC 2.6 SP1 or MDAC 2.7 if you're running WinXP. This updates all of the drivers and will most likely solve the problem. |
 |
|
|
|
|
|
DTS import system hang