- 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
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.
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
I have both drivers already installed, but I still get the error