Using SqlBulkCopy.WriteToServer to upload a datatable and getting:

System.Data.SqlClient.SqlException
Line 1: Incorrect syntax near 'COLLATE'.

Database Server is SQL2000, database in in 6.5 compatibility mode.

No error when targeting SQL2000 database in 8.0 compatibility mode.

Is this specific to 6.5 and is there a workaround?

thanks,
scott

I'm afraid there's no workaround. SqlClient is not supported for SQLS
6.5. SQL Server was completely rewritten from the ground up for SQLS
7.0, so you'll need to upgrade to at least that version to get basic
functionality.

--Mary

On Wed, 30 Aug 2006 16:12:00 -0400, "harleedavidson"
<harleedavidson (AT) nospam (DOT) nospam> wrote: