| Author |
 Topic  |
|
|
freexel
Starting Member
Netherlands
6 Posts |
 Posted - December 10 2009 : 06:03:43
|
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
4679 Posts |
Posted - December 10 2009 : 06:33:55
|
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 |
 |
|
|
MBroekman
Starting Member
Netherlands
1 Posts |
Posted - December 10 2009 : 11:18:59
|
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 |
|
|
|
support
Administrator
4679 Posts |
|
|
Mark Priest
VP-CART Expert
United Kingdom
580 Posts |
Posted - September 06 2010 : 21:32:04
|
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 |
|
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - October 27 2010 : 04:24:45
|
I think latest v7 update pack need your server to use MYSQL 5.1 ODBC driver instead.
Diego. |
|
|
|
answerman
Starting Member
USA
23 Posts |
Posted - October 24 2012 : 15:26:03
|
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 |
|
|
|
devshb
Senior Member
United Kingdom
1904 Posts |
Posted - October 24 2012 : 15:34:19
|
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 |
|
|
|
answerman
Starting Member
USA
23 Posts |
Posted - October 24 2012 : 17:11:41
|
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. |
|
|
| |
Topic |
|
All Forums
shopcms.asp, line 799 Error VPASP700
New Topic
Printer Friendly
TrustGuard - PCI Security Scanner
