RE: Linked server data length issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Erland, I'm linked to a Postgres DB. I've pulled many other queries through
Openquery and never had this issue until now. Thanks for your help!

Anthony

"Erland Sommarskog" wrote:

Anthony (Anthony@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Linichi, thanks for your response. I've tried cast the field to a
varchar or nvarchar and I get the following error: The provider reported
an unexpected catastrophic failure."

Here is the code I'm using: select * from Openquery (Linked Server,
'Select cast(long_description as nvarchar) from
hierarchy_account_detail').

What RDBMS is on the other end of the line?

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Dynamic Query
    ... speciality1 = MIN, ... This is the standard way of running a pivot in SQL Server. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: Autostatistic ON/OFF on separate tables?
    ... "Erland Sommarskog" wrote in message ... This means that autostats do not set in very often on these tables. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 SP4 fails to install
    ... core CPU x64 processors ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.setup)
  • Re: Filtering a voter?
    ... "Erland Sommarskog" wrote: ... >> I'm a complete novice with SQl, I'm completely self taught I have not ... you don't have to include the entire database. ... > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
    (microsoft.public.sqlserver.programming)
  • Re: 15408 Revert Session Security Context"
    ... SqlBinary denyValue, SqlString userGroups, SqlBoolean mergeRights) ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)