Ask a Question

Database connection

SOLVED
PUM-Prodat-SQL
New Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
RuanAlesi
New Contributor

Re: Database connection

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;

View solution in original post

2 REPLIES 2
RuanAlesi
New Contributor

Re: Database connection

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;

View solution in original post

sonya_m
Community Manager

Re: Database connection

Thank you for advice @RuanAlesi !

 

@PUM-Prodat-SQL Was this what you are looking for?


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
cancel
Showing results for 
Search instead for 
Did you mean: