An update for whom may be interested.

The SQL server is a clustered server. The main server was failed over to the backup server in the cluster.

When the servers were failed over and later back to the primary data, the DRDA connection dropped and could not reconnect.

Found DRDA is linked to the DDM server on the IBMi. Shutdown the DDM server and restarted it and all worked again.

I cannot explain the shortened column names save to think it was cached. Eventually nothing worked forcing us to look at the IBMi where we found the issue tracing traffic on port 446 (DRDA).


Sent from my iPad

On Sep 9, 2015, at 2:03 PM, Darryl Freinkel <dhfreinkel@xxxxxxxxx> wrote:

Has anyone experienced the problem of column names being restricted to 40 characters when using linked servers ( ms SQL)?

It worked for months until today....

TIA

Darryl

Sent from my iPad

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].