I am trying to create a linked server from my SQL server 2000 box to a LINIX box running a microfocus cobol written application. I am using a OLE DB Provider for ODBC Driver, and when I run a DTS package, everything comes across fine. However, why I try to query directly to the linked server, I get the following message:
Server: Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL].LST_NAM'. The expected data length is 14, while the returned data length is 9.
I have searched Microsoft's knowledge base, and the consider it a known bug for C++, SQL 2000, etc, but it doesn't mention how to fix it for SQL 2000.
http://support.microsoft.c
Any help would be greatly appreciated.
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: bhess1Posted on 2002-09-20 at 11:45:45ID: 7295189
Unfortunately, this is a provider error (returning incorrect information / data) rather than explicitly an ADO or MS error.
What is almost certainly happening: Your ODBC provider is trimming off the trailing spaces on a fixed-length field when it is being returned. Check the provider documentation - can it be configured to return the fixed-length fields space padded (as MS expects)? Or, is there an update to the ODBC driver that returns information in this case correctly?
There are a number of comments about this on Google Groups, and all come to the same basic conclusion - a difference between what is expected of a fixed-length field, and what is returned.