P and P
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Articles
Downloads
Gallery
Posts posted by P and P
-
-
I came across this whilst trying to find an answer to our problem.
We have used Sage ODBC driver from I think about v23.
Connect using PHP odbc_connect() from Apache server running on Windows. As the Sage version changes we just install the new version driver and add a s system DSN with the and off we go.Has been fine up until v28, just add the ODBC driver to Windows as the new version arrives. v29 does not work
Error:odbc_connect(): SQL error: The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 29.0, SQL state 01000 in SQLConnect
Has the ODBC Driver for v29 Sage50 Changed? Failing with Filemaker Pro
in General
Posted
Oops, submitted before finished:
I came across this whilst trying to find an answer to our problem.
We have used Sage ODBC driver from I think about v23.
Connect using PHP odbc_connect() from Apache server running on Windows. As the Sage version changes we just install the new version driver and add a s System DSN with the Data Path as a network drive letter e.g. Q: (PHP maps the drive e.g. net useĀ \\server\sage\company)
Has been fine up until the new v29
Get error:
odbc_connect(): SQL error: The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 29.0, SQL state 01000 in SQLConnect
I know this is unsupported but any help would be appreciated.
Thanks