I have a ASP.NET c# code to implement a bulk copy from MSSQL SERVER to SYBASE (12.5) using ASE client 4, but at the WriteToServer() function i always get the error " Incorrect syntax near ','". NOTE: i have even changed the DestinationTableName to a table that does not exist, but i still get the same error. previous to this error i was getting 'stored procedure sp_oledb_columns not found', which after searching the web got the procedure from "http://www.sqlbrowser.com/wikiHTML/sqlbhtml/sybsystemprocs/sp_oledb_columns.html" and ran the procedure against "sybsystemprocs" and every since then the subject error came. can ASE 12.5 actually do a bulkcopy or is there another means to carry out this operation.

asked 21 Jun '16, 11:57

chikodi's gravatar image

chikodi
1011
accept rate: 0%

edited 21 Jun '16, 12:26

Mark%20Culp's gravatar image

Mark Culp
22.6k9129265

The question has been closed for the following reason "Question is off-topic or not relevant" by Mark Culp 21 Jun '16, 12:24


This forum is for questions about SQL Anywhere. You need to ask your question on the ASE forum. See the FAQ.

permanent link

answered 21 Jun '16, 12:24

Mark%20Culp's gravatar image

Mark Culp
22.6k9129265
accept rate: 40%

edited 21 Jun '16, 12:25

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×48
×4

question asked: 21 Jun '16, 11:57

question was seen: 233 times

last updated: 21 Jun '16, 12:26