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?