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 Account Setup Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

12 Posts

Posted - April 28 2007 :  23:14:17  Show Profile  Visit deboriole's Homepage  Reply with Quote
I am a new member and I am having a problem setting up my shopping cart. I was able to connect to the database but now when I go to http://www.bodemi.com/vpasp/ to begin customization, I get this error:

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

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'by'.

D:\HOSTING\APPRILLE\VPASP\../vpasp/shopproductsubs.asp, line 353

I am fairly new to SQL Server and I can't figure out how to fix this. Can anyone help?

Edit: When I changed my database type to ODBC I got the same error as in this thread: http://www.vpasp.com/virtprog/vpaspforum/topic.asp?TOPIC_ID=6735 Does this mean I should be using ODBC?

Thank you so much,


Edited by - deboriole on April 28 2007 23:25:10

Senior Member

United Kingdom
1898 Posts

Posted - April 28 2007 :  23:35:21  Show Profile  Visit devshb's Homepage  Reply with Quote
it looks like your "xsortcategories" config option might be blank....

if you login to the vpasp admin area on your site, go into site-setup, and search for:

then set that value to:


then you should be ok

Simon Barnaby
Web Design, Online Marketing and VPASP addons

Edited by - devshb on April 28 2007 23:36:11
Go to Top of Page

Starting Member

12 Posts

Posted - April 29 2007 :  00:09:10  Show Profile  Visit deboriole's Homepage  Reply with Quote
Hi Simon,

Thanks, I'm not sure how but it's fixed. :)


Edited by - deboriole on April 29 2007 00:37:18
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000