cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mikomada
Level 3

Run script on Azure SQL

Jump to solution

Hello,

I am trying to run sql script on Azure SQL db.  I have selected "Microsoft Windows Azure" as target database server, however during the installation I get the following error:


Error 27502. Could not connect to Microsoft Windows Azure 'xxx.database.windows.net'. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)

I have the driver installed though. 

 

Also, is Active Directory Integrated authentication method supported by InstallShield?

 

Labels (1)
0 Kudos
1 Solution
Jenifer
Flexera Alumni

Hi @mikomada ,

 

Connecting to a Microsoft Windows Azure SQL database server requires the SQL Server Native Client 10.0 ODBC driver on target system that are running the installation. To ensure that this driver is available on target systems, you can include the InstallShield prerequisite for Microsoft SQL Server 2008 Native Client 10.00.2531 in your project.

 

You can get more details from:https://helpnet.flexerasoftware.com/installshield23helplib/helplibrary/ConnectToSQLAzure.htm?

 

Thanks,

Jenifer

View solution in original post

0 Kudos
2 Replies
Jenifer
Flexera Alumni

Hi @mikomada ,

 

Connecting to a Microsoft Windows Azure SQL database server requires the SQL Server Native Client 10.0 ODBC driver on target system that are running the installation. To ensure that this driver is available on target systems, you can include the InstallShield prerequisite for Microsoft SQL Server 2008 Native Client 10.00.2531 in your project.

 

You can get more details from:https://helpnet.flexerasoftware.com/installshield23helplib/helplibrary/ConnectToSQLAzure.htm?

 

Thanks,

Jenifer

0 Kudos
I've already had the driver installed in version 12. When I have installed version 10 it worked.

I think it should work with other versions as well.
Anyway, thanks for help.
0 Kudos