Extract fields from string
Posted: Wed Mar 30, 2011 10:03 am
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
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