Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: UPS Worldship Integration

  1. #1
    toofast is offline Senior Member
    Join Date
    Dec 2005
    Location
    Cherry Hill, NJ, USA
    Posts
    239

    Default UPS Worldship Integration

    is there a current manual on UPS Worldship Integration. I don't want to export/import csv files constantly, I want to connect it directly to my database. I almost have it completely done, but the export of the tracking number back into the DB is giving me this error:

    Code:
    ODBC ERROR: State = 23000 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'OrderNumber', table 'xxxxxx.dbo.ShippingImportExport'; column does not allow nulls. INSERT fails.
    Its very odd. I know the error says cannot import into 'OrderNumber', but I swear I am not trying to import into 'OrderNumber', I am trying to import into the 'TrackingNumber' field.

  2. #2
    Wade73 is offline Junior Member
    Join Date
    Feb 2011
    Posts
    14

    Default

    UPS Worldship Integration
    is there a current manual on UPS Worldship Integration. I don't want to export/import csv files constantly, I want to connect it directly to my database. I almost have it completely done, but the export of the tracking number back into the DB is giving me this error:

    Code:

    ODBC ERROR: State = 23000 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'OrderNumber', table 'xxxxxx.dbo.ShippingImportExport'; column does not allow nulls. INSERT fails.

    Its very odd. I know the error says cannot import into 'OrderNumber', but I swear I am not trying to import into 'OrderNumber', I am trying to import into the 'TrackingNumber' field.
    The issue is the sql statement either made by you or generated. It is trying to enter a null value. Can you detail your setup a bit more?

    Wade