README How to bulk copy without a format file (ODBC)
Updated: 17 July 2006
This sample shows how to bulk code without a format file. This sample is not supported on IA64.
For more information on this sample, see How to bulk copy without a format file (ODBC)
in Books Online.
This sample uses Visual C++.
Before running this sample, make sure the following software is installed:
- SQL Server 2005 or SQL Server 2005 Express Edition (SQL Server Express) including Database Engine. You can download SQL Server Express from this Microsoft
- The AdventureWorks database which is included with SQL Server 2005, and is also available at the SQL Server Developer
- The SQL Server 2005 Database Engine samples. These samples are included with SQL Server 2005. You can download the latest version of the samples at the SQL Server Developer
- .NET Framework SDK 2.0 or Microsoft Visual Studio 2005. You can obtain .NET Framework SDK free of charge. See
Installing the .NET Framework SDK.
- You will also need an ODBC data source called AdventureWorks, whose default database is the
AdventureWorks sample database.
Building the Sample
- This sample connects to your computer's default SQL Server instance. To connect to a named instance, change the definition of the ODBC data source to specify the instance using the following format:
server\namedinstance_. By default, SQL Server Express installs to a named instance.
- If you are using Visual Studio, load the BulkCopyNativeMode.sln file and build it.
- If you are using MSBuild.exe, invoke MSBuild.exe at a command prompt, passing it the BulkCopyNativeMode.sln file: * MSBuild BulkCopyNativeMode.sln *
Running the Sample
- From Visual Studio, invoke Start Without Debugging (CTRL+F5).
- If you built with MSBuild.exe, invoke BulkCopyNativeMode.exe.
|17 July 2006
||Changed content: Clarified and updated prerequisites including the Web site for downloading the samples. New content: Added information on connecting to a named instance.
© 2007 Microsoft Corporation. All rights reserved.