VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

7 Posts

Posted - August 22 2006 :  09:06:17  Show Profile  Reply with Quote
Moving my site from Holland to UK, and am now getting various database errors, all seemingly centred around the date, e.g. try and add a tracking report, I get
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.

/shopping/shopa_trackingorder.asp, line 149

I've tried the vp-asp suggestion of setting xconvereteuropeannumbers to Yes, and updated the lcid bits in the files suggested, to no avail. Wherever I get this failure, it seems to be centred arounf the call to DateDelimit. Anyone else seen this issue, and can help, thanks

Starting Member

7 Posts

Posted - August 22 2006 :  17:33:42  Show Profile  Reply with Quote
For anyone else who has this problem it seems my SSL server didn't like the date format as '2006-08-23' as is set by the call to DateNormalize, so I just commented out this call and set newdate=indate, and it seems to work for me. i.e.

Function DateDelimit (indate)
dim datedelim, newdate
if ucase(xdatabasetype)="SQLSERVER" or getconfig("xmysql")="Yes" then
end if
dateDelimit = datedelim & newdate & datedelim
end function
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000