Testing ODBC

MichaelL-mTnyLpuDpHxWk0Htik3J/[email protected]
Newsgroups gmane.lisp.clsql.devel
Message-ID <OF0AAF9481.34B9C49D-ON85256F5B.00040748-85256F5B.00042C22@frogware.com>
I have a potentially silly question. I've successfully tested the 
SQLite and SQLite 3 drivers; I'm now trying the ODBC driver against SQL 
Server. I've created a special database just for testing, and I've created 

a special test user who has rights to that database. The test user has 
only the 'public' role.

The ODBC test is failing:

        Error: A database error occurred: NIL / 42000
          [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the 
view 'sysconstraints' because it is a system view.

The problem is that test-connect-to-database in test-init.lisp is calling 
truncate-database in fddl.lisp, and that function tries to drop all views, 

etc in the database--including, for example, the system view 
'sysconstraints'. 

Any ideas? Should I set things up differently?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.