1 2 Previous Next 16 Replies Latest reply on Dec 2, 2014 3:52 AM by Nimish Kumar

    Is VDB dependent on Source Database name ?

    Madhurika Sharma Newbie

      I am creating a VDB using Teiid Designer . The VDB was earlier connecting to DB1 in Testing phase .

      Now , I have a DB2 present in PROD environment. The tables are same in both the databases.

      After changing the Source name in Teiid Designer i also changed the SQL query with DB2

      The new VDB is getting deployed too .

      When i am accessing the VDB's table  ; i am getting an error :

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'DB1.dbo.TABLE1'.

      Can anyone please help me understand if the VDB is dependent on the Source Database ?
      And if it is then can we change the configuration anywhere ?

        1 2 Previous Next