Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 VP-ASP 6.00 Questions
 SQL Database on a Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Cara Rees
Starting Member

Australia
36 Posts

Posted - February 07 2007 :  22:04:35  Show Profile  Visit Cara Rees's Homepage  Reply with Quote
Hi,
Can anyone tell me if the hosting server of a site needs a SQL Database to run VP ASP.

Kind regards
Cara

elammers
VP-CART Super User

USA
256 Posts

Posted - February 08 2007 :  07:48:37  Show Profile  Visit elammers's Homepage  Reply with Quote
Your hosting provider needs to provide some sort of database support. Your options for VP-ASP are: Access, MySQL, or MS SQL. Usually, Access or even MySQL are the the freebies that come with most hosting plans.



Regards,

Eric in Maine
Go to Top of Page

devshb
Senior Member

United Kingdom
1904 Posts

Posted - February 09 2007 :  03:19:22  Show Profile  Visit devshb's Homepage  Reply with Quote
my advice would be to use either access or sqlserver (mssql), as mysql is essentially a unix/linux database and asp is essentially a windows language, so find a host that uses windows as its operating system, and which lets you use access (for smallish databases) or sqlserver (mssql) for larger databases.

webecs.com hosts are very good; we use them and haven't had any problems despite running lots of instances (test carts etc) across various domains.

if using sqlserver (mssql) then you won't personally need to buy sqlserver itself for your pc/site; instead you'd just "rent" it from the host, usually paid for as part of your monthly hosting plan. try to pick a host which has a web-based front end for sqlserver (webecs include/use one), so that you don't have to install enterprise manager to gain direct access to the database.

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on February 09 2007 03:22:14
Go to Top of Page

rvaga
VP-CART Super User

USA
254 Posts

Posted - February 09 2007 :  12:29:28  Show Profile  Reply with Quote
Just adding on to what Simon covers above. . .

At this point, if using SQL make sure and sign up for SQL2000, not SQL2005. The only reason to use SQL2005 is if you have extremely long descriptions or extended descriptions. And if you do use SQL2005, be prepared for some somewhat weird problems (like templates not working, edit fields blank on product update screen, etc.).
Go to Top of Page

devshb
Senior Member

United Kingdom
1904 Posts

Posted - February 09 2007 :  15:13:53  Show Profile  Visit devshb's Homepage  Reply with Quote
ah, yes, I forgot about that; the technical reason behind that is that sqlserver has a recordset restriction of around 8k (that 8k restriction is a complex calculation, using column-definition logic and data content, it's not just a simple how-much-data-in-the-record restriction, or a how-long-is-the-table-definition restriction)

sql2000 has the same problem as sql2005, but the difference is that with sql2000 you'll get a proper error message if your data/table reaches the limit and it won't corrupt the data, whereas with sql2005 it'll just start blanking out the vbscript variables with no warning and will therefore corrupt the data if it reaches the limit.

we've actually created a generic check-row-size script for sqlserver which will check your tables/data to see if you're anywhere near the limit; if anyone wants it then let us know and we'll speed up the release/packaging-up of that script.

whether or not you are effected by that problem will depend on a combination of what version of vpasp you're on (ie the precise column definitions/order in the products table), and the data content in your products table.

as per all other microsoft problems, microsoft don't call it a bug, they call it a restriction/feature.

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on February 09 2007 15:34:02
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00