This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
danielleggio
Level 3
‎May 21, 2024 06:56 AM

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.

Labels (1)
Labels
0 Kudos
(4) Replies
shunt
Revenera Moderator Revenera Moderator
Revenera Moderator
‎May 21, 2024 07:32 AM

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

https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/connecting-to-a-windows-azure-sql-database-using-sql-server-native-client?view=sql-server-ver15

 

0 Kudos
danielleggio
Level 3
In response to shunt
‎May 21, 2024 07:53 AM

I cannot change provider for Azure SQL db in the installshield. How to use the drivers you suggest?

Preview file
38 KB
0 Kudos
shunt
Revenera Moderator Revenera Moderator
Revenera Moderator
‎May 22, 2024 05:25 AM

Both the OLE BD and ODBC are available as redistributables to add to your Installation project as prerequisites.

0 Kudos
danielleggio
Level 3
In response to shunt
‎May 31, 2024 08:20 AM

I have both drivers already installed, but I still get the error

0 Kudos