With the use of SQL Server 2000, the schema of the Raiser's Edge database changes from REWIN to dbo.
Currently, in The Raiser's Edge 7.5, if you use Microsoft Access, the select statement might look like this:
In The Raiser's Edge 7.6, the select statement will be:
The change in Schema will affect three areas:
1. SQL Queries to the backend of the database
2. Specifics objects in RE:VBA
3. Crystal Reports connecting to the backend of the database
Here are solutions that provide information on the changes and help in correcting Raiser's Edge 7.5 procedures to the new Schema.
What version of Crystal can be used to report directly off of a SQL Server database (BB117375)
What is the importance of restricted User Roles when accessing the backend of the database (BB98841)
How to store Views in the database (BB106736)
How to add data directly into the database (BB136251)
Error: General ODBC Error: [Sybase][ODBC Driver][Adaptive Server Anywhere] Unable to connect to database server: Database server not running Native error:-100 (BB106035)
Connect and collaborate with fellow Blackbaud users.