SqlException: SqlBulkCopy.WriteToServer() - 08-30-2006 , 04:12 PM
Using SqlBulkCopy.WriteToServer to upload a datatable and getting:
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?
Re: SqlException: SqlBulkCopy.WriteToServer() - 09-04-2006 , 01:24 PM
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
On Wed, 30 Aug 2006 16:12:00 -0400, "harleedavidson"
<harleedavidson (AT) nospam (DOT) nospam> wrote:
|Thread Tools||Search this Thread|