Knowledgebase

Question

I want to use CactuShop v5.x with MS SQL 2005 Express. Is this possible?

Answer

Yes. The database setup script should work fine with SQL 2005. Some field types may change in future versions, but the current .sql scripts have been tested and verified to work fine with 2005 and we run several web sites successfully using it.

The standard config.asp in v5.x contains MS SQL connection code for older versions but this should also work fine with MS SQL 2005.

Alternatively you can use the new MS SQL 2005 provider instead by using this connection string:

CONST strDataSourceName = "Provider=SQLNCLI;Server=s;Database=d;UID=u;PWD=p;"

(should be all on one line)

's' = server name (e.g. MYSERVER/SQLEXPRESS)
'd' = database name
'u' = login/username
'p' = password

Can't find the answer you need? Click here to open a support ticket.