I have an active connection but no tables showing. If I refresh I see a triangle before Tables very short.
Also the autoSQL function for tables does not work.
Unable to obtain Target Table metadata from connection MSQLADOConnection. I’ve read other topics about “Unable to obtain Target Table metadata” but they don’t provide a solution…
At design time I connect with sa which has sysadmin rights.
We use ADO with SQLOLEDB.1. (why can’t it access DB structure??)
If I use the native driver SQLNCLI11.1, I can browse the database through the connection.
But…
The parameter schemas=1 is added. We do not want to specify a schema because this may differ per customer. When I specify schemas=0 then DB structure can’t be accessed anymore.
User sa has default schema dbo so I shouldn’t have to specify the schema.
We all ready set the connection at runtime.
Problem is that we need to specify the db schema (dbo) now in design time and we don’t want the schema hardcoded in the DASchema in the dfm because it can be different for each customer.
Unfortunately every driver has the same problem only work with schemas=1