Forum Discussion

sriram_sig's avatar
sriram_sig
Contributor
7 years ago
Solved

how to make a db connection created through ADO available to all methods within and outside the unit

how to make a db connection created through ADO available to all methods within and outside the unit, when using python as the scripting language AConnection = ADO.CreateADOConnection()
sriram_sig's avatar
sriram_sig
Contributor
7 years ago
Copy Link

The example which you provided me earlier helps to create db connection, but i also want to use this same connection in other methods

tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago
Copy Link

Rather than a project variable, is there a way to make a variable declared in one Python unit available for others?  In JavaScript, if you export a variable and then use the "requires" call in a subsequent unit, you can access that variable anywhere.

Alternatively, you could create a Script Extension whose sole purpose is to provide an ADO DB connection. that you can then access from anywhere.