I seem to have found a way to make the TinyInt and Bit data types work in ODBC (with Windows XP and SQL Server). I am not entirely sure I understand why they work, so if anyone understands this enough to tell if this is a reliable fix it would be really appreciated.
Here is what I did. In ODBC.ijs, I modified the verb bindcol. It had the following lines originally: elseif. type e. SQL_BIT, SQL_TINYINT do. len=. 1 [ tartype=. SQL_DEFAULT (bname)=: (rows,len)$' ' I changed that to be: elseif. type e. SQL_BIT do. len=. 1 [ tartype=. SQL_TINYINT (bname)=: (rows,len)$0 elseif. type e. SQL_TINYINT do. len=. 1 [ tartype=. SQL_INTEGER (bname)=: (rows,len)$2-2 _________________________________________________ This message is for the designated recipient only and may contain privileged, proprietary or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands - Norsk - Portuguese Svenska: www.cardinalhealth.com/legal/email ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
