3 Replies Latest reply: Sep 7, 2017 2:47 PM by Aimee Johnson RSS

    Invalid object name

    Aimee Johnson

      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,