Forum Discussion

PUM-Prodat-SQL's avatar
PUM-Prodat-SQL
New Contributor
5 years ago

Database connection

Hey guys,

 

I like to centralize the database connection string to switch fastly between 2 databases.

Does anybody knows how to do this?

 

I could imagine a solution like creating a string variable containing the connection string at the project suite level in testcomplete and using this variable value to create a dbtable variable at the test items level.

 

Is this possible in testcomplete?

  • You can use a function that returns differents ConnectionString with a CASE/OF.

     

    function YourFunction(WichConnection: string): OLEVariant;

    begin

     case WichConnection of:

        'A': result := ConnectionStringA;

        'B': result := ConnectionStringB;

     end;

    end;

  • RuanAlesi's avatar
    RuanAlesi
    New Contributor

    You can use a function that returns differents ConnectionString with a CASE/OF.

     

    function YourFunction(WichConnection: string): OLEVariant;

    begin

     case WichConnection of:

        'A': result := ConnectionStringA;

        'B': result := ConnectionStringB;

     end;

    end;