SQL Server and Informix
Posted in 2008
Environment:
HP-UX 11.11
Windows 2003 sp2
IDS 9.40FC7
SQlServer 2005
SDK 3.00TC1
Issue:
Cannot select data from Informix when column is greater than 291 bytes.
I created an Informix table called jerry_comments:
create table "psoft8".jerry_comments
(
report_name char(30) not null ,
fiscal_year smallint not null ,
accounting_period smallint not null ,
fh_report_section char(30) not null ,
group_id char(15) not null ,
seq_nbr decimal(15,0) not null ,
comment_text char(250) not null ,
comments char(292)
) in frpapp extent size 16 next size 16 lock mode row;
revoke all on "psoft8".jerry_comments from "public";
The select from SQL Server looks like:
select * from openquery (fsdev82, 'select * from jerry_comments')
The error looks like:
Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the
server. (provider: Shared Memory Provider, error: 0 - No process is on
the other end of the pipe.)
The select will work if I change the comments field to anything less
than 292 bytes.
We also tested reading from one SQLServer database to another SQLServer
database with the comments column greater than 292 and it works fine for
any size...
Anyone else have an issue trying to read more than 291 bytes into SQL Server?