topic Re: Invalid object name in QlikView

Invalid object name

Anonymous — Thu, 07 Sep 2017 16:57:08 GMT

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,

Chanty4u — Thu, 07 Sep 2017 17:53:15 GMT

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 — Thu, 07 Sep 2017 17:54:44 GMT

try inserting disconnect before connecting to new one

Anonymous — Thu, 07 Sep 2017 18:47:59 GMT

This worked. Makes sense. Thank you.