Re: BUG #9182: Data type (text) issue with MS SQL 2012

On 11.2.2014 03:27, RogerBerkelmans(at)arlcollect(dot)com(dot)au wrote:
> The following bug has been logged on the website:
>
> Bug reference: 9182
> Logged by: Roger
> Email address: RogerBerkelmans(at)arlcollect(dot)com(dot)au
> PostgreSQL version: 9.3.1
> Operating system: Windows server 2008R2
> Description:
>
> we have a SMS system taht is using a pg-database. we connect the database by
> ODBC to a linked server to a MS SQL 2012
> sehen running a select query from the MS SQL 2012 on the pg-database and the
> data type of the column is a text we get the following error:
> OLE DB provider "MSDASQL" for linked server "linked server name" returned
> message "Requested conversion is not supported.".
> Msg 7341, Level 16, State 2, Line 1
> Cannot get the current row value of column "[linked server
> name]...[inbox].ABC" from OLE DB provider "MSDASQL" for linked server
> "linked server name".

Apparently your bug report is about MS SQL Server, while this list is
about PostgreSQL. So you'll have to report the issue somewhere else, I'm
afraid.

regards
Tomas