can anyone help ???
were trying to import from centura sqlbase 7.5 to ms-sql 7.0.
when importing via Data Transformation Service (DTS) the DTS connects first
via ODBC to SQLBASE and then via direct connect to a local MS-SQL Database.
Then DTS creates the first table selected without any problems. After that
the DTS seems to drop the odbc connection and no data can be transferred. If
selecting more than one table the dts hangs after creating the first table
and trying to create the second table.
Weve been trying this with the following ODBC Drivers:
Centura SQLBase 3.01 32-bit Driver -NT & Win95 Version 3.01.00.06 and
Centura SqlBase 3.5 32-bit Driver -NT & Win95 Version 3.50.00.000. Importing
from Datasources other than Centura via ODBC seems to work fine.Scince we
are willing to migrate our front end application to use both sql servers it
would be very important for us to fully import our existing database into
ms-sql. please help anyone !!!
thx in advance
Very firm in SQLBASE, Powerbuilder and fairly firm in MS-SQL.