Hello NG

I use a Windows Server 2003 Web Edition standalone Server as Web Server. On
this Server I have a web application running. This Web Application use some
Com+ components.
The Com+ components uses the MSDTC.

When I try to connect to the DB - I recive the following error message from
the Web Application:

User CTAdmin
Session 07.10.2003 14:31:29
Error Type Application defined Error
Error Number -2147168246
Error Source Microsoft OLE DB Provider for ODBC Drivers
Module/Function Benutzer/UserRole
Fehler [-2147168246][Microsoft OLE DB Provider for ODBC
Drivers][MTSFUNCTION/ConnectionGet] [Microsoft][ODBC SQL Server
Driver]Distributed transaction error



I can disable MSDTC on the Com+ components (Transaction support). Then the
application is working.

Also, when I run the Application on an Windows 2000 Memeber Server - MSDTC
is working.

Can anybody help me?

Regards
Roger

I assume the web and SQL are on different machines?
Is the MS DTC service running on both machines?
Can you ping by name between the machines, both ways? DTC requires name
resolution to work. Check your Hosts and LMHosts files.
Use TCP/IP for your SQL client network libaray if you can.

Is there any DTS here?

--
Darren Green
http://www.sqldts.com



"Roger Bavaud" <RBNewsG1 (AT) eta (DOT) ch> wrote

Yes the Web and the SQL Server are different machines.
The Service is running on both machines.
The Web Server is in a Test Lan and will be moved in a DMZ (behind the
firewall).
--> So I will try to create LMHosts files...

I use TCP/IP for the connection.
The SQL Database is running on a SQL 2000 Insatance (Port 5000).

I used the Client Network Utility to set the following:
Server Alias ETACHDB1VSO\Chronotrack
Network Library TCP/IP
Connection parameters 149.133.75.236\Chronotrack,5000



"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:eiTD4INjDHA.748 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Hi,

Now I can ping both server by name... but MSDCT is not workring - Same error
message. :-(

When I use the MS test tool I recive this output:

C:\>dtctester ChronoTrack Chronotrack xxxx
Executed: dtctester
DSN: ChronoTrack
User Name: Chronotrack
Password: xxxx
tablename= #dtc19103
Creating Temp Table for Testing: #dtc19103
Warning: No Columns in Result Set From Executing: 'create table #dtc19103
(ival
int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168220,msg='[Microsoft][ODBC SQL Server
Driver]
Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.




"Roger Bavaud" <RBNewsG1 (AT) eta (DOT) ch> wrote

OK is working now :-)

The Account witch is used for the Com+ Application must be a Member of the
local Group "Network Configuarton Operarators" only local Administrator is
not enaught - Windows 2003 Security ?!?

And the Lmhosts files are also needed - Tanks @Darren Green

Regards
Roger



"Roger Bavaud" <RBNewsG1 (AT) eta (DOT) ch> wrote

Glad it's working.

Name resolution was my biggest issue when using a FW and DMZ type scenario.

Interesting point on the Network Ops group in 2003.

--
Darren Green
http://www.sqldts.com


"Roger Bavaud" <RBNewsG1 (AT) eta (DOT) ch> wrote

Could you please explain what is the exact name of the com+ application you are referring to? and why to use lmhosts files?

Thanks



From http://www.developmentnow.com/g/103_...erver-2003.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com