OleDbTransaction Help

[CGameDev]

I have two SQL Servers database  (ServerA, ServerB) with the same database and the same table (Table_Customers).

Now I want to update Table_Customers on ServerB with the data from ServerA. I am doing this in C# and I would like so help to identify what I am doing wrong please.

[gtx1060=value]

did nothing come up in the console?

[gtx1060=value]

do you go to conestoga by any chance?

[CGameDev]

6 minutes ago, gtx1060=value said:

do you go to conestoga by any chance?

yes

[gtx1060=value]

4 minutes ago, xiiijamaican said:

yes

well here's the issue - i can't see any issues at first glance - anything errors or exceptions come up?

[CGameDev]

10 minutes ago, gtx1060=value said:

did nothing come up in the console?

Its not compiling, It seem I am doing the transaction wrong because it is set up different from a sqlConnection layout

[CGameDev]

2 minutes ago, gtx1060=value said:

well here's the issue - i can't see any issues at first glance - anything errors or exceptions come up?

 

[gtx1060=value]

3 minutes ago, xiiijamaican said:

 

seems like this compiler has no idea wtf destinationtablename and writetoserver are

[Seuntjie]

You're using the incorrect class to copy the data. You should be using SqlBulkCopy instead of OleDbTransaction.

 

So replacing the line

OleDbTransaction BKD = new OleDbTransaction(DestinationDB);

//with

SqlBulkCopy BKD = new SqlBulkCopy(DestinationDB);

 

Should do the trick. Although I'm not sure how it's going to handle the oledb datareader with the sql connection. If you're using SQL Server, you should be using SqlConnection, SqlTransaction, SqlCommand etc instead of OleDbConnection etc.

 

 

If you look at your errors, the first one in the screenshot shows that OleDbTransaction does not have a constructor with 1 parameter. This indicates that this statement is incorrect: new OleDbTransaction(DestinationDB); Namely, that the number of parameters between the brackets are incorrect. 

The other errors are saying that the type of object you're using doesn't have those properties or functions. This indicates one of two things: You're using the wrong property or method name (typo, completely wrong name etc) or the object type is incorrect.

 

[CGameDev]

On ‎2‎/‎27‎/‎2017 at 6:06 AM, Seuntjie said:

You're using the incorrect class to copy the data. You should be using SqlBulkCopy instead of OleDbTransaction.

 

So replacing the line

 

OleDbTransaction BKD = new OleDbTransaction(DestinationDB);

//with

SqlBulkCopy BKD = new SqlBulkCopy(DestinationDB);

 

 

Should do the trick. Although I'm not sure how it's going to handle the oledb datareader with the sql connection. If you're using SQL Server, you should be using SqlConnection, SqlTransaction, SqlCommand etc instead of OleDbConnection etc.

 

 

If you look at your errors, the first one in the screenshot shows that OleDbTransaction does not have a constructor with 1 parameter. This indicates that this statement is incorrect: new OleDbTransaction(DestinationDB); Namely, that the number of parameters between the brackets are incorrect. 

The other errors are saying that the type of object you're using doesn't have those properties or functions. This indicates one of two things: You're using the wrong property or method name (typo, completely wrong name etc) or the object type is incorrect.

 

Thanks, will try that