It might be worth looking at the connection settings in SQL studio. SQL studio by default will truncate long fields, which may be hiding row size limitations. If you bump up the field length limit in SQL studio and it still works, that would point even more strongly to JDBC.
Jaime On Fri, Nov 20, 2009 at 8:37 AM, A D <alandeans2...@yahoo.co.uk> wrote: > > Its works ok using SQL managment studio. > > Doesnt work from eclipse RDS or CF. > > >> Its around 40 columns - none of them text or ntext. > >> > >> ... > >> > >> Selecting the 40 colums results in the same, but selecting a few columns > is ok. > > > >I suspect you're hitting some sort of row length limitation in the > >JDBC drivers. Are you able to select an entire row from a native SQL > >Server client? > > > >Dave Watts, CTO, Fig Leaf Software > >http://www.figleaf.com/ > > > >Fig Leaf Software provides the highest caliber vendor-authorized > >instruction at our training centers in Washington DC, Atlanta, > >Chicago, Baltimore, Northern Virginia, or on-site at your location. > >Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4