Hi, In asp.Net 2.0 professional, in chapter 12 listing 6 we introduced tranaction
I have difficulty to see where the error is
I apprechiate help.

This is the error message:
ExecuteReader requires that the command has a transaction when the connection attributed to the command were in pending local transaction.
The property Transaction of the command was not initialize

The beginning ofthe listing up to the error.:

[cod]
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data.SqlClient.SqlTransaction" %>
<%@ Import Namespace="System.Configuration" %>
<%@ Import Namespace="System" %>

<script runat="Server">
Sub btnBulkCopy_Click(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles btnBulkCopy.Click

Dim ShajarConString As String
Dim NorthWindConString As String
Dim ShajarCon As SqlConnection = New SqlConnection()
Dim NorthwindCon As SqlConnection = New SqlConnection()

Dim ShajarCom As SqlCommand = New SqlCommand()
Dim ShajarReader As SqlDataReader

ShajarConString = _
ConfigurationManager.ConnectionStrings("DSN_Shajar ").ConnectionString
NorthWindConString = _
ConfigurationManager.ConnectionStrings("DSN_Northw ind").ConnectionString

ShajarCon.ConnectionString = ShajarConString
ShajarCom.Connection = ShajarCon
ShajarCom.CommandText = "SELECT ID, First_Name, Last_Name, " & _
"'Shajar' as Source FROM MailingList_Temp "
ShajarCom.CommandType = CommandType.Text

ShajarCom.Connection.Open()

Dim Transaction As SqlTransaction
Transaction = ShajarCom.Connection.BeginTransaction()

Dim NorthWindBulkOp As SqlBulkCopy
NorthWindBulkOp = New SqlBulkCopy(New SqlConnection(NorthWindConString), _
SqlBulkCopyOptions.Default, _
Transaction)

NorthWindBulkOp.DestinationTableName = "Employees"
NorthWindBulkOp.ColumnMappings.Add("Id", "EmployeeID")
NorthWindBulkOp.ColumnMappings.Add("First_Name", "FirstName")
NorthWindBulkOp.ColumnMappings.Add("Last_Name", "LastName")

Dim JobTitleColMap As SqlBulkCopyColumnMapping
JobTitleColMap = New SqlBulkCopyColumnMapping("Source", "Title")

NorthWindBulkOp.ColumnMappings.Add(JobTitleColMap)
NorthWindBulkOp.BulkCopyTimeout = 500000000

AddHandler NorthWindBulkOp.SqlRowsCopied, _
New SqlRowsCopiedEventHandler(AddressOf OnSqlRowsCopied)

NorthWindBulkOp.NotifyAfter = 1000

ShajarReader = ShajarCom.ExecuteReader()
[/code]