Hi, I have a problem with a conection to database when executing a
SaveAsOrder Method. What is the connection that Commerce uses in this
method?
Thanks.

error:
Microsoft OLE DB Provider for SQL Server error '80004005'
Could not connect to datasource

[ Post a follow-up to this message ]

This is one of the spots where Commerce server requires that DTC
(Distributed Transaction Coordinator) be setup correctly.  Do you have a
firewall between the SQL server and the web server?  Does DTC work between
the two machines?

There are some KB articles with DTC testing utilities that you can use to
confirm that it's working correctly.

Rob

--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"miltonterra" <milton@somlivre.com.br> wrote in message
 news:4efe0a6d7036f1041a5334843209f82c@lo
calhost.talkaboutsoftware.com...
> Hi, I have a problem with a conection to database when executing a
> SaveAsOrder Method. What is the connection that Commerce uses in this
> method?
> Thanks.
>
> error:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Could not connect to datasource
>
>
>

[ Post a follow-up to this message ]

I dont have a firewall between the SQL Server and the Web Server and I used
the DTCping to test DTC. The result was OK.
I think about some problem in DNS to solve names, or some especific
configuration in DTC that I can identificate.
Thanks for the help.

[ Post a follow-up to this message ]

Is the SQL server on the default port?  (I presume you're using TCP/IP.)  If
not and you can test it on the default port that might be helpful.

Have you checked out KB Article Q331953?

Rob

--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"miltonterra" <milton@somlivre.com.br> wrote in message
 news:b373acf3cb07c6765954ebed9cb156ae@lo
calhost.talkaboutsoftware.com...
> I dont have a firewall between the SQL Server and the Web Server and I
used
> the DTCping to test DTC. The result was OK.
> I think about some problem in DNS to solve names, or some especific
> configuration in DTC that I can identificate.
> Thanks for the help.
>

[ Post a follow-up to this message ]

Yes, I´m using TCP/IP on the default port.
Just one consideration. My Web Server is a W2k and my SQLServer is a
W2k3.
Could this be the cause? I dont have experience with CommerceServer2000
using a DataBase in a W2k3 server, maybe there is some specific
configuration.....?

[ Post a follow-up to this message ]

Have you enabled network DTC support on the W2K3 box?  It's not on by
default.

When you tried DTCPing did you do it from both directions?

Rob

--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"miltonterra" <milton@somlivre.com.br> wrote in message
 news:8aae3c60e153d032bf19cc9eacab5732@lo
calhost.talkaboutsoftware.com...
> Yes, I´m using TCP/IP on the default port.
> Just one consideration. My Web Server is a W2k and my SQLServer is a
> W2k3.
> Could this be the cause? I dont have experience with CommerceServer2000
> using a DataBase in a W2k3 server, maybe there is some specific
> configuration.....?
>

[ Post a follow-up to this message ]