Knowledgebase
Home » Item #950
Error: Could not find stored procedure 'ÿþ'
Question
I am trying to run the MS SQL setup script for v6 using the datatool but I get the following error:
Could not find stored procedure 'ÿþ'
Why is this and what can I do to create the database?
Answer
This appears to be some kind of UTF encoding issue that affects older CactuShop v6 data tool versions when used in conjunction with certain MS SQL db installs. It should be fixed in the latest versions of the data tool, so the first step is to download the latest data tool if you have not already done so.
If this does not fix the problem, the MS SQL setup script can be run with Microsoft's own database admin tool 'Enterprise Manager'. There is also a free admin tool for MS SQL Server available from Microsoft:
MS SQL 2005 Express
This is a direct link to the Microsoft SQL Server Management Studio Express download:
Download Management Studio Express
Once you have this installed, you need to connect it to your live database and then open a 'New Query'. In the window, paste the entire contents of the .sql file and then click the 'parse' button (blue tick). It might take several minutes but it should confirm no errors. To actually run the setup script, hit the 'Execute' button. Again, this might take several minutes, but assuming no problems, it should create the entire database structure as well as add required records and demo data.
Once the database is set up, you should be able to use the data tool for other tasks such as upgrading from v5.1 to v6. The issue only affects the ability to run setup scripts from the data tool.