Thread: [ODBC] Need help to choose which ODBC driver to use
Hi,
I am quite new to PostgreSQL and I need some help to choose the ODBC driver to install on a new 64bit SQL server 2014 standard. It is on a Windows Server 2012 R2 OS that is recently set up.
I need to set up a ODBC Data Sources and link server on the SQL server to query data on a 64bit PostgreSQL 9.4.5 server. The PostgreSQL is on a 64bit Windows Server 2008 R2 Enterprise OS.
I go to this link
and download psqlodbc_09_06_0310-x64.zip
and install it on the SQL server. Then I go to Server Manager >Tools>ODBC Data Sources (64-bit) > System DSN
to create a new System Data Sources. When I click 'Test', it gives me an error message:
Fatal:password authentication failed for user "dnddev"
I create this new user and I tested the connection on another application so I know the password is correct.
Do I need to install an older version of ODBC driver on the SQL server? If so, which one I should use? I try to find something like psqlodbc_09_04_..... but I do not see one.
Thank you for the help.
Pang
On 05/24/2017 07:07 AM, Pui Yin Pang wrote: > Hi, > > I am quite new to PostgreSQL and I need some help to choose the ODBC > driver to install on a new 64bit SQL server 2014 standard. It is on a > Windows Server 2012 R2 OS that is recently set up. > > I need to set up a ODBC Data Sources and link server on the SQL server > to query data on a 64bit PostgreSQL 9.4.5 server. The PostgreSQL is on a > 64bit Windows Server 2008 R2 Enterprise OS. > > I go to this link > https://www.postgresql.org/ftp/odbc/versions/msi/ > > and download psqlodbc_09_06_0310-x64.zip > > and install it on the SQL server. Then I go to Server Manager > >Tools>ODBC Data Sources (64-bit) > System DSN > > to create a new System Data Sources. When I click 'Test', it gives me an > error message: > > Fatal:password authentication failed for user "dnddev" > > I create this new user and I tested the connection on another > application so I know the password is correct. Are you sure you are connecting to the same Postgres server in both cases? > > Do I need to install an older version of ODBC driver on the SQL server? > If so, which one I should use? I try to find something like > psqlodbc_09_04_..... but I do not see one. > > Thank you for the help. > > Pang -- Adrian Klaver adrian.klaver@aklaver.com
I think so. I only has one Postgresql server.
The other application I use to test the login is to create a new Access 2003 link table and I create a new ODBC connection and put in the same information as I did on the SQL server. It works.
The different most likely is the the ODBC drive version installed on the desktop is different from the one I am trying to install on the SQL server. The desktop is 32bit Windows 7 and I installed the ODBC probably two years ago. I do not remember the version I installed, probably related to 9.4. The bin is in a ProgramFiles\psqlODBC\0900 folder.
For the SQL server, I am get the driver from here:
Thanks,
Pang
On Wed, May 24, 2017 at 10:39 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 05/24/2017 07:07 AM, Pui Yin Pang wrote:Hi,
I am quite new to PostgreSQL and I need some help to choose the ODBC driver to install on a new 64bit SQL server 2014 standard. It is on a Windows Server 2012 R2 OS that is recently set up.
I need to set up a ODBC Data Sources and link server on the SQL server to query data on a 64bit PostgreSQL 9.4.5 server. The PostgreSQL is on a 64bit Windows Server 2008 R2 Enterprise OS.
I go to this link
https://www.postgresql.org/ftp/odbc/versions/msi/
and download psqlodbc_09_06_0310-x64.zip
and install it on the SQL server. Then I go to Server Manager >Tools>ODBC Data Sources (64-bit) > System DSN
to create a new System Data Sources. When I click 'Test', it gives me an error message:
Fatal:password authentication failed for user "dnddev"
I create this new user and I tested the connection on another application so I know the password is correct.
Are you sure you are connecting to the same Postgres server in both cases?--
Do I need to install an older version of ODBC driver on the SQL server? If so, which one I should use? I try to find something like psqlodbc_09_04_..... but I do not see one.
Thank you for the help.
Pang
Adrian Klaver
adrian.klaver@aklaver.com
Hi Adrian and All,
I just found my error on the new account. I am all set.
Thank you very much.
Pang
On Wed, May 24, 2017 at 11:39 AM, Pui Yin Pang <puiyin.pang@boston.gov> wrote:
I think so. I only has one Postgresql server.The other application I use to test the login is to create a new Access 2003 link table and I create a new ODBC connection and put in the same information as I did on the SQL server. It works.The different most likely is the the ODBC drive version installed on the desktop is different from the one I am trying to install on the SQL server. The desktop is 32bit Windows 7 and I installed the ODBC probably two years ago. I do not remember the version I installed, probably related to 9.4. The bin is in a ProgramFiles\psqlODBC\0900 folder.For the SQL server, I am get the driver from here:Thanks,PangOn Wed, May 24, 2017 at 10:39 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:On 05/24/2017 07:07 AM, Pui Yin Pang wrote:Hi,
I am quite new to PostgreSQL and I need some help to choose the ODBC driver to install on a new 64bit SQL server 2014 standard. It is on a Windows Server 2012 R2 OS that is recently set up.
I need to set up a ODBC Data Sources and link server on the SQL server to query data on a 64bit PostgreSQL 9.4.5 server. The PostgreSQL is on a 64bit Windows Server 2008 R2 Enterprise OS.
I go to this link
https://www.postgresql.org/ftp/odbc/versions/msi/
and download psqlodbc_09_06_0310-x64.zip
and install it on the SQL server. Then I go to Server Manager >Tools>ODBC Data Sources (64-bit) > System DSN
to create a new System Data Sources. When I click 'Test', it gives me an error message:
Fatal:password authentication failed for user "dnddev"
I create this new user and I tested the connection on another application so I know the password is correct.
Are you sure you are connecting to the same Postgres server in both cases?--
Do I need to install an older version of ODBC driver on the SQL server? If so, which one I should use? I try to find something like psqlodbc_09_04_..... but I do not see one.
Thank you for the help.
Pang
Adrian Klaver
adrian.klaver@aklaver.com