Moving this post to the Sage 300 CRE forum in the Sage Construction and Real Estate Support Group.

Thanks,

Derek

Hi tmaurath,

You can create an ODBC DSN for POIV Data to access that database. Information can be found in our knowledgebase at www.sageKB.com:

https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=19988

Thanks!

Jesse, 

  So I read what you had and tried to do this.  I have an ODBC connection now, which is how I am pulling data.  What's the difference in doing a pervasive ODBC?  Right now using the current ODBC I don't see any PO or Inventory module information.

Thanks,

Correct - the PO and IV databases have a different structure, so they require a separate DSN in order to access the data using ODBC.

Jesse,   thanks so much for the information that you have shared on this.  When I follow the instructions, I do have Pervasive as an ODBC connection, but it says that I need the Engine Interface and what I show are Client & Unicode Interface.  Are either of these the same or am I missing one?  Also if I am missing the Engine interface how do I get it installed or made available??

thanks