Hi. I am hoping that someone can advise me on an issue I am having with
connecting to a postgresql DB via unixODBC.
I am using an ubuntu VM to test the configuration. Here’s what I did:
1. Installed unixODBC
2. Installed odbc-postgresql
3. Configured odbc drivers and data sources.
I am able to connect to the database via the psql command. However, osql is
failing. Here’s the output:
rnduser@rnduser-VirtualBox:~$ osql -S rndredshift6 -U readonly -P *******
checking shared odbc libraries linked to isql for default directories...
strings: '': No such file
trying /tmp/sql ... no
trying /tmp/sql ... no
trying /etc ... OK
checking odbc.ini files
reading /home/rnduser/.odbc.ini
[rndredshift6] found in /home/rnduser/.odbc.ini
found this section:
[rndredshift6]
Driver = PostgreSQL
Description = data source for rndredshift
Server = 10.191.4.97
Port = 5439
Database = prod
looking for driver for DSN [rndredshift6] in /home/rnduser/.odbc.ini
found driver line: " Driver = PostgreSQL"
driver "PostgreSQL" found for [rndredshift6] in .odbc.ini
found driver named "PostgreSQL"
"PostgreSQL" is not an executable file
looking for entry named [PostgreSQL] in /etc/odbcinst.ini
found driver line: " Driver =
/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so"
found driver /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so for [PostgreSQL] in
odbcinst.ini
/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so is an executable file
"Server" found, not using freetds.conf
Server is "10.191.4.97"
looking up hostname for ip address 10.191.4.97
osql: warning: no DNS hostname found for "10.191.4.97"
Usage: host [-aCdlriTwv] [-c class] [-N ndots] [-t type] [-W time]
[-R number] [-m flag] hostname [server]
-a is equivalent to -v -t ANY
-c specifies query class for non-IN data
-C compares SOA records on authoritative nameservers
-d is equivalent to -v
-l lists all hosts in a domain, using AXFR
-i IP6.INT reverse lookups
-N changes the number of dots allowed before root lookup is done
-r disables recursive processing
-R specifies number of retries for UDP packets
-s a SERVFAIL response should stop query
-t specifies the query type
-T enables TCP/IP mode
-v enables verbose output
-w specifies to wait forever for a reply
-W specifies how long to wait for a reply
-4 use IPv4 query transport only
-6 use IPv6 query transport only
-m set memory debugging flag (trace|record|usage)
osql: no IP address found for ""
rnduser@rnduser-VirtualBox:~$
Telnet to 10.191.4.97 on port 5439 works.
Any ideas of what’s going on here?
Thanks,
Julie
This email is intended only for the use of the individual(s) to whom it is
addressed. If you have received this communication in error, please immediately
notify the sender and delete the original email.
