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

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