Hi, I have the same problem with same OS and middleware. I just convert the bit columns to integer to get them right. Also text columns don't work. They can be converted to varchar provided that they are not too long.
I haven't had the time (and proficiency) to study odbc.ijs. Esa -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Cox, Ed Sent: 16. kesäkuuta 2010 4:02 To: [email protected] Subject: [Jprogramming] SQL Server Bit datatype not working with ODBC I'm finding that bit data types are not being returned correctly via ODBC from SQL Server. I've tried two different drivers (Driver={SQL Server} and Driver={SQL Native Client}). If I run a query that should return 20 rows of just a single bit field and unbox it the shape is 1 20 0, which looks like the 1 character data is somehow getting lost. I've tried to understand odbc.ijs but have only gotten so far. I'm better at writing my own code than understanding someone else's. I've looked in the forum but did not see anything similar to this issue being discussed. Has anyone else run into this? I am using J602 on Windows XP. Ed Cox Principal Data Analyst [email protected] _________________________________________________ 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 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
