1. Jason Ding
  2. PowerBuilder
  3. Friday, 27 April 2018
I know that Powerbuilder can connect to SQL Azure via SQL Sever Native Client . I have a question: is it possible to build a local desktop Powerbuilder application but using SQL Azure(not an IWA deployed to Cloud)? If so, what is the limitation? Will it use the same database connection method an transaction object in application? Can I find a demo application?
Michael Kramer Accepted Answer Pending Moderation
1
Votes
Undo

Hey Jason,

Technically, no problem. Albeit storing data offsite brings issues like latency, security, access control, and intermittent connectivity failures much more to the table than a local DB server within your physical building.

But even more, going global has legal implications that probably take longer to solve and may even sink your cloud strategy. Example:

  1. Danish company
  2. Cloud platform no. 1 offers DB hosted in Netherlands replicated to Ireland (or vice versa).
    Cloud platform no. 2 offers DB hosted in Denmark but replicated to US ground.
  3. Data stored includes personal identification and very sensitive data.
    Health records, high-risk sports activity, economic impact of workplace absence, and more.

Before going live, you need to find out how to handle all such data and whatever issues may arise.

TECHINCAL ISSUES =>  Don't hesitate to raise them in this forum.
LEGAL ISSUES => Seek legal advice, I'm not a lawyer.

HTH /Michael

Comment
Nice link. THX /Michael
  1. Michael Kramer
  2. Friday, 14 June 2019
There are no comments made yet.
  1. Thursday, 13 June 2019
  2. PowerBuilder
  3. # 1
Carlos Andres Rico Accepted Answer Pending Moderation
1
Votes
Undo

Hi, Mr. Smith ...
Thanks a lot ! ... It was really helpful !!! ... 
I confirm our profile configuration as it worked !:

DBMS = "SNC SQL Native Client(OLE DB)"
ServerName = tcp:<ServerName>.database.windows.net
LogId = <UserID>@<ServerName>
LogPass = <Password>
...
DBParm = Database='<DatabaseName>',Provider='SQLNCLI10',Encrypt=1, ...

Comment
There are no comments made yet.
  1. Thursday, 13 June 2019
  2. PowerBuilder
  3. # 2
Roland Smith Accepted Answer Pending Moderation
1
Votes
Undo

I deleted it because the dbparms changed and I no longer have an Azure account to test with.

I think it is something like this:

Driver={SQL Server Native Client 10.0};Server=tcp:[serverName].database.windows.net;Database=myDataBase;Uid=[LoginForDb]@[serverName];Pwd=myPassword;Encrypt=yes;

 

 

Comment
There are no comments made yet.
  1. Thursday, 13 June 2019
  2. PowerBuilder
  3. # 3
Roland Smith Accepted Answer Pending Moderation
Comment
Hi Mr. Smith... Could you please update the link ... It seems to be dead by now ... :(

  1. Carlos Andres Rico
  2. Wednesday, 12 June 2019
There are no comments made yet.
  1. Saturday, 28 April 2018
  2. PowerBuilder
  3. # 4
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies. Learn More