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

Resolved OLEDB Connection to Azure SQL Database

  1. How-to
0
Votes
Undo
  1. Malek Taha
    Malek Taha
  2. PowerBuilder
  3. Tuesday, 21 March 2023 19:17 PM UTC

Hi

   We recently migrated our inhouse application to PB2021 all work good we connect to an inhouse sqlserver and all is good.

We are looking to move our data base to the cloud Using Azure SQL managed instance.

the server name is as 200sqlmi01.xxxxxxxxxxxxxx.database.windows.net ( i replaced the data with xxxxxxxxxxxxxxx)

I can connect to the server with no issues from Query analyze with Authentication = 'Azure Active Directory-Universal with MFA'

and user name

 

when i try to create the connection from powerbuilder the server does not accept the full name only space for 200sqlmi01.xxxxxxxxxxxxxx.database.wind

Our current connection string is housed in the registry.

Can anyone please help me with how to build a connection string for Powerbuilder app to connect to Azure.

 

Thank Ypu

Malek

 

How to use scanner
PowerClient app launch failure - incorrect file fo...
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 21 March 2023 20:08 PM UTC
  2. PowerBuilder
  3. # 1

"server does not accept the full name only space for 200sqlmi01.xxxxxxxxxxxxxx.database.wind"

what do you mean the server does not accept it?  do you mean the PB IDE won't, or a server?  What server?

 

It is possible the IDE has a size limit to the server name.   But i didnt notice it preventing me from entering: 200sqlmi01.xxxxxxxxxxxxxx.database.windows.net

 

Do you care about the ide connecting?  just use your current connection string and replace the server name with the azure name you came up with.

 

or instead of using a super long server name, create a shorter one.  200sqlmi01.xxxxxxxxxxxxxx is super long.

for example:  myserver.database.windows.net  fits

 

 

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 21 March 2023 20:01 PM UTC
  2. PowerBuilder
  3. # 2

Hi Malek;

   Currently, PB 2021 or 2022 does not support Azure Active Directory.  AFAIK: that feature is being looked at for PB 2022 R2.

  In the meantime, can you Set Azure's SS connectivity to also support TCP/IP with standard User ID & Password?

Regards ... Chris

Comment
Miller Rhodes
  1. Miller Rhodes
  2. Thursday, 30 March 2023 23:31 PM UTC
It would be good if we could get this in R2. I am having the same conundrum where I would like to connect to a Azure SQL or Azure Synapse managed DB
  1. Helpful 1
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.