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-ASP Shopping Cart Customer Forum

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

 All Forums
 VPCart Forum
 Problems and bugs
 shopcms.asp, line 799 Error VPASP700
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

freexel
Starting Member

Netherlands
6 Posts

Posted - December 10 2009 :  06:03:43  Show Profile  Reply with Quote
I do the upgrade 6.5 --> 7.0 end i've got this error:

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

ODBC driver does not support the requested properties.

/shopcms.asp, line 799

Who can help me solving this problem?

I use mysql server.

support
Administrator

4266 Posts

Posted - December 10 2009 :  06:33:55  Show Profile  Visit support's Homepage  Reply with Quote
Hi there

If possible can you post this in our helpdesk so our support guys can look at it straight away for you.

https://helpdesk.vpasp.com

Thanks
Cam

VPASP Support
Go to Top of Page

MBroekman
Starting Member

Netherlands
1 Posts

Posted - December 10 2009 :  11:18:59  Show Profile  Visit MBroekman's Homepage  Reply with Quote
During installation for SQLServer 2000 the following tables are not created:

Blogs, news and content. This is caused by the varchar (max) definition, as far as i've looked there is not conversion done in the installation therefor the creation of those tables faile. There is no warning or failure during installation.

On SQLServer 2005 is creates those table just fine.

I have not experience with mysql but it's just a hint where to look

Edited by - MBroekman on December 10 2009 11:20:12
Go to Top of Page

support
Administrator

4266 Posts

Posted - December 10 2009 :  23:38:18  Show Profile  Visit support's Homepage  Reply with Quote
Hi there

We have posted an update to this at:

http://helpnotes.vpasp.com/shopexd.asp?id=958#958

Hope this helps

Thanks
Cam

VPASP Support
Go to Top of Page

Mark Priest
VP-ASP Expert

United Kingdom
570 Posts

Posted - September 06 2010 :  21:32:04  Show Profile  Reply with Quote
Hi All,

Just got round to installing 7, upgrading with all my mods is going to be a mammoth task.

Admin seems to be working fine, however im getting the following error on my home page.

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

ODBC driver does not support the requested properties.

/store/shopcms.asp, line 817


Im using MySQL 3.51

Regards,

Mark
Fireworks
Go to Top of Page

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - October 27 2010 :  04:24:45  Show Profile  Reply with Quote
I think latest v7 update pack need your server to use MYSQL 5.1 ODBC driver instead.

Diego.
Go to Top of Page

answerman
Starting Member

USA
23 Posts

Posted - October 24 2012 :  15:26:03  Show Profile  Visit answerman's Homepage  Reply with Quote
Sorry to resurrect an old thread, but Mark's post describes my dilemma exactly. I am getting the same error on the home page. I am using MySQL 5.10 though, so that's not the problem.

This is on an upgrade from 6.50 to 7.02. The steps I took to upgrade were to back up the DB, copy the install to a new directory, and run the wizard. So, all the files are new (not overwriting the old) but the DB was upgraded.

Edited by - answerman on October 24 2012 15:28:20
Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - October 24 2012 :  15:34:19  Show Profile  Visit devshb's Homepage  Reply with Quote
I had this problem too; I changed the mysql type in vpasp to 3.5 (even though the database itself was 5.1), ie so that it used the old driver, and then it worked ok. I assume that the host simply didn't have an up to date driver installed on the server.

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
www.BigYellowKey.com
Follow us on Twitter: http://twitter.com/bigyellowzone
Web Design, Online Marketing and VPASP addons
Go to Top of Page

answerman
Starting Member

USA
23 Posts

Posted - October 24 2012 :  17:11:41  Show Profile  Visit answerman's Homepage  Reply with Quote
Thanks Simon... but I definitely do have the 5.1 driver installed. I'm using it on a few other sites. I am the hosting company in this case, so I'm not at the whim of someone else from this standpoint.

Still looking for an answer as to what the problem actually is being caused by. I may have to burn a support ticket on this.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000