Update, the developer just informed me that this is not PowerBuilder, but ClientBuilder. I've never heard of this before. Not even sure they are around. This is the only thing online that I've been able to find that references it:
http://www.thefreelibrary.com/ClientSoft+Announces+ClientBuilder+8.0%3B+New+Version+Offers...-a0123206721 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 From: Christopher Bodnar <[email protected]> To: "NT System Admin Issues" <[email protected]> Date: 05-24-12 10:33 AM Subject: RE: PowerBuilder ODBC connection to SQL with alternate credentials Thanks Michael, That is actually where the example I listed below came from. I've also got an example of a PowerBuilder 9 app that shows how to do it. So I can't believe that functionality doesn't exist in PowerBuilder 8.5.1. My guess is that the code is wrong, and I've asked for the developer to send it over for me to review. Thanks for your help. 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 From: "Michael B. Smith" <[email protected]> To: "NT System Admin Issues" <[email protected]> Date: 05-24-12 10:08 AM Subject: RE: PowerBuilder ODBC connection to SQL with alternate credentials 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] 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 ~ 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 ~ 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 ~ 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>>
<<image/jpeg>>
<<image/jpeg>>
