ODBC Bulk Insert - .NET Framework

Mike C#

Am looking for an ODBC SQLBulkOperations wrapper for VC++; in particular I
need to perform bulk Insert operations. Anyone know where I can find this?

Thanks

Apr 25 '06 #1

Subscribe Reply

3905

Mike C#

Never mind, problem solved, works great.

"Mike C#" <xx*@yyy.com> wrote in message news:SZ***************@fe12.lga...

Am looking for an ODBC SQLBulkOperations wrapper for VC++; in particular I
need to perform bulk Insert operations. Anyone know where I can find
this?

Thanks

May 15 '06 #2

how and what if you don't mind sharing?
"Mike C#" <xx*@yyy.com> wrote in message news:oh***************@fe09.lga...

Never mind, problem solved, works great.

"Mike C#" <xx*@yyy.com> wrote in message
news:SZ***************@fe12.lga...
Am looking for an ODBC SQLBulkOperations wrapper for VC++; in particular
I need to perform bulk Insert operations. Anyone know where I can find
this?

Thanks

May 16 '06 #3

Mike C#

I just extended the MFC CDatabase class with some methods that set ODBC API
BulkOperations parameters, some other methods that allow me to cache bulk
updates and inserts, etc.

"gs" <gs@dontMail.telus> wrote in message
news:uf**************@TK2MSFTNGP05.phx.gbl...

how and what if you don't mind sharing?
"Mike C#" <xx*@yyy.com> wrote in message
news:oh***************@fe09.lga...
Never mind, problem solved, works great.

"Mike C#" <xx*@yyy.com> wrote in message
news:SZ***************@fe12.lga...
Am looking for an ODBC SQLBulkOperations wrapper for VC++; in particular
I need to perform bulk Insert operations. Anyone know where I can find
this?

Thanks

May 17 '06 #4

Similar topics

1754

bulk execute procedure using odbc

by: Ye Liu | last post by:

Hi, Oracle Folks. May I know whether in ODBC programming, I can use bulk execution of a stored procedure just like bulk insert. Thanks, --ye

Oracle Database

4874

Bulk Insert Problems

by: me | last post by:

I'm also having problems getting the bulk insert to work. I don't know anything about it except what I've gleened from BOL but I'm not seeming to get anywhere...Hopefully there is some little (or...

Microsoft SQL Server

12079

Bulk insert into views that select from table on remote server

by: iqbal | last post by:

Hi all, We have an application through which we are bulk inserting rows into a view. The definition of the view is such that it selects columns from a table on a remote server. I have added the...

Microsoft SQL Server

2649

oledbprovider vs odbc provider ???

by: serge calderara | last post by:

Dear all, Does any one have any idea why an sql statment with INNER JOIN syntax is working well with odbcprovider but not with Oledbprovider when accessing an access 2000 database? here is...

.NET Framework

12334

Bulk Insert

by: pk | last post by:

Sorry for the piece-by-piece nature of this post, I moved it from a dormant group to this one and it was 3 separate posts in the other group. Anyway... I'm trying to bulk insert a text file of...

Microsoft SQL Server

16969

Bulk Insert / Update / Delete

by: Philip Boonzaaier | last post by:

I want to be able to generate SQL statements that will go through a list of data, effectively row by row, enquire on the database if this exists in the selected table- If it exists, then the colums...

PostgreSQL Database

2992

Bulk Insert with default value

by: ozkhillscovington | last post by:

We have sp's in place that do BULK INSERTS from txt files into the tables. This works fine, however they have asked us to add a field that identifies accounting ctr. The only thing that identifies...

Microsoft SQL Server

2076

rowdelimiter not accepted in bulk insert statement , used in an sproc - please help

by: rshivaraman | last post by:

BULK INSERT bill_tbl FROM 'd:\ftp_Data\in\baddress.dat' WITH ( FIELDTERMINATOR = ';', ROWTERMINATOR = '\n' ) --------------------------------- This is the query used to populate bill_tbl....

Microsoft SQL Server

3211

SQL Server 2005 native client ODBC query

by: vainstah | last post by:

Hello Guys, I am writing a high performance win32 telemetry midleware service which uploads to SQL server in bulk frequently. I know how to do simple things in ODBC native-client. ODBC...

Microsoft SQL Server

7027

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

6899

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7067

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6719

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

6847

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5312

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4757

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4463

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

2980

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration