Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
aimee_johnson
Contributor III
Contributor III

Invalid object name

Hi everyone,

I have a script which has a connection string and then select all from a table from the database which is fine, everything works 🙂

When I add in a second connection string to a separate database I get the following error:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Invalid object name

The error specifically mentions my first query and runs the second one, when I run the first one in silo it works... any ideas anyone?

Thanks,

1 Solution

Accepted Solutions
vvira1316
Specialist II
Specialist II

3 Replies
Chanty4u
Champion III
Champion III

Hi,

are you using two databases?

if yes ---- give connection string  on each table  [means alll tables of each server one connection string]

and try

if not  put exit script and try,

if not debug the application check which table is not loading

if not  try to reload the table from database again and check.

vvira1316
Specialist II
Specialist II

aimee_johnson
Contributor III
Contributor III
Author

This worked. Makes sense. Thank you.