Integration with PostgreSql

Evan Paradies

• 21. Juli 2017 14:53

I am trying to create an integration with a Postgresql database(version 9.2.18).  If I try the Postgresql integration type I do not get the option "Field has a specified value", which is what I need.  I can successfully connect to the database via ODBC and can print labels based on a specified value.  The problem comes when I try to update the field after processing.  No matter what I try it errors out with:

ERROR [0A000] ERROR: cross-database references are not implemented: "XXXXXXX.public.mrp_production";
Error while executing the query

Has anyone else encountered this and know of a fix?

Thanks!

 

 

0

• 

  Ivan Ivanov

  ★ BarTender Hero ★

  • 28. September 2018 09:47

  Hi there,

  I am in the same trouble with BarTender 2016R7 and 2016R8, trying to connect to Postgresql 9.5 and Postgresql 10

  I just don't have the "Field has a specified value", which I should have after the documentation (http://help.seagullscientific.com/2016/en/#../Subsystems/IntegrationBuilder/Content/PropertyPage_RecordDetection.htm)

  If this is the expected behaviour, please advise how can I modify the database after successful printing, so I can update the "printed" column to be set to true.

  I appreciate any help on this!

  Thank you in advance!

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.