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

Gavin Simpson gavin.simpson at ucl.ac.uk
Thu Sep 9 19:18:13 BST 2004


Hi,

I have installed mdbtools, plus their ODBC driver for MS Access and have 
configured it and unixODBC as the various instructions suggest. I am 
having trouble connecting to the single defined system dsn. Ultimately I 
want to connect to the mdb file from PHP but I can get isql to connect 
yet so that can wait until the dsn is sorted.

I'm using mdbtools 0.5 rpms on Fedora Core 2.

Anyone have any idea what I'm doing wrong or how to get this working?

Thanks in advance,

Gavin

*Here is some info:*

cat /etc/odbc.ini
[gblakesdb]
Description = GBLakes 3.0 Microsoft Access
Driver = MDBToolsODBC
Database = /var/www/databases/gblakes/gblakes.mdb
Servername = localhost
UserName =
Password =
Port = 5432

cat /etc/odbcinst.ini
[PostgreSQL]
Description             = ODBC for PostgreSQL
Driver          = /usr/lib/libodbcpsql.so
Setup           = /usr/lib/libodbcpsqlS.so
FileUsage               = 1

[MDBToolsODBC]
Description             = MDB Tools ODBC drivers
Driver          = /usr/lib/libmdbodbc.so.0
Setup           =
FileUsage               = 1
CPTimeout               =
CPReuse         =

*running:*

$ isql gblakesdb
Couldn't find DSN /home/gavin/.odbc.ini in gblakesdb
LookupDSN: LoadDSN returned FALSE[ISQL]ERROR: Could not SQLConnect

$ strace isql -v gblakesdb 2>st.log
[08001][unixODBC]Could not find DSN in odbc.ini

*strace output:*

$ cat st.log
execve("/usr/bin/isql", ["isql", "-v", "gblakesdb"], [/* 24 vars */]) = 0
uname({sys="Linux", node="ecrc2.geog.ucl.ac.uk", ...}) = 0
brk(0)                                  = 0x8289000
open("/etc/ld.so.preload", O_RDONLY)    = -1 ENOENT (No such file or 
directory)
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=64124, ...}) = 0
old_mmap(NULL, 64124, PROT_READ, MAP_PRIVATE, 3, 0) = 0xf6ff0000
close(3)                                = 0
open("/usr/lib/libodbc.so.1", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\204"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=379240, ...}) = 0
old_mmap(0x2a4000, 380872, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x2a4000
old_mmap(0x2fc000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 
3, 0x57000) = 0x2fc000
close(3)                                = 0
open("/usr/lib/libodbcinst.so.1", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 H(\000"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=48620, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, 
-1, 0) = 0xf6fef000
old_mmap(0x282000, 46028, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x282000
old_mmap(0x28d000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 
0xb000) = 0x28d000
close(3)                                = 0
open("/usr/lib/libltdl.so.3", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\360\241"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=25996, ...}) = 0
old_mmap(0x279000, 27608, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x279000
old_mmap(0x27f000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 
0x5000) = 0x27f000
close(3)                                = 0
open("/lib/libdl.so.2", O_RDONLY)       = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\300\370"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=16708, ...}) = 0
old_mmap(0x29e000, 12412, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x29e000
old_mmap(0x2a0000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 
0x1000) = 0x2a0000
close(3)                                = 0
open("/usr/lib/libreadline.so.4", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0@\356\202"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=172944, ...}) = 0
old_mmap(0x3824000, 174292, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x3824000
old_mmap(0x384a000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 
3, 0x26000) = 0x384a000
old_mmap(0x384e000, 2260, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x384e000
close(3)                                = 0
open("/usr/lib/libncurses.so.5", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0000\361"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=2748455, ...}) = 0
old_mmap(0x101000, 261420, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x101000
old_mmap(0x138000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 
3, 0x36000) = 0x138000
close(3)                                = 0
open("/lib/tls/libpthread.so.0", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`\3679\000"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=106212, ...}) = 0
old_mmap(0x39b000, 70128, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x39b000
old_mmap(0x3a9000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 
0xd000) = 0x3a9000
old_mmap(0x3ab000, 4592, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3ab000
close(3)                                = 0
open("/lib/tls/libc.so.6", O_RDONLY)    = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\300\v\27"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=1455084, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, 
-1, 0) = 0xf6fee000
old_mmap(0x15c000, 1158124, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x15c000
old_mmap(0x271000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 
3, 0x115000) = 0x271000
old_mmap(0x275000, 7148, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x275000
close(3)                                = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, 
-1, 0) = 0xf6fed000
mprotect(0x2a0000, 4096, PROT_READ)     = 0
mprotect(0x3a9000, 4096, PROT_READ)     = 0
mprotect(0x271000, 8192, PROT_READ)     = 0
mprotect(0x158000, 4096, PROT_READ)     = 0
set_thread_area({entry_number:-1 -> 6, base_addr:0xf6fed080, 
limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, 
limit_in_pages:1, seg_not_present:0, useable:1}) = 0
munmap(0xf6ff0000, 64124)               = 0
set_tid_address(0xf6fed0c8)             = 16841
rt_sigaction(SIGRTMIN, {0x39f6d0, [], SA_RESTORER|SA_SIGINFO, 0x3a6450}, 
NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN], NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=RLIM_INFINITY}) = 0
_sysctl({{CTL_KERN, KERN_VERSION}, 2, 0xfee3f7e8, 31, (nil), 0}) = 0
brk(0)                                  = 0x8289000
brk(0x82aa000)                          = 0x82aa000
brk(0)                                  = 0x82aa000
open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=40251184, ...}) = 0
mmap2(NULL, 2097152, PROT_READ, MAP_PRIVATE, 3, 0) = 0xf6ded000
mmap2(NULL, 4096, PROT_READ, MAP_PRIVATE, 3, 0x575) = 0xf6dec000
close(3)                                = 0
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6deb000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6deb000, 4096)                = 0
time(NULL)                              = 1094748298
access("/etc/odbc.ini", F_OK)           = 0
stat64("/etc/odbc.ini", {st_mode=S_IFREG|0664, st_size=184, ...}) = 0
semget(2030273451, 1, IPC_CREAT|IPC_EXCL|0666) = -1 EEXIST (File exists)
semget(2030273451, 1, IPC_CREAT|0666)   = 2424867
shmget(2030273451, 404, IPC_CREAT|IPC_EXCL|0666) = -1 EEXIST (File exists)
shmget(2030273451, 404, 0666)           = 3145741
shmat(3145741, 0, 0)                    = 0xf6deb000
semop(2424867, 0xfee3efd0, 2)           = 0
semop(2424867, 0xfee3efd0, 1)           = 0
semop(2424867, 0xfee3f400, 2)           = 0
semop(2424867, 0xfee3f400, 1)           = 0
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
semop(2424867, 0xfee3f500, 2)           = 0
semop(2424867, 0xfee3f500, 1)           = 0
time(NULL)                              = 1094748298
getuid32()                              = 500
socket(PF_FILE, SOCK_STREAM, 0)         = 3
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 
ENOENT (No such file or directory)
close(3)                                = 0
open("/etc/nsswitch.conf", O_RDONLY)    = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=1686, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1686
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=64124, ...}) = 0
old_mmap(NULL, 64124, PROT_READ, MAP_PRIVATE, 3, 0) = 0xf6ddb000
close(3)                                = 0
open("/lib/libnss_files.so.2", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`\33\0\000"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=50944, ...}) = 0
old_mmap(NULL, 45724, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x581000
old_mmap(0x58b000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 
0x9000) = 0x58b000
close(3)                                = 0
mprotect(0x58b000, 4096, PROT_READ)     = 0
munmap(0xf6ddb000, 64124)               = 0
open("/etc/passwd", O_RDONLY)           = 3
fcntl64(3, F_GETFD)                     = 0
fcntl64(3, F_SETFD, FD_CLOEXEC)         = 0
fstat64(3, {st_mode=S_IFREG|0644, st_size=1764, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1764
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
open("/home/gavin/.odbc.ini", O_WRONLY|O_APPEND|O_CREAT, 0666) = 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) = 0xf6dea000
fstat64(3, {st_mode=S_IFREG|0664, st_size=0, ...}) = 0
_llseek(3, 0, [0], SEEK_SET)            = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
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) = 0xf6dea000
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbc.ini", O_RDONLY)         = 3
close(3)                                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=184, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[gblakesdb]\nDescription = GBLake"..., 4096) = 184
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
getuid32()                              = 500
open("/etc/passwd", O_RDONLY)           = 3
fcntl64(3, F_GETFD)                     = 0
fcntl64(3, F_SETFD, FD_CLOEXEC)         = 0
fstat64(3, {st_mode=S_IFREG|0644, st_size=1764, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1764
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
open("/home/gavin/.odbc.ini", O_WRONLY|O_APPEND|O_CREAT, 0666) = 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) = 0xf6dea000
fstat64(3, {st_mode=S_IFREG|0664, st_size=0, ...}) = 0
_llseek(3, 0, [0], SEEK_SET)            = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
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) = 0xf6dea000
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
close(3)                                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=184, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[gblakesdb]\nDescription = GBLake"..., 4096) = 184
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
getuid32()                              = 500
open("/etc/passwd", O_RDONLY)           = 3
fcntl64(3, F_GETFD)                     = 0
fcntl64(3, F_SETFD, FD_CLOEXEC)         = 0
fstat64(3, {st_mode=S_IFREG|0644, st_size=1764, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1764
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
open("/home/gavin/.odbc.ini", O_WRONLY|O_APPEND|O_CREAT, 0666) = 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) = 0xf6dea000
fstat64(3, {st_mode=S_IFREG|0664, st_size=0, ...}) = 0
_llseek(3, 0, [0], SEEK_SET)            = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
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) = 0xf6dea000
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
close(3)                                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=184, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[gblakesdb]\nDescription = GBLake"..., 4096) = 184
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
getuid32()                              = 500
open("/etc/passwd", O_RDONLY)           = 3
fcntl64(3, F_GETFD)                     = 0
fcntl64(3, F_SETFD, FD_CLOEXEC)         = 0
fstat64(3, {st_mode=S_IFREG|0644, st_size=1764, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1764
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
open("/home/gavin/.odbc.ini", O_WRONLY|O_APPEND|O_CREAT, 0666) = 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) = 0xf6dea000
fstat64(3, {st_mode=S_IFREG|0664, st_size=0, ...}) = 0
_llseek(3, 0, [0], SEEK_SET)            = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
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) = 0xf6dea000
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
close(3)                                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=184, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[gblakesdb]\nDescription = GBLake"..., 4096) = 184
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
time(NULL)                              = 1094748298
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=272, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6dea000
read(3, "[PostgreSQL]\nDescription\t\t= ODBC"..., 4096) = 272
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6dea000, 4096)                = 0
time(NULL)                              = 1094748298
open("/usr/lib/gconv/gconv-modules.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=21512, ...}) = 0
mmap2(NULL, 21512, PROT_READ, MAP_SHARED, 3, 0) = 0xf6de5000
close(3)                                = 0
futex(0x27412c, FUTEX_WAKE, 2147483647) = 0
open("/usr/lib/gconv/ISO8859-1.so", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\4\0"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=5336, ...}) = 0
old_mmap(NULL, 8220, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xcec000
old_mmap(0xced000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 
0) = 0xced000
close(3)                                = 0
futex(0x2a1078, FUTEX_WAKE, 2147483647) = 0
open("/usr/lib/libmdbodbc.so.0", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\0F\0\000"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=89626, ...}) = 0
old_mmap(NULL, 126672, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xc26000
old_mmap(0xc37000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 
0x10000) = 0xc37000
old_mmap(0xc39000, 48848, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xc39000
close(3)                                = 0
mprotect(0xfee3f000, 4096, 
PROT_READ|PROT_WRITE|PROT_EXEC|PROT_GROWSDOWN) = 0
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=64124, ...}) = 0
old_mmap(NULL, 64124, PROT_READ, MAP_PRIVATE, 3, 0) = 0xf6dd5000
close(3)                                = 0
open("/usr/lib/libglib-1.2.so.0", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 \221D\000"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=148828, ...}) = 0
old_mmap(0x443000, 151060, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x443000
old_mmap(0x467000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 
0x23000) = 0x467000
close(3)                                = 0
munmap(0xf6dd5000, 64124)               = 0
open("/usr/share/locale/locale.alias", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=2528, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6de4000
read(3, "# Locale name alias data base.\n#"..., 4096) = 2528
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0xf6de4000, 4096)                = 0
open("/usr/share/locale/en_GB.UTF-8/LC_MESSAGES/libc.mo", O_RDONLY) = -1 
ENOENT (No such file or directory)
open("/usr/share/locale/en_GB.utf8/LC_MESSAGES/libc.mo", O_RDONLY) = -1 
ENOENT (No such file or directory)
open("/usr/share/locale/en_GB/LC_MESSAGES/libc.mo", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=1474, ...}) = 0
mmap2(NULL, 1474, PROT_READ, MAP_PRIVATE, 3, 0) = 0xf6de4000
close(3)                                = 0
open("/usr/share/locale/en.UTF-8/LC_MESSAGES/libc.mo", O_RDONLY) = -1 
ENOENT (No such file or directory)
open("/usr/share/locale/en.utf8/LC_MESSAGES/libc.mo", O_RDONLY) = -1 
ENOENT (No such file or directory)
open("/usr/share/locale/en/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT 
(No such file or directory)
stat64("/home/gavin/.odbc.ini", {st_mode=S_IFREG|0664, st_size=0, ...}) = 0
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
close(3)                                = 0
munmap(0xf6de3000, 4096)                = 0
write(2, "LookupDSN: LoadDSN returned FALS"..., 33LookupDSN: LoadDSN 
returned FALSE) = 33
munmap(0xc26000, 126672)                = 0
munmap(0x443000, 151060)                = 0
fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0xf6de3000
write(1, "[08001][unixODBC]Could not find "..., 48) = 48
write(2, "[ISQL]ERROR: Could not SQLConnec"..., 34[ISQL]ERROR: Could not 
SQLConnect
) = 34
semop(2424867, 0xfee3f570, 2)           = 0
semop(2424867, 0xfee3f570, 1)           = 0
shmdt(0xf6deb000)                       = 0
munmap(0xf6de3000, 4096)                = 0
exit_group(1)

-- 
%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%
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