Forum OpenACS Development: UnixODBC: driver for AOLserver adapted from sybase module

I noticed some discussion on the IRC channel concerning ODBC. A few years ago I adapted the sybase module and added transaction support.

The current snapshot is at:

http://junom.com/gitweb/gitweb.perl?p=nsunixodbc.git;a=summary

I may have this running somewhere, but I don't use the ODBC driver very much, I think I used it for Mimer SQL. In the new version of SQL (2003), the CLI interface is nearly identical to ODBC for Postgres and Oracle. It might be worth while enhancing this module.

I updated this module today and it now works with AOLserver 4.5 and PostgreSQL with unixODBC in the middle. There are library changes to unixODBC which prevent older versions of the AOLserver modules from building.

UnixODBC now fully supports ODBC 3.5, the latest standard (I think). Obviously the ns_db interface does not, sure would be nice.

Oops, one more note for those who have never used git, and you'll see why I'm using it.

The git repository can produce a 'snapshot' of the HEAD version, or any other version or even a subdirectory.

So if I commit to my local repository, then push it to my server, a tar.gz file can be downloaded instantly with no more work on my part.

I call it instant publication.

Anyway, while browsing a git repository you can always look for a link 'snapshot'. Clicking the link creates a download.

The HEAD version of nsunixodbc is:

http://junom.com/gitweb/gitweb.perl?p=nsunixodbc.git;a=snapshot;h=HEAD;sf=tgz

This gives a file named nsunixodbc-HEAD.tar.gz

I'll try to post the AOLserver config, but basically it hasn't changed.