[pongsiri@ttei.toshiba.co.th: Test Connection to PostgreSQL by PostgreSQL ODBC Driver] - Mailing list pgsql-odbc

From Alvaro Herrera
Subject [pongsiri@ttei.toshiba.co.th: Test Connection to PostgreSQL by PostgreSQL ODBC Driver]
Date
Msg-id 20161117130323.q6yh5xjyde53gigd@alvherre.pgsql
Whole thread Raw
List pgsql-odbc

Dear pqsql-odbc,

After I’m download Lasted update PostgreSQL ODBC Driver from link https://www.postgresql.org/ftp/odbc/versions/msi/

I’m Create DSN to connection PostgreSQL Db by PostgreSQL ODBC Driver 32 bit see version 9.05.04.00 as below:

 

After create user DSN from ODBC Data Source Administrator (32bit) on Window success

 

I’m try test this DSN on Microsoft SQL Server Reporting Service (Report Builder 3.0)

Connection by ODBC and reference to DNS name

I can get result after execute Query Designer And have more record return to grid view result see as below:

 

 

 

but after I design repot success and run report have some error

 

 

I’m not sure this version for PostgreSQL ODBC Drive is correct or not

Or you have some suggestion for this problem to my team

 

Best regards,

Pongsiri Kongpreepun

Thank you.

 

 

Attachment

pgsql-odbc by date:

Previous
From: Nathan Kendall
Date:
Subject: Re: Daylight saving time rules being applied to DateTimes that don't have a timezone
Next
From: Mateusz Loskot
Date:
Subject: Binding time and timestamp with time zone data type