I have been trying for over a year to move data from SQLBase to SQL Server
using DTS. Everything appears to work great until I click on the finish
button in the DTS wizard, then I get an error. When I double click the
error it says, "catastrophic error" follow by an error message "error during
initialization of the provider". While setting up the transfer in DTS I can
preview the SQL Base data and everthing appears fine. The new tables are
created in SQL Server--the error occurs at the time the data is to be
transferred. I have tried both Intersolv and Centura ODBC drivers. I am
using SQL 7 (SP3) on Windows 2000. Any suggestions would be appreciated.
Or, please tell me where I might go to pay a consultant. I have given up.