- TOTECS Pty Ltd

Forums » Connector Application » MYOB AccountRight Premier/Enterprise Adaptor »

Orders not submitting into MYOB Account Right Premier due to "Unable to determine if import has finished" error

Author

Thread

Orders not submitting into MYOB Account Right Premier due to "Unable to determine if import has finished" error

Author Rich Allen
November 30 2017 @ 03:38 PM

Thread One of our customers is having trouble submitting orders into MYOB Account Right Premier due to an "Unable to determine if import has finished" error.

Is it possible to modify how the connector works to add in a timeout to the ODBC connection string? (SQL_LOGIN_TIMEOUT=90;)

TOTECS Service Centre Coordinator

Comments

Rowan Drew
November 30 2017 @ 03:45 PM
TOTECS Software Development Manager

Within the Connector's MYOB AccountRight Premier adaptor if it tries to submit an a sales order into the MYOB AccountRight Premier system and gets an "Unable to determine if import has finished" it may or may be indicative of whether the query is taking long time to run, whether the data is correct in the order, or if their is a lock file issue causing MYOB's ODBC driver to fail to import the order.

If you wish to add additional arguments to the driver ODBC connection string that is used to write data into AccountRight, then within the adaptor's "Writing ODBC Data Source Name" setting you can append additional arguments after the data source name by placing a semi-colon then the argument you wish to add. For example:

ExampleMYOBDSN;SQL_LOGIN_TIMEOUT=90

Comment has been marked as the answer

Hello! Register or login to become part of the discussion