[unixODBC-support] Datasource not found under Fedora 6 with Postgres

paul_deg paul_deg at yahoo.com
Fri Jun 15 00:16:22 BST 2007


Done. Still I can't tell what the problem is, the
trace is attached. There is a couple of places in the
file which I am concernd of:

connect(3, {sa_family=AF_FILE,
path="/var/run/nscd/socket"}, 110) = -1 ENOENT (N
o such file or directory)


and

fstat(3, {st_mode=S_IFREG|0644, st_size=25706, ...}) =
0
lseek(3, 25706, SEEK_SET)               = 25706
write(3, "[ODBC][26797][SQLConnect.c][3758"..., 46) =
46
close(3)                                = 0
munmap(0x2aaaadfb7000, 4096)            = 0
open("/tmp/sql.log", O_WRONLY|O_CREAT|O_APPEND, 0666)
= 3
fstat(3, {st_mode=S_IFREG|0644, st_size=25752, ...}) =
0
mmap(NULL, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2aa
aadfb7000
fstat(3, {st_mode=S_IFREG|0644, st_size=25752, ...}) =
0
lseek(3, 25752, SEEK_SET)               = 25752
write(3, "[ODBC][26797][SQLError.c][424]\n\t"..., 306)
= 306
close(3)


But I have no idea is it really bad or not.
Can you advise me on which Linux version/distro from
free available I can use with which version of
unixODBC and Postgres to get a working system without
need to do tracing?
Thanks. 




--- Nick Gorham <nick.gorham at easysoft.com> wrote:

> paul_deg wrote:
> 
> >I keep getting this message trying to connect to
> >PostgreSQL 8.1.  Unix ODBC and Postgres came with
> the
> >installation dvd. I use isql to test the
> connection. I
> >used dltest to test the drivers - loaded OK.
> >odbcinst -j shows  config  files location under
> /etc.
> >What can be wrong? Debud log from unix ODBC is not
> >very useful. Here are my ini files from /etc:
> >
> >odbcinst.ini:
> >  
> >
> 
> Try doing
> 
> strace isql -v PostgreSQL-test 2>slog
> 
> and see if slog shows what libs its trying to load
> and any clues.
> 
> -- 
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
>
http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 



 
____________________________________________________________________________________
The fish are biting. 
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
-------------- next part --------------
A non-text attachment was scrubbed...
Name: slog
Type: application/octet-stream
Size: 19129 bytes
Desc: 2204175874-slog
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20070614/0ae418df/attachment.obj>


More information about the unixODBC-support mailing list