If you are trying to create User DSN/ System DSN in ODBC drivers and suddenly you found that ODBC driver string is missing.
When you want to connect any third party tool with postgres SQL database, you have to create odbc DSN.
Installing the PostgreSQL ODBC drivers:
way 1:
Download msi package to install odbc from below link
http://www.postgresql.org/ftp/odbc/versions/msi/
Unzip the package and let it install and finish.
way 2:
Download postgres db package
after installation it will ask for
"Stack builder and additional tools" - check this option and select add-on package "jdbc".
image 1 - machine not have postgres odbc driver
Installing the PostgreSQL ODBC drivers:
way 1:
Download msi package to install odbc from below link
http://www.postgresql.org/ftp/odbc/versions/msi/
Unzip the package and let it install and finish.
way 2:
Download postgres db package
after installation it will ask for
"Stack builder and additional tools" - check this option and select add-on package "jdbc".
I think one should always try to maximize the use of PostgreSQL and SSIS operations as much as possible.There is actually a genuine need to look for such tools.
ReplyDeleteSSIS Postgresql Write
I guess this is a very informative and useful blog post about the happenings of Postgre SQL and many other related concepts as well.Its functionalities and usages are well justified.
ReplyDelete