I’m developing a site using Microsoft SQL Server. There are domain users in the server, that creates their own schemas in the Database so there are tables like dbo.table and others like [DOMAIN\glopez].tmp_Table.
Then, if some of my apps has “select” type fields or “automatic” lookups, this causes constants errors messages during development, because Scriptcase creates the list of tables in the database (I assume to make them available when I press the “Create select” link) and then uses the first table to execute a fake select, something like this:
SELECT TOP 1 * FROM GRUMACA\LCESQUIVEL.tmp_Canal WHERE 1 = 0
Why? I don’t know. Maybe it’s an internal test or a way to get the field list from the table. Anyway, the sentence is executed, I can see it using SQL Server Profiler.
But this syntax is invalid for MS-SQL. The schema, being a domain user name, contains a backslash, so it need to be enclosed in brackets.
This causes constant error messages in adodb-mssql.inc.php. The form is generated without problems, and apparently it doesn’t affect the functionality, but it’s annoying and a waste of time: everytime I click on a “Select” field there’s a pause for some seconds and then the error.
SOLUTION:
If you use MS-SQL and “select” fields or automatic lookups, be sure there’s no schemas from domain users in your database.