Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Need to use 32bit PostgreSQL driver in Workflow

Created: 13 Dec 2013 • Updated: 16 Dec 2013 | 1 comment
TomS's picture
This issue has been solved. See solution.

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

Operating Systems:

Comments 1 CommentJump to latest comment

TomS's picture

Ok, I answered my own question on this one...

I used the "Execute Process and Wait (Run)" component to fire off the 32 cscript exe, then specified the VBScript file as an argument.  The component is nice... I was able to specify the working directory (where the script writes the file) and even toggle the "Create No Window" option so the VBScript doesn't open its own window.

Problem solved, onto the next...

Tnx, Tom

SOLUTION