M
Marc Robitaille
Hello,
I have created an application with Visual Studio 2005 Standard Edition. The
application is connecting to a database that I made it with SQL Server 2005.
The application uses the TransactionScope class this way with no problem:
Using Scope As New
Transactions.TransactionScope(Transactions.TransactionScopeOption.RequiresNew)
....
Scope.Complete()
End Using
In the transaction, the application executes a stored procedure with
parameters. I use the SqlClient namespace to do the job. Then I convert my
code to Visual Basic 2008 Express Edition. I have also switch my database
from 2005 to SQL Server 2008 Express Edition. That is where the problems
started. The application does not work when I use the TransactionScope
class. I have this error message:
The requested operation could not be performed because OLE DB provider
"MSDASQL" for linked server "(null)" does not support the required
transaction interface.
But when I put the lines that create the transactionScope in comment,
everything works just fine. What is going wrong? I need that Transaction if
someting goes wrong. Is there a new way to create a transaction with VB
Express 2008 that I am not aware of? Is there somebody that had the same
problem? If yes, how did you solve the problem?
Thank you all!
Marc R.
I have created an application with Visual Studio 2005 Standard Edition. The
application is connecting to a database that I made it with SQL Server 2005.
The application uses the TransactionScope class this way with no problem:
Using Scope As New
Transactions.TransactionScope(Transactions.TransactionScopeOption.RequiresNew)
....
Scope.Complete()
End Using
In the transaction, the application executes a stored procedure with
parameters. I use the SqlClient namespace to do the job. Then I convert my
code to Visual Basic 2008 Express Edition. I have also switch my database
from 2005 to SQL Server 2008 Express Edition. That is where the problems
started. The application does not work when I use the TransactionScope
class. I have this error message:
The requested operation could not be performed because OLE DB provider
"MSDASQL" for linked server "(null)" does not support the required
transaction interface.
But when I put the lines that create the transactionScope in comment,
everything works just fine. What is going wrong? I need that Transaction if
someting goes wrong. Is there a new way to create a transaction with VB
Express 2008 that I am not aware of? Is there somebody that had the same
problem? If yes, how did you solve the problem?
Thank you all!
Marc R.