473,507 Members | 2,473 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 2005 : Is odbc bulkcopy available?

Hi,

I'm trying to find out if we can use bulkcopy via odbc in sql server 2005.
With sql server 200 we could use the odbcbcp.dll.
I can not find any info regarding this for ms sql server 2005.
Thanks,
Jos van der Velden
Aug 22 '05 #1
1 2186
Jos van der Velden (jo****************@por.sas.com) writes:
I'm trying to find out if we can use bulkcopy via odbc in sql server 2005.
With sql server 200 we could use the odbcbcp.dll.
I can not find any info regarding this for ms sql server 2005.


Yes you can. To get full support for SQL 2005 features, you should
use sqlncli.dll, SQL Native Client which is a DLL that includes both
a new ODBC driver and a new OLE DB provider.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Aug 22 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
22447
by: Michael Walton | last post by:
I am trying to write some code that inserts or updates a text field in my SQL Server 2000 database. The SQL statement is created using a submit from a form, and the text is coming from a...
0
4093
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed :...
1
10282
by: chloe.crowder | last post by:
Hi We're trying to use call a stored procedure to update information in a remote Ingres database. We've linked the server, and can read information using SELECT * FROM OPENQUERY (..........),...
20
37837
by: TC | last post by:
I need an automated procedure to copy data from an Access table to a SQL Server table. Speed is important. What is the recommended technique? I can export the data from Access, copy it via FTP,...
0
1268
by: utk1000 | last post by:
I used BulkCopy.dll(in C#) and getting this error: Line1.incorrect Syntax near '('
1
1492
by: Chuck | last post by:
Hi, I have installed a trial version of VC++ Express 2005 with the budled SQL Server. After creating a C++ Forms prototype, with some tables into a database file named Test1.mdb, now I want to make...
4
10900
by: upadhyayanuj | last post by:
Hi can anybody tell what is error in following code, its running through .Net 2005 editor fine, but when running on browser gives error: No error message available, result code: E_FAIL(0x80004005)....
1
1519
by: GinaM1 | last post by:
Hi All, I am working with a software package that logs messages via ODBC to a remote SQL Server 2005 Service Pack 2 database. The server OS is Server 2003 Service Pack 1. The software that we are...
5
10127
by: Annonymous Coward | last post by:
I am thinking of embedding SQL Server express ina (native) C++ application. I am looking for a C++ API for SQE, but cant seem to find one ... Is there a (ANSI) C++ API for making native calls to...
0
7221
marktang
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,...
0
7109
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...
0
7313
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7481
tracyyun
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...
1
5039
isladogs
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...
0
4702
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...
0
3190
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...
1
758
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
411
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.