RE: FN-FORUM:

date posted 8th August 2004 13:10

A google search indicated that your line should have worked, perhaps the
literal is case sensitive

i.e. try set language british





-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
WHITTAKER
Sent: 08 August 2004 13:03
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM:



Hi,

I am getting


Microsoft OLE DB Provider for SQL Server error '80040e07'
The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value

when I use convert(datetime in my sql statement

I have tried putting the following infront of the sql statemt


SET LANGUAGE = British
GO


But I then get

Microsoft VBScript runtime error '800a01a8'
Object required: 'British'


Help - what am I going wrong. I have also tried English aswell


Thanks
Pam










--
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html