linking postgre sql into sql 2005

• seenu_61281

  Old Hand

  Points: 335

  More actions

  June 13, 2008 at 8:16 am

  #121967

  iam using sql server 2005 express edition. i have to link the postgre sql from sql.i tried "spaddlinkedserver".this successfully executed but when i try for select query this shows cannot create initialization error....is there anyway?? if so pls explain it detail...

  (i succeeded with ms access)

  help me

• JamieX

  Hall of Fame

  Points: 3763

  More actions

  June 13, 2008 at 10:40 am

  #828660

  Get the ODBC Driver

  http://www.postgresql.org/ftp/odbc/versions/msi/

  then setup a standard ODBC link to your system DSN you create

  http://msdn.microsoft.com/en-us/library/ms190479.aspx

  I've never done it for this DB before, but works fine for other ODBC sources.