By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,414 Members | 1,586 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,414 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<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
Jul 23 '05 #2

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

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.