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?