Jump to content


Photo

PHP / Synergy xfODBC connection


  • Please log in to reply
2 replies to this topic

#1 ckreifels

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.

 

Regards

Chris



#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 17,844 posts

Posted 01 November 2017 - 07:51 PM

Have you got PHP's ODBC libraries installed?

php.net/manual/en/book.uodbc.php
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






moon.png

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

#3 ckreifels

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