|
Home > Archive > Commerce Server General > February 2005 > SaveAsOrder fails with SQL Server on same machine
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]
| Author |
SaveAsOrder fails with SQL Server on same machine
|
|
| jon.vukovich@greatcleaners.com 2005-02-17, 5:51 pm |
| - Win2K SP4
- SQL Server 2000 SP3a
- MSCS 2002 SP2
- MDAC 2.8
I receive the following error when calling SaveAsOrder():
Exception: System.Runtime.InteropServices.COMException
Message: Could not connect to datasource
Source: Microsoft OLE DB Provider for ODBC Drivers
at
Microsoft.CommerceServer.Interop.Orders.OrderGroupClass.SaveAsOrder(Object&
vtOutTrackingNumber)
at Batch.Order.Save()
I've already seen the DTC issue posted everywhere, but that doesn't
seem to be my problem. Microsoft's DTCTest application works fine and
transactions are working. SQL Server is running on the same machine
this application is being executed on. Additionally, SaveAsOrder() does
not fail on our web applications (running on IIS on the same machine).
I've verified all of the database connection strings and they all look
fine. I've debugged and verified that other necessary MSCS objects are
initializing without issues: DataFunctions, ProfileService,
ExpressionEvaluator, CacheManager, AppConfig, MSCSCatalogManager and
MessageManager.
The basket and total pipelines aren't failing. The checkout pipeline
fails with the following error: Checkout pipeline failed: The following
request field(s) is either invalid or missing: customer_cc_number.
However, I think this is due to an credit card encryption bug (3rd
party tool) that is unrelated to the SaveAsOrder() error I'm seeing.
Additionally, we have another application written in VB.NET that acts
the same way (we are re-writing it for performance improvements), and
SaveAsOrder() does *not* fail in that application!
Anyone have any ideas? Thanks in advance!
| |
| Verran 2005-02-17, 5:51 pm |
| I figured out. Here's a tip in case anyone else has the trouble I had
with this.
Always call OrderGroupObj.Clear() before processing
OrderGroupObj.SaveAsOrder() again or it will break everything and mess
up all your orders! 
jon.vukovich@greatcleaners.com wrote:
> - Win2K SP4
> - SQL Server 2000 SP3a
> - MSCS 2002 SP2
> - MDAC 2.8
>
> I receive the following error when calling SaveAsOrder():
>
> Exception: System.Runtime.InteropServices.COMException
> Message: Could not connect to datasource
> Source: Microsoft OLE DB Provider for ODBC Drivers
> at
>
Microsoft.CommerceServer.Interop.Orders.OrderGroupClass.SaveAsOrder(Object&
> vtOutTrackingNumber)
> at Batch.Order.Save()
>
> I've already seen the DTC issue posted everywhere, but that doesn't
> seem to be my problem. Microsoft's DTCTest application works fine and
> transactions are working. SQL Server is running on the same machine
> this application is being executed on. Additionally, SaveAsOrder()
does
> not fail on our web applications (running on IIS on the same
machine).
>
> I've verified all of the database connection strings and they all
look
> fine. I've debugged and verified that other necessary MSCS objects
are
> initializing without issues: DataFunctions, ProfileService,
> ExpressionEvaluator, CacheManager, AppConfig, MSCSCatalogManager and
> MessageManager.
>
> The basket and total pipelines aren't failing. The checkout pipeline
> fails with the following error: Checkout pipeline failed: The
following
> request field(s) is either invalid or missing: customer_cc_number.
> However, I think this is due to an credit card encryption bug (3rd
> party tool) that is unrelated to the SaveAsOrder() error I'm seeing.
>
> Additionally, we have another application written in VB.NET that acts
> the same way (we are re-writing it for performance improvements), and
> SaveAsOrder() does *not* fail in that application!
>
> Anyone have any ideas? Thanks in advance!
|
|
|
|
|