dynamically change connection

Developers Databases
#1

Hello everyone, i am discovering the wonderful possibilities of scriptcase, but i am faced to an issue i can’t find the solution, perhaps someone can help.

I am using a PDO Informix database. Is it possible to let the user set the login/password and THEN connect to database with those?

Also, is it possible to dynamically change the connection used by the application? I suppose i will have to use sc_change_connection but how can i get the “old connection” name?

#2

Hi ouissem,
Your old connection name is the name that you specified in ScriptCase>Database>New Connection/Edit Connection.

If you want to use sc_change_connection macro then you need at least 2 connections defined in scriptcase.