Unable to Connect to Database in SQL - can connect to other DBs on same server
Unusual situation; we have a single user that we are using against two databases within the same server. The user is granted the exact same permissions both on the Server level and the Database level: User associated to DBs
Doing a simple Select * load on a table in each database, the one database gives a non-descriptive generic error:
... while the other successfully completes.
The Load script simple states the library connection (not changed between the two loads); along with
Select * From <databasename>.dbo.<tablename> ;
On the server, the ODBC connection has been created and tested; user can connect using SSMS without error.
In looking at the QvOdbcConnectorPackage log file, there are a couple of items that stand out, but given that the connection works with one DB but not another doesn't jive with the warning message in the log. The parsed log file is attached.