Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

Excel VBA Error connecting to Azure : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Hi

I have an Excel VBA project that connects to a SQL Azure database using the following type of connection string. This works fine on my dev machine but when I try and run it on another person's machine I get the error mentioned in the header. Where would I find the relevant driver to fix this issue. I only seemed to be able to find software that I would have to pay for.

strConn = "Driver={SQL Server Native Client 11.0};Server=tcp:lesedisa.database.windows.net,1433;Database=xxx;Uid=xxxxx;Pwd=xxxx;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;"
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
QlemoC++ DeveloperCommented:
This connection string requires SQL Server Native Client 2012 to be installed. Alternative drivers and more info at https://msdn.microsoft.com/en-us/library/cc280510.aspx. Possible connection strings can be seen at www.connectionstrings.com.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thank you very much
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now