Den 2011-06-20 19:06 skrev Ryan Rajpaul såhär: > I am unable to get data using linked server from SQL SERVER 2008 R2 x64 > to Firebird ODBC Firebird_ODBC_2.0.0.151_x64 driver. Getting the error > below. Can you give me any suggestions to fix the error even in source > code I will recompile if needed to fix this issue. > > Error Messages below > > String or binary data would be truncated. (.Net SqlClient Data Provider) > > Server Name: (local) > > Error Number: 8152 > > Severity: 16 > > State: 2 > > Procedure: sp_tables_ex > > Line Number: 41 > > Thanks
The error says that you're trying to put data into a field where it doesn't fit, e.g. a 20 character string in a varchar(15) column, or a too large number in a narrow integer column. Apart from that, we can't really help you unless you give us more info, regarding your schema and data and what you're trying to do (what data are you trying to select/update/insert...? Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
