SqlBulkCopy Error: Incorrect syntax near ','

[Lazar]

Hi there,

I am trying to use mono to import data into a Microsoft SQL Server from a Linux machine. The code is written in C# and makes use of the SqlBulkCopy class. The program runs just fine on a Windows platform, and there are no issues discovered when checked with the Mono Migration Analyzer. When the program is executed under mono (both versions 2.0.1 and 2.4.2 have been tried) on a machine running Ubuntu 9.04 it runs fine until it gets to the WriteToServer(DataTable) call, and then the following error is displayed:

Incorrect syntax near ','.
System.Data.SqlClient.SqlException: Incorrect syntax near ','.
  at System.Data.SqlClient.SqlConnection.ErrorHandler (System.Object sender, Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e) [0x00000]
  at Mono.Data.Tds.Protocol.Tds.OnTdsErrorMessage (Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e) [0x00000]
  at Mono.Data.Tds.Protocol.Tds.ProcessMessage (TdsPacketSubType subType) [0x00000]
  at Mono.Data.Tds.Protocol.Tds.ProcessSubPacket () [0x00000]
  at Mono.Data.Tds.Protocol.Tds.NextResult () [0x00000]
  at Mono.Data.Tds.Protocol.Tds.SkipToEnd () [0x00000]
  at Mono.Data.Tds.Protocol.Tds.ExecBulkCopyMetaData (Int32 timeout, Boolean wantResults) [0x00000]
  at Mono.Data.Tds.Protocol.TdsBulkCopy.SendColumnMetaData (System.String colMetaData) [0x00000]
  at System.Data.SqlClient.SqlBulkCopy.BulkCopyToServer (System.Data.DataTable table, DataRowState state) [0x00000]
  at System.Data.SqlClient.SqlBulkCopy.WriteToServer (System.Data.DataTable table) [0x00000]

Any help, suggestions will be very appreciated.

[Gonzalo Paniagua Javier-5]

On Tue, 2009-06-30 at 13:56 -0700, Lazar wrote:

> Hi there,
>
> I am trying to use mono to import data into a Microsoft SQL Server from a
> Linux machine. The code is written in C# and makes use of the SqlBulkCopy
> class. The program runs just fine on a Windows platform, and there are no
> issues discovered when checked with the Mono Migration Analyzer. When the
> program is executed under mono (both versions 2.0.1 and 2.4.2 have been
> tried) on a machine running Ubuntu 9.04 it runs fine until it gets to the
> WriteToServer(DataTable) call, and then the following error is displayed:
>
> Incorrect syntax near ','.
> System.Data.SqlClient.SqlException: Incorrect syntax near ','.
>   at System.Data.SqlClient.SqlConnection.ErrorHandler (System.Object sender,

We're going to need more information in order to debug this. Could you
provide a small program with the smallest statement possible that
reproduces the problem? If so -> http://mono-project.com/Bugzilla.

Thanks.

-Gonzalo


_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

[Lazar]

Gonzalo Paniagua Javier-5 wrote:

On Tue, 2009-06-30 at 13:56 -0700, Lazar wrote:
> Hi there,
>
> I am trying to use mono to import data into a Microsoft SQL Server from a
> Linux machine. The code is written in C# and makes use of the SqlBulkCopy
> class. The program runs just fine on a Windows platform, and there are no
> issues discovered when checked with the Mono Migration Analyzer. When the
> program is executed under mono (both versions 2.0.1 and 2.4.2 have been
> tried) on a machine running Ubuntu 9.04 it runs fine until it gets to the
> WriteToServer(DataTable) call, and then the following error is displayed:
>
> Incorrect syntax near ','.
> System.Data.SqlClient.SqlException: Incorrect syntax near ','.
>   at System.Data.SqlClient.SqlConnection.ErrorHandler (System.Object sender,

We're going to need more information in order to debug this. Could you
provide a small program with the smallest statement possible that
reproduces the problem? If so -> http://mono-project.com/Bugzilla.

Thanks.

-Gonzalo


_______________________________________________
Mono-list maillist  -  [e-mail]
http://lists.ximian.com/mailman/listinfo/mono-list

Program.cs

I have attached a simple program that exhibits the problem. It connects to a SQL Server that has a database with a table that has 3 columns - "timestep", "zindex", "data". Again, it works on machines running Windows, but not on Linux with mono or monodevelop for that matter.

Thank you,

Kalin

[Gonzalo Paniagua Javier-5]

> >
> >  http://www.nabble.com/file/p24364374/Program.cs Program.cs
>
> I have attached a simple program that exhibits the problem. It connects to a
> SQL Server that has a database with a table that has 3 columns - "timestep",
> "zindex", "data". Again, it works on machines running Windows, but not on
> Linux with mono or monodevelop for that matter.

I am able to reproduce the problem (types for the columns: int,
numeric(18,0) adn varbinary(MAX)). This is now being tracked as
https://bugzilla.novell.com/show_bug.cgi?id=519844.

-Gonzalo


_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list