Save password in Openedge 10.1A ODBC Driver

[stephenkelley]

I can run a table import manually from OpenEdge to SQL in SQL 2005 using the Openedge 10.1A ODBC driver with no problem. I save this as an SSIS package. However, when I try to run this package, it always fails. I suspect the problem is that the password is not saved in the ODBC connection.

Interesting, if I construct a conneciton string like:

uid=sys;pwd=password;Driver={Progress Openedge 10.1A Driver};host=sco5;port=13015;db=tt;persist security info=true

which will work manually, whenever I save this connection string in an SSIS package, the pwd parameter is removed.

Is there some way to get the Openedge 10.1A ODBC connection password saved somewhere so I can automate execution of SSIS packages using connections to Openedge databases?

Thanks

 

[RD_Man]

Stephen, we're in the same boat. Did you find a way to save the password?

 

[stephenkelley]

Here's how I got around this limitation:

1. create a ODBC connection to the Progress database
2. add this ODBC connection as a linked server in SQL
3. set the security option for the linked sever to "be made using this security context" which lets you specify the username/password to use

Let me know how it goes, I'm happy to clarify further.

 

[madhead]

I am having a problem with this any chance you could provide details of all the settings in 2?
Cheers,
Andy

 

[stephenkelley]

http://www.hawthorneblog.com/node/5287 has screenshots to illustrate the 3 steps