Author |
Topic |
|
Cara Rees
Starting Member
Australia
36 Posts |
Posted - February 07 2007 : 22:04:35
|
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
|
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 |
|
|
devshb
Senior Member
United Kingdom
1904 Posts |
Posted - February 09 2007 : 03:19:22
|
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 |
|
|
rvaga
VP-CART Super User
USA
254 Posts |
Posted - February 09 2007 : 12:29:28
|
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.). |
|
|
devshb
Senior Member
United Kingdom
1904 Posts |
Posted - February 09 2007 : 15:13:53
|
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 |
|
|
|
Topic |
|