When I connect a solution with a MSSQL db (skip system tables enabled) there is always an error on importing the solution in the application server:
‘Reserved words used as table or column names: tables: domains; columns: module_name’
It is impossible to import the solution without checking:
‘Allow reserved SQL keywords as table or column names (will fail unless supported by the backend database)’
Can anyone explain this?
Hi, Jos.
‘Reserved words used as table or column names: tables: domains; columns: module_name’
The message is telling you that your table name ‘domains’ is a reserved keyword. Reference the URL below for more details:
I hope this helps!
Hi Kim, Thanks for your reply, so far the only one
But that is not my point. My point is that I respect all those reserved words: I dont have tables or columns named ‘domain’ etc. But nevertheless Servoy is complaining. A mssql database creates these tables automaticly and uses it undoubtly for its own bookkeeping. I would expect Servoy to ignore these tables and for most of it it does. Except for this one… (I always check ‘skip system tabbles’ in the database connection)
Hi Jos
If you select the option ‘Export all tables from referenced servers’ while exporting your solution, with a SQL-Server there will also exported some System-View. Regardless of whether the option ‘Skip System Tables’ is set or not. Perhaps, this is your problem.
Hi Gabriel,
That must be it. I have to check that option, otherwise some tables that are needed will be ignored.
So be it…
At least I know now why!
Tnx