Yes. See here for samples: http://www.connectionstrings.com/sql-server-2008
From: Christopher Bodnar [mailto:[email protected]] Sent: Thursday, May 24, 2012 9:55 AM To: NT System Admin Issues Subject: OT: PowerBuilder ODBC connection to SQL with alternate credentials 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]<mailto:> [cid:[email protected]] The Guardian Life Insurance Company of America www.guardianlife.com<http://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]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ 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
<<inline: image001.jpg>>
