ODBC and Mac OS X

Hi, is possible to use ODBC in Squeak under Mac OS X?

My test code:
connection := ODBCConnection
                                dsn: 'TESTDSN'
                                user: '***'
                                password: '***'.

Error: Unable to find function address.

In class method ODBCLibrary>>moduleName is "odbc32" - is it platform  
independent? No one using ODBC on Mac OS X?

Thanks, pf

ODBC requires FFI, do you have FFI installed?

Ramon Leon
http://onsmalltalk.com 

Yes, FFI is installed (FFI was installed by ODBC dependency in  
Universe Browser). Do you have working ODBC enviroment in Squeak on  
Mac OS X?
(I am using squeak-dev image sq3.9-7067dev07.10.1.image)

pf

On 16.10.2007, at 19:09, Ramon Leon wrote:

The package sais thath ODBC for Squeak only works on Windows and Linux.

http://map.squeak.org/package/ba5582d8-4e50-417c-abd1-07dcd5c4d7b2

Very simple framework for ODBC support in Squeak. Use FFI to talk to  
ODBC32.dll, no other DLL is necessary.

It works in Windows and in Unix.


Category: Persistence
Depends on:
        FFI

Maintained by: Lex Spoon <[hidden email]>
Downloads from: http://wiki.squeak.org/squeak/uploads/2480/ODBC-dgd.10.cs.gz




Quoting Petr Fischer <[hidden email]>:

Well you need to install a ODBC package of some sort on your mac.
Say from
http://www.iodbc.org/index.php?page=languages/php/php-osx-HOWTO

Once installed you'll have some dll/module, say in windows it's  
odbc32.dll.
For the mac or any unix box I have no idea what it would be called  
and could be dependent on which odbc client vendor/open source  
solution you use.

In order for FFI to find it, it must be found in a path that FFI  
searchs and be named like what you see in the Smalltalk FFI code.
Mind you the FFI logic given odbc32 would also search for odbc32.so  
odbc32.dylib libodbc32  ...

As mentioned a helpful symbolic link odbc32 in the right place is  
helpful.

PS http://www.macports.org/
maybe helpful here in finding a odbc client since it's an interface  
to help install the BSD unix port's tree on os-x

On Oct 16, 2007, at 10:04 AM, Petr Fischer wrote:

--
========================================================================
===
John M. McIntosh <[hidden email]>
Corporate Smalltalk Consulting Ltd.  http://www.smalltalkconsulting.com
========================================================================
===