prob with SQL script that work with Date/Time abd boolean

[m_peled]

I convert my DB from Access to SQL Server ,

When i try to run my script (in ASP) it's not store the data at
Date/Time field!!!
And i have troble with insert the value TRUE in Sql Server (it's work
with access)

I want to know if i need to change my scripts(in ASP) or the type of
fields?

Please, Help

Best regards.

[Simon Hayes]

<m_*****@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I convert my DB from Access to SQL Server ,

When i try to run my script (in ASP) it's not store the data at
Date/Time field!!!
And i have troble with insert the value TRUE in Sql Server (it's work
with access)

I want to know if i need to change my scripts(in ASP) or the type of
fields?

Please, Help

Best regards.

This article about Access to MSSQL migration covers which data types to use
for true/false and date/time data:

http://www.aspfaq.com/show.asp?id=2214

If you still have problems, you should probably post specific examples of
your problem data, along with any error messages you get when you try to
INSERT them into the MSSQL database.

Simon

[Dishan Fernando]

change true/false to 1/0. Whats the date time format that u insert>?