Dovla
Guest
|
 Posted:
Fri Oct 21, 2005 12:50 pm Post subject:
SaveAsOrder Method |
|
|
Hi,
We have problem with a connection to database when executing a SaveAsOrder
Method.
We installed Windows Server 2003 Standard + SP1 (firewall is not enabled)
and Commerce Server 2002 and now we cannot connect to Windows 2000 Server &
SQL 2000 using that method. Update MS05-051 was not installed.
There is no problem connecting to the same sever from machines that have
Windows Server 2000 and Comm.Ser 2000.
The error we get when connecting is Could not connect to datasource at
Microsoft.CommerceServer.Interop.Orders.OrderGroupClass.(Object&
vtOutTrackingNumber)
All machines are in the same subnet – no firewall-s between them.
We assumed that the problem could be DTC, so we installed a tool DTCTester
and Pingtest.bat.
Using Pingtest.bat we found out that those machines could connect to each
other.
When testing connection by DTCTester tool we get this output:
Executed: dtctester
DSN: test
User Name: sa
Password: sa
tablename= #dtc32628
Creating Temp Table for Testing: #dtc32628
Warning: No Columns in Result Set From Executing: 'create table #dtc32628
(ival
int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168242,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.
So far we followed steps in the article
http://support.microsoft.com/?kbid=555017 (except Optional steps), but that
did not resolve the issue.
Thanks
Vlado |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in