Re: Does psqlODBC actually work on osx?

> > We have a client trying to connect to PostgreSQL server 9.2 from an osx
> > client with our software via ODBC, he has asked for instructions to
> > assist him setting up.
> >
> > I have attempted the setup myself using psqlODBC and no matter what I do
> > configuration wise, the driver fails to connect (via iodbctestw and
> > iodbc administrator) stating that the password is incorrect - I know
> > this is not the case because I am using identical configuration to my
> > linux machine where it works fine.
> What is the exact error message you are getting?
> Are you connecting from within the same network as your Linux machine?
> Just trying to eliminate the possibility that it is a pg_hba.conf issue.
All on same internal network.
Server 10.0.0.3, working machine(s) 10.0.0.24, 10.0.0.25 etc. broken
machine 10.0.0.26
I've tried also setting the pg_hba.conf to 'trust' and even then it
doesn't seem to work.

Various config info and traces below.

Snippet from configuration (Although I've played with various other
options SSLmode etc. here as well)

[test]
Driver=psqlODBC
Server=10.0.0.3
Database=todo
Username=postgres
Password=postgres13

iodbctestw error messsage:
1: SQLDriverConnectW = FATAL: password authentication failed for user
"postgres" (210) SQLSTATE=28P01

Trace:
** Trace started on Tue Nov 04 18:17:38 2014
** Driver Manager: 03.52.0607.1008

[000000.001003]
iodbctestw 7FFF70390CC0 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x100046340

[000000.001049]
iodbctestw 7FFF70390CC0 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x100046340 (0x100110c70)

[000000.001093]
iodbctestw 7FFF70390CC0 ENTER SQLSetEnvAttr
SQLHENV 0x100110c70
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * 4294967291 (SQL_IS_UINTEGER)

[000000.001149]
iodbctestw 7FFF70390CC0 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x100110c70
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * 4294967291 (SQL_IS_UINTEGER)

[000000.001192]
iodbctestw 7FFF70390CC0 ENTER SQLAllocHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x100110c70
SQLHANDLE * 0x100046348

[000000.001238]
iodbctestw 7FFF70390CC0 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x100110c70
SQLHANDLE * 0x100046348 (0x100110f20)

[000000.001279]
iodbctestw 7FFF70390CC0 ENTER SQLSetConnectOptionW
SQLHDBC 0x100110f20
SQLUSMALLINT 1051 (unknown connection attribute)
SQLLEN 4295220960

[000000.001322]
iodbctestw 7FFF70390CC0 EXIT SQLSetConnectOptionW with return code 0 (SQL_SUCCESS)
SQLHDBC 0x100110f20
SQLUSMALLINT 1051 (unknown connection attribute)
SQLLEN 4295220960

[000000.001366]
iodbctestw 7FFF70390CC0 ENTER SQLGetInfoW
SQLHDBC 0x100110f20
SQLUSMALLINT 171 (SQL_DM_VER)
SQLPOINTER 0x7fff5fbfeb80
SQLSMALLINT 1020
SQLSMALLINT * 0x7fff5fbff60c

[000000.001438]
iodbctestw 7FFF70390CC0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
SQLHDBC 0x100110f20
SQLUSMALLINT 171 (SQL_DM_VER)
SQLPOINTER 0x7fff5fbfeb80
| 03.52.0607.1008 |
SQLSMALLINT 1020
SQLSMALLINT * 0x7fff5fbff60c (15)

[000000.002935]
iodbctestw 7FFF70390CC0 ENTER SQLDriverConnectW
SQLHDBC 0x100110f20
SQLPOINTER 0x0
SQLWCHAR * 0x7fff5fbfdb80
| DSN=test;UID=postgres;PWD=********** |
SQLSMALLINT -3 (SQL_NTS)
SQLWCHAR * 0x100048840
SQLSMALLINT 4096
SQLSMALLINT * 0x7fff5fbff60e
SQLUSMALLINT 1 (SQL_DRIVER_COMPLETE)

[000000.017832]
iodbctestw 7FFF70390CC0 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
SQLHDBC 0x100110f20
SQLPOINTER 0x0
SQLWCHAR * 0x7fff5fbfdb80
SQLSMALLINT -3 (SQL_NTS)
SQLWCHAR * 0x100048840
SQLSMALLINT 4096
SQLSMALLINT * 0x7fff5fbff60e
SQLUSMALLINT 1 (SQL_DRIVER_COMPLETE)

[000000.017936]
iodbctestw 7FFF70390CC0 ENTER SQLGetDiagRecW
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x100110f20
SQLSMALLINT 1
SQLWCHAR * 0x7fff5fbfdad0
SQLINTEGER * 0x7fff5fbfdb0c
SQLWCHAR * 0x7fff5fbfd2d0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.018047]
iodbctestw 7FFF70390CC0 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x100110f20
SQLSMALLINT 1
SQLWCHAR * 0x7fff5fbfdad0
| 28P01 |
SQLINTEGER * 0x7fff5fbfdb0c (210)
SQLWCHAR * 0x7fff5fbfd2d0
| FATAL: password authentication failed fo |
| r user "postgres" |
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.018306]
iodbctestw 7FFF70390CC0 ENTER SQLGetDiagRecW
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x100110f20
SQLSMALLINT 2
SQLWCHAR * 0x7fff5fbfdad0
SQLINTEGER * 0x7fff5fbfdb0c
SQLWCHAR * 0x7fff5fbfd2d0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.018480]
iodbctestw 7FFF70390CC0 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x100110f20
SQLSMALLINT 2
SQLWCHAR * 0x7fff5fbfdad0
SQLINTEGER * 0x7fff5fbfdb0c
SQLWCHAR * 0x7fff5fbfd2d0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.018544]
iodbctestw 7FFF70390CC0 ENTER SQLGetDiagRecW
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x100110c70
SQLSMALLINT 1
SQLWCHAR * 0x7fff5fbfdad0
SQLINTEGER * 0x7fff5fbfdb0c
SQLWCHAR * 0x7fff5fbfd2d0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.018833]
iodbctestw 7FFF70390CC0 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x100110c70
SQLSMALLINT 1
SQLWCHAR * 0x7fff5fbfdad0
SQLINTEGER * 0x7fff5fbfdb0c
SQLWCHAR * 0x7fff5fbfd2d0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.018940]
iodbctestw 7FFF70390CC0 ENTER SQLGetDiagRecW
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x100110f20
SQLSMALLINT 1
SQLWCHAR * 0x7fff5fbff9e0
SQLINTEGER * 0x7fff5fbffa1c
SQLWCHAR * 0x7fff5fbff1e0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.019015]
iodbctestw 7FFF70390CC0 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x100110f20
SQLSMALLINT 1
SQLWCHAR * 0x7fff5fbff9e0
SQLINTEGER * 0x7fff5fbffa1c
SQLWCHAR * 0x7fff5fbff1e0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.019083]
iodbctestw 7FFF70390CC0 ENTER SQLGetDiagRecW
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x100110c70
SQLSMALLINT 1
SQLWCHAR * 0x7fff5fbff9e0
SQLINTEGER * 0x7fff5fbffa1c
SQLWCHAR * 0x7fff5fbff1e0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.019149]
iodbctestw 7FFF70390CC0 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x100110c70
SQLSMALLINT 1
SQLWCHAR * 0x7fff5fbff9e0
SQLINTEGER * 0x7fff5fbffa1c
SQLWCHAR * 0x7fff5fbff1e0
SQLSMALLINT 512
SQLSMALLINT * 0x0

[000000.019216]
iodbctestw 7FFF70390CC0 ENTER SQLFreeHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x100110f20

[000000.019263]
iodbctestw 7FFF70390CC0 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x100110f20

[000000.019297]
iodbctestw 7FFF70390CC0 ENTER SQLFreeHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x100110c70

[000000.019328]
iodbctestw 7FFF70390CC0 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x100110c70

** Trace finished on Tue Nov 04 18:17:38 2014

>
> >
> >
> > Has anybody actually tested psqlODBC on OSX recently? Does it actually
> > work? Is there some known issue that causes this password thing, if so
> > what is the workaround?
> > (I'm trying on Snow Leopard myself but even information about a more
> > recent version would be great to know)