Guest
|
 Posted:
Fri Feb 18, 2005 12:26 am Post subject:
SaveAsOrder fails with SQL Server on same machine |
|
|
- 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
Guest
|
| Posted:
Fri Feb 18, 2005 1:23 am Post subject:
Re: SaveAsOrder fails with SQL Server on same machine |
|
|
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:
| Quote: | - 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! |
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in