Problem With Linked Server to Postgres. :(

• maharaj.narayanan

  Old Hand

  Points: 340

  More actions

  March 20, 2015 at 5:09 am

  #315855

  Hi All,

  I created a linked server in sql server to postgres database the connection was created successfully but when i try to run a query i get error

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Enumerate columns failed for LinkedServer 'PGRH'. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Enumerate+columns+LinkedServer&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  Cannot get the data of the row from the OLE DB provider "SQL Server" for linked server "(null)". Conversion failed because the data value overflowed the data type used by the provider. (Microsoft SQL Server, Error: 7346)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=7346&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  what do i do????