Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MTSTransactionmode and SQL Server conncetion hanging

Status
Not open for further replies.
gdrenfrew

gdrenfrew

Programmer
Aug 1, 2002
227
GB
I'm trying to create a connection to my SQL Server 2000 database, from my W2K workstation. When I use a component, with the MTStransactionmode set to "Requires New", my connection hangs on the .open call. When I set the mode to 0 - Not A Transaction Object, it connects fine.

Do I have to make any changes to the set up of my SQL Server installation?

Thanks

 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
loopimg link and downlosd zip file 1
Replies
3
Views
337
strongm
strongm
wires
  • Locked
  • Question
Install VB6 IDE and Access97 on W11 ARM version 1
Replies
3
Views
606
Gabor526
G
sal21
  • Locked
  • Question
API REST get zip cod efrom street name and city
Replies
1
Views
285
strongm
strongm
Ken01
  • Locked
  • Question
Areas under graphs and overlap areas between circles. 2
Replies
3
Views
849
Ken01
Ken01
2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
478
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top