| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Cc: | Pongsiri Kongpreepan <pongsiri(at)ttei(dot)toshiba(dot)co(dot)th> |
| Subject: | [pongsiri@ttei.toshiba.co.th: Test Connection to PostgreSQL by PostgreSQL ODBC Driver] |
| Date: | 2016-11-17 13:03:23 |
| Message-ID: | 20161117130323.q6yh5xjyde53gigd@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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:
[cid:image003(dot)jpg(at)01D240C6(dot)E1567E50]
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:
[cid:image005(dot)jpg(at)01D240C6(dot)E1567E50]
but after I design repot success and run report have some error
[cid:image007(dot)jpg(at)01D240C6(dot)E1567E50]
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Germán Valdez | 2016-11-20 19:49:10 | Re: error conection Provider=MSDASQL |
| Previous Message | Adrian Klaver | 2016-11-17 00:04:24 | Re: Daylight saving time rules being applied to DateTimes that don't have a timezone |