Web Development

Have you tried importing the schema and data using SQL Server 7's DTS Import Wizard?

If so, what error messages (if any?) are you getting.

The general description of the errors you got are familiar, one avenue to explore is to check that full permissions for your NT 'user' are available on the Sybase/SunSparc end, as this type of error has cropped up when I've worked with, for example, AS/400 permissions.

I've recently done a Sybase 11.5 to SQL Server 7 transfer with no problems.

Get in touch and we'll sort this one out together.

Anna Trevitt
Consultant, ADS

If the answer no.1 doesn't provide the right solution then you could consider the following:
1. Every SQL server has (as you pointed) some DLL's for the client server part. Did you get the latest ones?
2. If you did and you still cannot do your job, then you could consider some other tools for importing (ODBC is a Microsoft solution and relies heavily on UNICODE strings which for some UNIX'es is foreign language), like JDBC or BDE (Borland database engine).
3. The latest and the greatest,you could transform your database into CSV files and transport them to your MSSQL server and import them from those files.

The number 3 is really a Golgota so probably you should look into 1 and 2.

Luck!

This question was auto closed due to inactivity