[unixODBC-support] probelsm getting unixODBC to access an MS Access database on Linux

Gavin Simpson gavin.simpson at ucl.ac.uk
Fri Sep 10 11:48:53 BST 2004


Martin J. Evans wrote:
> open("/usr/lib/libmdbodbc.so.0", O_RDONLY) = 3
> suggests unixODBC found the DSN, got the driver name, located the driver in
> odbcinst.ini and loaded it.
> 
> open("/home/gavin/.odbc.ini", O_RDONLY) = 3
> fstat64(3, {st_mode=S_IFREG|0664, st_size=0, ...}) = 0
> mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
> 0) = 0xf6de3000
> read(3, "", 4096)                       = 0
> write(2, "Couldn\'t find DSN /home/gavin/.o"..., 53Couldn't find DSN 
> /home/gavin/.odbc.ini in gblakesdb
> ) = 53
> 
> suggests mdbtools only looks for DSNs in $HOME/.odbc.ini.
> Move your gblakesdb entry into $HOME/.odbc.ini and try again.
> 
> Martin
> --
> Martin J. Evans
> Easysoft Ltd, UK
> Development

Hi Martin,

Cheers for the response. I tried what you suggested and I can get isql 
to connect to the database if I have the .odbc.ini file in my home 
directory but only if there isn't one in /etc as well. This in the end 
doesn't help me as I need PHP to find the dsn.

Thanks for you help,

Gavin

-- 
%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%
Gavin Simpson                     [T] +44 (0)20 7679 5522
ENSIS Research Fellow             [F] +44 (0)20 7679 7565
ENSIS Ltd. & ECRC                 [E] gavin.simpson at ucl.ac.uk
UCL Department of Geography       [W] http://www.ucl.ac.uk/~ucfagls/cv/
26 Bedford Way                    [W] http://www.ucl.ac.uk/~ucfagls/
London.  WC1H 0AP.
%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%



More information about the unixODBC-support mailing list