Re: Remote SQL Server

#1

OlaW wrote:

Quote:

Hi,

I guess this is a simple question but anyway: I have a vb.net
application running on a w2003 server, the application uses a
database on a second w2003 server in the same LAN. Everything worked
fine until I sat Transaction Required. When the code reaches the
point where it is supposed to start a new transaction I receive:
"COMException...The partner transaction manager has disabled its
support for remote/network transactions." I have enabled DTC Access
in the security setting at the Remote Server but it doesn't help.

All involved DTCs must be activated.

Quote:

Do
I have to install the COM Application at the DB server too and the
DLL files the application is using?

No

#2

Thanks for the answer Steffen, but do you know how I activate the DTC in
w2003 server?
/Ola.

"Steffen Ramlow" <s.ramlow (AT) gmx (DOT) net> wrote

Quote:

OlaW wrote:
Hi,

I guess this is a simple question but anyway: I have a vb.net
application running on a w2003 server, the application uses a
database on a second w2003 server in the same LAN. Everything worked
fine until I sat Transaction Required. When the code reaches the
point where it is supposed to start a new transaction I receive:
"COMException...The partner transaction manager has disabled its
support for remote/network transactions." I have enabled DTC Access
in the security setting at the Remote Server but it doesn't help.

All involved DTCs must be activated.

Do
I have to install the COM Application at the DB server too and the
DLL files the application is using?

No

#3

OlaW wrote:

Quote:

Thanks for the answer Steffen, but do you know how I activate the DTC
in w2003 server?
/Ola.

Oh damned, you really want me to start my w2k3?

Hm, i bet you will find it in the Property Sheet of the computer in the
component services mmc.

Quote:

"Steffen Ramlow" <s.ramlow (AT) gmx (DOT) net> wrote in message
news:OnZztJIUDHA.2180 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
OlaW wrote:
Hi,

I guess this is a simple question but anyway: I have a vb.net
application running on a w2003 server, the application uses a
database on a second w2003 server in the same LAN. Everything worked
fine until I sat Transaction Required. When the code reaches the
point where it is supposed to start a new transaction I receive:
"COMException...The partner transaction manager has disabled its
support for remote/network transactions." I have enabled DTC Access
in the security setting at the Remote Server but it doesn't help.

All involved DTCs must be activated.

Do
I have to install the COM Application at the DB server too and the
DLL files the application is using?

No

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Remote SQL Server

Dotnet Framework (Component Services) microsoft.public.dotnet.framework.component_services

Re: Remote SQL Server - 07-22-2003 , 02:53 PM

Re: Remote SQL Server - 07-22-2003 , 10:09 PM

Re: Remote SQL Server - 07-23-2003 , 03:34 AM