Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Powerbuilder and SQL Azure

  1. Issue
0
Votes
Undo
  1. Jason Ding
    Jason Ding
  2. PowerBuilder
  3. Friday, 27 April 2018 18:35 PM UTC 
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?
  1. PowerBuilder
  2. Azure
How to see source code in PBL
NativePDF and graphics
Responses (4)
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Thursday, 13 June 2019 23:10 PM UTC
  2. PowerBuilder
  3. # 1

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
Roland Smith
  1. Roland Smith
  2. Friday, 14 June 2019 00:57 AM UTC
https://en.wikipedia.org/wiki/Data_localization

  1. Helpful
Michael Kramer
  1. Michael Kramer
  2. Friday, 14 June 2019 17:26 PM UTC
Nice link. THX /Michael
  1. Helpful
There are no comments made yet.
Carlos Andres Rico
Carlos Andres Rico Accepted Answer Pending Moderation
  1. Thursday, 13 June 2019 16:13 PM UTC
  2. PowerBuilder
  3. # 2

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.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 13 June 2019 00:12 AM UTC
  2. PowerBuilder
  3. # 3

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.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Saturday, 28 April 2018 14:32 PM UTC
  2. PowerBuilder
  3. # 4

http://www.topwizprogramming.com/freecode_sqlazure.html

Comment
Carlos Andres Rico
  1. Carlos Andres Rico
  2. Wednesday, 12 June 2019 23:56 PM UTC
Hi Mr. Smith... Could you please update the link ... It seems to be dead by now ... :(

  1. Helpful
There are no comments made yet.
  • 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.