Search code examples
azurepowerbuilder

PowerBuilder Azure connection string with SNC

our Powerbuilder 11.5 applications are client-server using the SNC driver (SQL Native Driver) to connect to SQL Server databases.

We are thinking of using Azure.

2 questions:

  • Can PB 11.5 connect to Azure database using the SNC driver?

  • The current DBParms are: TrimSpaces=1,RecheckRows=1,Identity='SCOPE_IDENTITY(). Will they be valid in the Azure environment? Can you post a working SNC or OLEDB connection string?

Thank you

Solution

  • A working example program can be found at the Topwiz Programming website here.

    There also is an article from TechWave 2011 here.