错误[IM002] [Microsoft] [ODBC驱动程序管理器]未找到数据源名称且未指定默认驱动程序 [英] ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

问题描述

你好 

我这里有一个很大的问题。我有一个访问Sql Azure数据库的简单.Net应用程序。直到昨天它正在努力工作。但今天早上我有以下错误。在我的本地我可以完全没问题地访问数据库。但只有在
部署之后，我的代码无法从azure中的app服务访问数据库。有人可以向我解释一下吗？

I Have a huge problem here. I have a simple .Net app that is accessing Sql Azure database. Up to yesterday it was working supper fine. But this morning I have the below error. On my Local I can access the database with absolutely no problem. But only after deployment that my code cannot access the database from the app service in azure. Can somebody explain it to me?

因为厌倦了azure，我的应用程序的下一个版本将在AWS上。我不知道是否只有我面对那些愚蠢的问题。

So Tired of azure, next version of my app will be on AWS. I dont know if only me facing those stupid issues.

推荐答案

此错误看起来正在使用的连接字符串格式错误。您是否打算使用ODBC从.NET访问Azure SQL数据库？ SqlClient会更合适。

This error looks like the connection string being used is malformed. Are you intending to use ODBC to access Azure SQL Database from .NET? SqlClient would be a better fit.

发布连接字符串（如果需要，可以进行模糊处理）。它可能在部署期间被软化。

Post your connection string (obfuscated if needed). It may have gotten hosed during the deployment.

这篇关于错误[IM002] [Microsoft] [ODBC驱动程序管理器]未找到数据源名称且未指定默认驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！