Hi
Is it necessary to have the connection open code inside the transaction scope to be able to use transaction features.
I wrote a code which has the connection.open outside the transaction scope and it wasn’t working correctly. When i moved the connection.open inside the transaction scope it started working fine.
Apart from this is there any special setting i need to do (DTC related) while working with System.Transaction and SQL Server 2000.
Are there any special settings need to be done when using DTC with multi process machine (hosting SQL server 2000).
Thanks< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
System.Transactions issues
Hot Topic
- Inner Join matches non-equal fields??????
- Standard deviation calculation
- Experts required to validate these statements of fact
- SQK2K - Linked server security.
- SQL Mobile Installation Problem on Device
- Query:how to transfer data from a .net application in wireless mode in a WLAN enviornment.
- Serializing / Deserializing from within Script component ?
- What is faster: DataReader or DataSet or something else?
- SQLServer Express 2005 and VS.NET 2003
- SQL CE Merge Replication
SQL Server
- Get Authentication Error in upgrade SQL 2005 named instance to SP1 TCP
- exporting reports into EXCEL format
- DTS DB2 Dates 0001-01-01
- How do you export SQL 2005 Maintenance Plans?
- HIding databases that a user does not have permission to
- default schema for NT-group not possible
- SQL2K5 SP1-CTP fails while upgrading "Database Services"
- cannot start or verify that SQL 2005 is running
- SP simplification for performance
- SCD Wizard
System.Transactions issues
Musa-1
It is necessary to open the connection inside the TransactionScope, because the enlistment in the transaction happens during Open.
You need to make sure that you enable network transactions for DTC if your SQL Server is located on a remote machine (see http://blogs.msdn.com/florinlazar/archive/2004/06/18/159127.aspx for more details).
If you are referring to multi-processor machines, then you don't have to do anything specific for DTC for them.
Regards.