certain SQL statements since there are subtle differences in places for each 

database. 

7.3.1.2 strDataSourceName 

Two sample strings are supplied, for either MS Access or MS SQL Server. 

These will obviously need to be edited to reflect the name of your database, 

machine name and/or password. You can also setup your database as an 

ODBC (Open Database Connectivity) datasource. To do this, first open the 

ODBC administrator. In Win2000, this is under  programs  but in older 

versions of Windows it is called 32bit ODBC and is a control panel. You need 

to add a system datasource, selecting the Access file or SQL Server database 

you wish to use and giving it a name. Scripts such as CactuShop can then link 

to this database by datasource name without knowing the path to the file. So 

your connection string will change to: 

strDataSourceName= myodbcdatasourcename 

Note that we don't specify any file with ODBC connections   just the name of 

the data source. In theory, you can change the database type and providing 

you give it the same ODBC data source name as before, the scripts do not 

need to be changed. In practice though (as previously discussed), minor 

changes to the SQL statements are needed when changing from Access to 

SQL Server. We've built in support for this, hence all you need to change is 

the str

DBtype

 switch. 

7.3.1.3 numCursorType 

This setting can prevent certain types of operations such as recordcounts from 

returning correct values. Different versions of database drivers and operating 

systems require a different setting here. By default the cursor is type 3, but 

after upsizing to SQL, you may find the cart functions erratically and 

procedures that require recordcounts return  1. In this case, try changing the 

cursortype to 1. The effects of wrong cursor type can be so erratic that it may 

not be immediately apparent what the problem is. If the cart acts weirdly, try 

this before tearing your hair out. 

7.3.2 

Other database types 

CactuShop is only tested with MS Access 2000, MS SQL Server 7.0 & 2000 and 

MySQL (Windows version). Other versions of Access and SQL Server should 

work fine providing your server has the correct drivers installed. Older 

versions of MySQL may not support some SQL syntax used in CactuShop. No 

changes of scripts are required. If you need an Access file in 97 format this 

can be downloaded from our web site `downloads' page. 

If you wish to use CactuShop with Oracle or other databases, we would 

suggest starting by switching the 

strDBtype

 to SQL syntax. However, we 

would expect that some SQL syntax changes would be required. We cannot 

offer tech support for databases that CactuShop has not been specifically 

designed to work with.

54