Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
Shopping Cart Software Forum for Ecommerce Templates
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?



Find us on Facebook

Follow us on Twitter

View our YouTube channel


 All Forums
 Technical
 ASP (Windows server) versions
 Site Crashed ODBC Drivers error '80040e07
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

75665
Starting Member

United Kingdom
6 Posts

Posted - 06/13/2018 :  05:22:00  Show Profile
Help!

I used the .asp updater yesterday and started creating the site thereafter. All was working fine yesterday however, when I tried to log onto my control panel today I got the following error (http://www.acornmonitoring.co.uk/catalogue/vsadmin/login.asp);

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

/catalogue/vsadmin/inc/incfunctions.asp, line 2315



I also noticed that when clicking to view cart or products and categories from home page header is causing further errors (homepage is acornmonitoring.co.uk/catalogue);

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

/catalogue/vsadmin/inc/inccategories.asp, line 160

I have tried to re-run the updater since but the problem was not fixed. I am using the ASP version on a 2014 SQL Server. Google troubleshooting points me in the direction of differences between date and time formats used by the software and the SQL Server.

Please can you provide me with some support for fixing the issue?



Chris Cowen

Edited by - 75665 on 06/13/2018 06:20:33

Andy
Administrator

93118 Posts

Posted - 06/13/2018 :  06:27:57  Show Profile
Hi Chris

Did you do anything between it working and not working? It sounds like there are database issues but those don't usually happen without some changes somewhere. YOu didn't run the sql wizard updatestore.asp file again or something like that did you?

Andy

Please feel free to review / rate our software
Go to Top of Page

75665
Starting Member

United Kingdom
6 Posts

Posted - 06/13/2018 :  08:03:49  Show Profile
Hi Andy,

I purchased and ran the updater in the morning, then spent 10 hours working on the catalogue with no problems, all was updating fine throughout.

I literally turned on the PC this morning and encountered these errors.

Chris Cowen
Go to Top of Page

Andy
Administrator

93118 Posts

Posted - 06/13/2018 :  08:16:04  Show Profile
That's really odd then, can you ask your host if there have been any server changes in the meantime - maybe something was altered on their end.

Andy

Please feel free to review / rate our software
Go to Top of Page

75665
Starting Member

United Kingdom
6 Posts

Posted - 06/13/2018 :  10:07:22  Show Profile
Hi Andy,

Our Database Hosts Winserve have come back with the following;

HI Chris,

We have not made any changes to your database or its server.
This is usually down to conflicting date/time formats.
Your DB user is set to British English , so date/times inserted into it should be in that format.



Chris Cowen
Go to Top of Page

Andy
Administrator

93118 Posts

Posted - 06/13/2018 :  10:16:38  Show Profile
You can set this includes.asp so it uses the UK date format in the admin / database

admindateformat=2

Andy

Please feel free to review / rate our software
Go to Top of Page

75665
Starting Member

United Kingdom
6 Posts

Posted - 06/13/2018 :  10:29:14  Show Profile
Ok it makes sense to change to the UK format, but I cannot log into the control panel to change anything through admin.

Please can you elaborate where I will find this setting to change within the data files?

Thanks

Chris Cowen
Go to Top of Page

Andy
Administrator

93118 Posts

Posted - 06/13/2018 :  11:41:07  Show Profile
That would go in vsadmin/includes.asp rather than through the admin. You can edit the file in a text editor.

Andy

Please feel free to review / rate our software
Go to Top of Page

75665
Starting Member

United Kingdom
6 Posts

Posted - 06/14/2018 :  07:01:17  Show Profile
Andy,

Unfortunately uploading the admindateformat=2 did not solve the problem.

To rule out any corruption with this databse on the sql2014 server. I have started afresh by uploading a completely new eCommerce template blank catalogue upto our host using their sql 2016 server.

So when I run the script at /updatestore.asp, the script is getting stuck midway through the upload with the following error;

Done creating database tables.
Starting to populate database.
Adding admin table data
Adding alternaterates table data
Adding cart table data
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

/catalogue/updatestore.asp, line 1016
connection also with admindateformat=2 within includes.asp.


I have tried to run the script both with and without admindateformat=2 but this does not resolve the problem.




Chris Cowen

Edited by - 75665 on 06/14/2018 07:22:08
Go to Top of Page

Andy
Administrator

93118 Posts

Posted - 06/14/2018 :  07:28:22  Show Profile
Do you have access to the database tables in your hosting control panel? It does indeed seem to be a problem with the UK date formatting but I haven't seen it come up here before. I'm also unclear why it suddenly started happening on your store

Andy

Please feel free to review / rate our software
Go to Top of Page

75665
Starting Member

United Kingdom
6 Posts

Posted - 06/14/2018 :  07:37:50  Show Profile
Andy,

No I cannot access the data tables in on the SQL servers. They do have a mySQL database availability which you can access the tables but everything purchased so far from yourselves is for the ASP version.

I'm also confused as to why this issue arose but surely your templates work on UK servers?


Chris Cowen
Go to Top of Page

Andy
Administrator

93118 Posts

Posted - 06/14/2018 :  10:13:05  Show Profile
The software works fine on UK servers and I haven't seen this error before. I have just followed up by email.

Andy

Please feel free to review / rate our software
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2018 ecommercetemplates.com Go To Top Of Page
This page was generated in 0.03 seconds. Snitz Forums 2000