- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Azure SQL script
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Azure SQL script
Hello,
I am trying to run a 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 Native Client V12 already installed.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Depending on what SQL version you are targeting - Microsoft mention that they have removed the SQL Native Client from SQL 2022 onwards.
They recommend using the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server or the latest Microsoft ODBC Driver for SQL Server going forward
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Both the OLE BD and ODBC are available as redistributables to add to your Installation project as prerequisites.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
I have both drivers already installed, but I still get the error
![](/skins/images/3B39CE851FDD5528C393F146EB70A2D0/responsive_peak/images/icon_anonymous_message.png)