We use some industry specific software where I work that uses Pervasive SQL server (running on 2008r2 server). I have many php application that access this DB using unixODBC. My issue is that Pervasive SQL does have a 64bit client for Linux, but only the 32bit version supports ODBC. My current application server is long in the tooth (Slackware 12.1), and I would like to move everything to a 64bit box (Slackware).

Is it possible to build a x64 PHP package that uses a couple x86 libraries?

I haven't been able to get this working, and am starting to wonder if I just need to stick with an x86 build for everything that need to access the odbc.

The only libraries that must be 32bit are unixODBC, and PervaiseSQL_client. I setup a test Slackware64-14.0 box, and installed Alien Bob's multilib setup. I was able to build 32bit packages for unixODBC & Pervasie sql client on the x64 box, installed, and tested them. All is working.

I've tried to build php.SlackBuild on the x64 box with odbc support, but it fails.

configure: error: ZLIB extension requires gzgets in zlib

I've been building 32bit php packages for over 5 years now with odbc support, and never had a problem. Is there a way I can tell the build script that a couple libraries need to be 32bit?
Or is this just not going to work, and I should keep the odbc application on a 32 bit box?

Any thoughts or guidance would be greatly appreciated.

Thanks!

Mr. B-o-B

My take on this is that you are out of luck. You can't load 32bit libs into a 64bit binary, so whatever process would connect to odbc would need to be 32bit. You could run a 32bit php on the 64bit host. I doubt without investing a lot of time an effort it would get better than this.

1 members found this post helpful.

Thank for your reply ppr:kut. I was afraid that this was the case. Perhaps someday Pervasive SQL will release a 64bit client that supports odbc, but until then I'm OK with keeping a 32bit box around.

Thanks!