Need to use 32bit PostgreSQL driver in Workflow
Hello All -
Trying to build a monitoring project that connects to a PostgreSQL database using a 32 bit ODBC driver.
I've tried specifying the 32bit driver in the ODBC provider connection stream when building the the custom generator, but it fails.
It seems like there might be a few options here and I'm looking for insights as to the best...
Option 1 - I have a vbs script that I can use via the 32bit cscript command, e.g. C:\Windows\SysWOW64\cscript.exe blah.vbs
Is there a component I can use to run the executable with the vbs script as an argument where the expected result will be a csv file that my workflow can then parse, etc...?
Option 2 - Can I use "Code (Script) Component" to run the vbs script? If so how do I specify the 32bit csript exe?
Option 3 - In IIS, can I set the "Enable 32-bit Applications" to True? If so, will this impact existing Workflows (either functionally or performance-wise)?
Please let me know if you have any questions. Again, any/all insights are greatly appreciated. Tnx, Tom