Jump to content


PHP / Synergy xfODBC connection

  • Please log in to reply
2 replies to this topic

#1 ckreifels

  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 01 November 2017 - 07:09 PM

Our accounting software runs on the Synergy platform.  I'm trying to write some PHP code to extract(read-only) data from the Synergy database.  I have Synergy's xfODBC driver installed on my PC and can utilize it in Excel and Crystal reports like any other ODBC connection, but I cannot figure out the interface with PHP to allow it to access the database.  


I am running XAMPP on my workstation for testing, but would eventually move to a WinServer platform with IIS.


Am I the first to try this?  Surely not.  If anybody can assist, it would be most helpful.




#2 Barand

  • Moderators
  • Sen . ( ile || sei )
  • 18,041 posts

Posted 01 November 2017 - 07:51 PM

Have you got PHP's ODBC libraries installed?

If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received


|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#3 ckreifels

  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 02 November 2017 - 02:34 PM

ODBC was not activated in my XAMPP installation.  Bonehead move on my part.  Thanks for your help Barand.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users