Why does System.IsFunctionAvailable ( “PQlibVersion”,"/usr/lib/libpq.dylib" ) always return false?
The file is there.
I also get a FunctionNotFoundException then I use any soft declare function like:
soft declare function PQconnectdb lib “/usr/lib/libpq.5.5.dylib” (ByRef conninfo As CString) as Ptr
OK, here I go again, here are the equivalent DB2 Libraries for use with SQLDatabaseMBS! The Windows and Linux versions work, but I could never get the Mac version to work. If someone can get it working and provide me the correct .dylib combination I would be very appreciative!
You can download IBM’s Express-C for Macintosh and run it. It installs a whole lot of .dylib files and I have tried to connect using them all in a variety of locations (like I did with Postgres and MySQL) but to no avail it would never connect. If you do connect, then you have to work out what chaff you can safely throw away to keep the size down.
Can you please explain how you got DB2 working through the Java/jdb libraries? Is that using SQLDatabaseMBS as well? I would love to have a full suite of all SQLDatabaseMBS libraries for all databases available! Someone else was working on MSSQL, but I don’t know if they succeeded.
I installed DB2 on a Windows Server on VMWare. The sample project was tested on OSX
At the time when I did these tests, I also tried to install the whole DB2 thing on OSX, but never succeeded. I also thought I could grab the necessary libs like that, but gave up on it. I’m pretty sure it just doesn’t work.
To use PostgreSQL with SQLDatabaseMBS on Windows I only need the following (note the dll/dylib/so files MUST be in the ‘lib’ subfolder or it doesn’t work must be a PostgreSQL issue):
In the Resources folder:
lib > libpq.dll
In the Framework folder:
For Macintosh all you need is in the Resources folder:
lib > libcrypto.1.0.0.dylib
lib > libpq.5.6.dylib
lib > libssl.1.0.0.dylib
For Linux all you need is in the Resources folder:
lib > libcrypto.so.1.0.0
lib > libpq.so.5.6
lib > libssl.so.1.0.0