The following error occurred: Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Invalid object name

[Qlikuser09]

I'm trying to add a new SQL Script to an already existing load Script in QLiksense, when I try to load I get the following error 

The following error occurred:

Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Invalid object name.

However, the new load script connects to a different DB.

[vinieme12 · Accepted solution]

What I think is happening is your existing dB connection is not closed and you are trying to query again to a different db without closing the first connection and 

Example

Lib Connect to db1connection

Some SQL script querying db1;

Some SQL script querying db2;

Now since you are trying to find db2 tables/views in db1 you are getting invalid object name 

Proper way 

Lib Connect to db1connection;

Some SQL script querying db1;

Disconnect; // close previous connection

Lib Connect to db2connection;//open new connection to db2

Some SQL script querying db2;

Disconnect;