未找到microsoft odbc驱动程序管理器数据源名称,并且未在vb.net中指定默认驱动程序 [英] microsoft odbc driver manager data source name not found and no default driver specified in vb.net
问题描述
我在vb.net中为sql server写了一个连接字符串
I have written a connection string for sql server in vb.net
下面是我的连接字符串代码。我在第3行之后收到此错误,在下面突出显示。
Below is my connection string code.I am getting this error after 3rd line which is highlighted below.
conn =新ADODB.Connection
strConnection =" SQLOLEDB;数据源=数据源名称;初始目录=;用户ID = ID;密码=密码;"
conn.Open(strConnection)
conn = New ADODB.Connection
strConnection = "SQLOLEDB;Data Source=Data source name;Initial Catalog=;User Id=ID;Password=Password;"
conn.Open(strConnection)
我为我的数据源创建了名为SQLOLEDB的DSN。您可以帮我解决此错误。
i have DSN created with the name of SQLOLEDB for my data source.Can you please help me to resolve this error.
推荐答案
你见过这个吗?
Have you seen this?
这篇关于未找到microsoft odbc驱动程序管理器数据源名称,并且未在vb.net中指定默认驱动程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!