TrevorC
|
| Posted: 01/29/2004, 5:05 AM |
|
Hi all
I'm new to this. I'm using CCS2.2.3.60 with ASP and MSSQL2000 on a
Windows2000 server.
We are having problems with SQL datetime errors:
"The conversion of datetime string to character format generated an out of
range error"
The strange thing is it doesn't happen everywhere on the site. It even
doesn't happen on every SQL server (OR MSDE) installation - even when using
the same Dataset.
We have the CCS project setup as:
Date display format: GeneralDate
In the connection settings: dd/mm/yyyy hh:mm:ss with a
tick in "Same as design"
Date fields on forms are setup as: dd/mm/yyyy with nothing in
DBFormat.
If I change the DBFormat to yyyy-mm-dd it makes matters
worse.
The SQL Server says the default (installed) language is US English, and
there doesn't seem to be a way to change this globally. Besides I may
install things on an existing SQL server, where I do not have the right to
change the settings... I need the ASP side to work with US or UK date
formats.
I was led to believe that SQL inserts could be done with a "standard" date
format that worked on ALL regional settings: i.e. yyy-mm-dd (in the SQL
statement)
Can anyone advise?.... there is also embed code to the site for SQL Inserts,
so it is not just a CCS builder/design issue, I need to know how to handle
the SQL embed code too.
--
Regards,
Trevor Cocks
Managing Director
Data Design Services Ltd
Email:trevor.cocks@ddssoftware.co.uk
Web: www.ddssoftware.co.uk
Developers of printing MIS system using Clarion 5 and C5.5EE.
Templates: DEF, CPCS, RPM, AFE, WinfaxDDE, AppAssist ( my own),
SuperTag,SuperQBE,SuperInvoice,QuickDDE
ViewWizard, QueryWizard,ReportWizard, Allerup, Prodomus PDTP+, FM2, EzHelp,
Hyperactive, File explorer, Tearoff
Insight, Nettalk, Variview, Wordspell, GREG, GCal, GCalc, GNotes,
HandyTools, LSZIP, Clarionet, Mail & Fax
Timesavers, SysTrack, Sysani, SysHotKey, SysDTP, SysMonthcal
Ultratree & CpTracker
|
|
|
 |
DonB
|
| Posted: 01/29/2004, 9:57 AM |
|
wild guess - you have the field set to something other than "Date" (either
in CCS or in the database). Apparently SQL Server is getting a string and
failing to properly coerce the data into a date value.
--
DonB
http://www.gotodon.com/ccbth
"TrevorC" <trevor.cocks@ddssoftware.co.uk> wrote in message
news:bvb0f5$qnk$1@news.codecharge.com...
> Hi all
>
> I'm new to this. I'm using CCS2.2.3.60 with ASP and MSSQL2000 on a
> Windows2000 server.
>
> We are having problems with SQL datetime errors:
>
> "The conversion of datetime string to character format generated an out of
> range error"
>
> The strange thing is it doesn't happen everywhere on the site. It even
> doesn't happen on every SQL server (OR MSDE) installation - even when
using
> the same Dataset.
>
> We have the CCS project setup as:
>
> Date display format: GeneralDate
> In the connection settings: dd/mm/yyyy hh:mm:ss with
a
> tick in "Same as design"
>
> Date fields on forms are setup as: dd/mm/yyyy with nothing in
> DBFormat.
>
> If I change the DBFormat to yyyy-mm-dd it makes matters
> worse.
>
> The SQL Server says the default (installed) language is US English, and
> there doesn't seem to be a way to change this globally. Besides I may
> install things on an existing SQL server, where I do not have the right to
> change the settings... I need the ASP side to work with US or UK date
> formats.
>
> I was led to believe that SQL inserts could be done with a "standard" date
> format that worked on ALL regional settings: i.e. yyy-mm-dd (in the SQL
> statement)
>
> Can anyone advise?.... there is also embed code to the site for SQL
Inserts,
> so it is not just a CCS builder/design issue, I need to know how to handle
> the SQL embed code too.
>
> --
> Regards,
>
> Trevor Cocks
> Managing Director
> Data Design Services Ltd
> Email:trevor.cocks@ddssoftware.co.uk
> Web: www.ddssoftware.co.uk
>
> Developers of printing MIS system using Clarion 5 and C5.5EE.
> Templates: DEF, CPCS, RPM, AFE, WinfaxDDE, AppAssist ( my own),
> SuperTag,SuperQBE,SuperInvoice,QuickDDE
> ViewWizard, QueryWizard,ReportWizard, Allerup, Prodomus PDTP+, FM2,
EzHelp,
> Hyperactive, File explorer, Tearoff
> Insight, Nettalk, Variview, Wordspell, GREG, GCal, GCalc, GNotes,
> HandyTools, LSZIP, Clarionet, Mail & Fax
> Timesavers, SysTrack, Sysani, SysHotKey, SysDTP, SysMonthcal
> Ultratree & CpTracker
>
>
|
|
|
|
Edd
Posts: 547
|
| Posted: 01/29/2004, 1:24 PM |
|
Trevor,
I had a similar problem at a site a year ago when the Server Date format (in the control panel) was set back to the US MM/DD/YYYY format.
The only things that keeps me out of hot water all the time is using the short date for all of my displays and 'YYYY-MM-DD' for calling parameters.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
|
Ferruccio
|
| Posted: 02/01/2004, 5:55 AM |
|
Check the date format property for your connection. That solved me the same problem.
|
|
|
|
Nagaraj Dandey
|
| Posted: 02/03/2004, 9:24 PM |
|
HAi!!!!!!
|
|
|
|
|
