Page 1 of 1

Extract fields from string

Posted: Wed Mar 30, 2011 10:03 am
by lbertoldi
Hi there, I want to use your SQL integration to execute some scripts in a db.
Problem is that I only have an OleDb connection string (read from registry) while your SQL Server integration requires each field to be configured separately.
So, from this string "data source=xyz;initial catalog=mydb;user id=sa;password=myown" I need to extract each field in order to pass them to the SQL Server action.
Is there a (easy) way to achieve this?
Thanks
Luca

Re: Extract fields from string

Posted: Wed Mar 30, 2011 10:48 am
by giaviv
Dear Luca,

There is no straight forward way to achieve this. You would have to use the Parse String command multiple times in order to get to your fields.
Let me know if you can't figure out how to do this and I will help.

Re: Extract fields from string

Posted: Fri Apr 01, 2011 7:27 am
by giaviv
Sorry guys - second attempt at uploading the script: