I primarily work in the Oracle db world, but I had to develop and Active Database Adapter for a Sql Server 2008 system.
I kept getting an error when designing the adapter services and could not add table
My AdapterConfiguration Design-time Connection tested successfully
But when I went to 'add table', no tables could be found. I tried dbo%, dbname.dbo.mytable, ...
The only way I found to create the table adapter services was to pick add table from other schema and put in dbo as the schema name. I feel it has to do with my ignorance of SqlServer's database, schema, user is different than Oracles. Also in this case, my user was not given the role db_owner which may or may not have played a part.