Got a call from a developer. Seems there is an old PowerBuilder 8.5.1 application that currently uses the users current credentials for the ODBC connection to a back end SQL server. The question to me was, can they have it use alternate credentials. So the user would logon to Windows, the app would authenticate them using their windows logon, but the ODBC connection in the application would use an alternate set of credentials to connect to the SQL database.
I'm not a developer and I don't know PowerBuilder at all, but shouldn't
this be possible with the connection string in the application? Something
like this?
Driver={SQL Server Native Client
10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Any help appreciated.
Thanks
Christopher Bodnar
Enterprise Achitect I, Corporate Office of Technology:Enterprise
Architecture and Engineering Services
Tel 610-807-6459
3900 Burgess Place, Bethlehem, PA 18017
[email protected]
The Guardian Life Insurance Company of America
www.guardianlife.com
-----------------------------------------
This message, and any attachments to it, may contain information
that is privileged, confidential, and exempt from disclosure under
applicable law. If the reader of this message is not the intended
recipient, you are notified that any use, dissemination,
distribution, copying, or communication of this message is strictly
prohibited. If you have received this message in error, please
notify the sender immediately by return e-mail and delete the
message and any attachments. Thank you.
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin<<image/jpeg>>
