Combobox & BIT field @ different sql server (english & spanish)

[kolorasta]

Hi.
I have 2 SQL servers
SQL Server 2005 Express (english) for development
SQL Server Enterprise (spanish) for production

I have a combobox for a BIT field
The combobox rowsource is false;"No";true;"Si"
The combobox shows "No" and "Si" (no & yes in spanish) and stores False or True respectivily in the associated db field.

This works fine in the development server, but not in the production one.
It's like if there is a language problem.
I tried to store 0 and 1 in the field but neither the dev or prod server allows it.

How can i solve it? how do i have to ser the combobox rowsource to work correctly in both servers.

sorry for my poor english

 

[Brian1960]

BIT field

Make sure that in you development server very record with a BIT field has value. SQL Server does not allow Null values in a BIT field (0 or 1).