Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New Contributor III

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 DBsUser associated to DBs

 

Doing a simple Select * load on a table in each database, the one database gives a non-descriptive generic error:

Failed LoadFailed Load

 

... while the other successfully completes.

Successful LoadSuccessful Load

 

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.

Labels (3)
3 Replies
Highlighted

Re: Unable to Connect to Database in SQL - can connect to other DBs on same server

1. Check in the discovery directory (I meant, use direct script which is equal to QvOdbcConnectorPackage) with in the same error where you face problem

2. Check if the connection name is same as per SQL Statement?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
New Contributor III

Re: Unable to Connect to Database in SQL - can connect to other DBs on same server

Thanks for responding Anil but not following what you are suggesting in #1.  For the SQL connection, it is the exact same connection but to two different databases. 

Highlighted

Re: Unable to Connect to Database in SQL - can connect to other DBs on same server

Try to use one by one and then see to test? It is actually odd to explain what is there with you. Have you said that there is only one query which is SELECT * FROM ...

Hence, It shouldn't be a case ..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)