SQL bulk copy for native clients causes access violation

c++ sqlbulkcopy sql-server

Question

I have a windows application that does a bulk copy of data to an SQL table, using the bcp_xxx() functions and a standard "SQL Server" ODBC connector.

I want to move to supporting native SQL client connections

According to what I have seen, all I need to do is add

#define _SQLNCLI_ODBC_
#include <sqlncli.h>

to the top of the cpp file, and link against "sqlncli10.lib" rather than "odbcbcp.lib."

However, when I call bcp_bind(), I get "Access violation reading location 0xffffffffffffffff" This happens with both "SQL server" and "SQL Native Client" ODBC connections.

The code being executed is:

SQLHANDLE hEnv;
SQLHANDLE hConnection;
LPCBYTE data = (LPCBYTE)malloc(100);

SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hEnv);
SQLSetEnvAttr(hEnv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER);
SQLAllocHandle(SQL_HANDLE_DBC, hEnv, &hConnection);
SQLSetConnectAttr(hConnection, SQL_COPT_SS_BCP, (void *)SQL_BCP_ON, SQL_IS_INTEGER) ;
SQLConnect(hConnection, "DSN", SQL_NTSL, NULL, 0, NULL, 0);
bcp_init(hConnection, "DB_TABLE", NULL, NULL, DB_IN);
bcp_bind(hConnection, data, 0, SQL_VARLEN_DATA, (LPCBYTE)"", 1, SQLCHARACTER, 1);
1
0
1/21/2016 1:47:34 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The problem appears to be due to using "SQL server" ODBC connections at the same time as the bulk copy routines are trying to use native connections.

If I change all other ODBC connections to be SQL Native, the bulk copy routines work correctly.

0
1/21/2016 5:30:36 PM

Related Questions

Is it possible to transfer data across servers using sql bulk copy?

Yes. In fact, in the demo code shown ...here..., they copy to a table within the same database.
sql sqlbulkcopy sql-server
asked by Joe Stefanelli

SqlBulkCopy import causes primary key violations in SQL Server

If you really, really know that the dupes aren't needed, just set the "Ignore Dupes" option on the index for the PK and you're done.
c# sqlbulkcopy sql-server
asked by Jeff Moden

ASP.Net to MS-Access 2007 conversion (Bulk Insert, Bulk Copy)

Access 2007 will directly import XML. You can create an XSD for your particular data, then import that to create the table definitions. The XML should cleanly import from there.
asp.net sqlbulkcopy vb.net xml
asked by Karelzarath

SQL Bulk Copy to SQL Server with Data Modifications in Excel

This works fine for me:... public ActionResult Create(HttpPostedFileBase file) { string strConnection = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; //file upload path var fileName = Path.GetFileName(file.FileName); // store the file inside ~/App_Data/uploads folder var pat...
excel sqlbulkcopy sql-server
asked by Vegeta_77

Splitting a huge table into two and bulk copying using SQL Server and C#.net

I would create it in one table and create well defined indexes. ...Consider a filter index for the flag column. This is done with a where clause in t-sql and the filter page in ssms. ...http://msdn.microsoft.com/en-us/library/cc280372.aspx
.net c# sqlbulkcopy sql-server-2008
asked by Russell Hart

Access double to SQL decimal using SQL Bulk Copy

Your problem is that floating-point types like ...Double... often cannot store numbers ...exactly..., even values which seem to be quite "simple" numbers to us humans. This can be demonstrated by typing the following into the Immediate Window of the VBA editor in Access:...?(CDbl(81.60) * CDbl(100)) - CDbl(8160) ...The result returned is...-5.6843...
ms-access sql sqlbulkcopy vb.net
asked by Gord Thompson

Missing Data after insert into my end sql table using Sql Bulk Copy

you need to look at the data in Access, and find/fix those bad column values, or handle them in your TSQL after the export. One option to debug - replace temp table with real table, replace datetime datatype with string, do your export, then query the table to find the bad values so you know what kind of data to look for. After that, you can swit...
c# console-application datatable sqlbulkcopy sql-server-2008
asked by Greg

Bind default value if excel sheet column value null in sql bulk copy upload

Your problem must be that the column allows NULLS....In case your column allows NULL and you provide a NULL value on the insert the NULL ...WILL... be inserted. If no value is provided for the column the DEFAULT will be considered....Setup your column to NOT NULL....ALTER TABLE [dbo].[tbl_HEI_student] ALTER COLUMN [Date_of_Birth] DATE NOT NULL ...H...
asp.net asp.net-mvc-4 c# sqlbulkcopy sql-server
asked by mxix

Using SQL Bulk Copy to insert ~3.7 million rows throws OutOfMemory exception

Thank you all for your response....I figured out what was the problem. Firstly, it didn't occur when calling the SQL Bulk Copy, which I assumed it could have been because, in previous run, I was able to run few 1000 less records than the current one, so I thought the SQL Bulk Copy had limitations or need to settings in order to handle large number ...
c# sqlbulkcopy sql-server
asked by superachu

How to specify foreign keys between two DataTables in SQL Bulk Copy operation?

I would not use the identity to link the two tables, rather, I would use a GUID to link them. Like this :...var a= new DataTable("A"); DataColumn guid= new DataColumn("Guid", typeof(Guid)); billable.Columns.Add(Guid.NewGuid()); DataColumn id= new DataColumn("Id", typeof(int)); billablePriceMapId.AutoIncrement = true; billable.Columns.Add(id); Da...
asp.net c# datatable sqlbulkcopy
asked by WynDiesel

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow