|
Home > Archive > Microsoft SQL Server forum > August 2005 > SQL Server 2005 : Is odbc bulkcopy available?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2005 : Is odbc bulkcopy available?
|
|
| Jos van der Velden 2005-08-22, 11:23 am |
| 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
| |
| Erland Sommarskog 2005-08-22, 8:23 pm |
| Jos van der Velden (jos.van.der.velden@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, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
|
|
|
|
|