|
Home > Archive > Commerce Server General > July 2004 > SaveAsOrderError
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| miltonterra 2004-07-15, 5:51 pm |
| 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
| |
| Robert Bogue 2004-07-15, 5:51 pm |
| 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
>
>
>
| |
| miltonterra 2004-07-15, 5:51 pm |
| 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.
| |
| Robert Bogue 2004-07-16, 7:49 am |
| 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.
>
| |
| miltonterra 2004-07-16, 5:50 pm |
| 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.....?
| |
| Robert Bogue 2004-07-16, 5:50 pm |
| 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.....?
>
|
|
|
|
|