使用ODBC驱动程序的连接字符串出现问题 [英] Problem with connection string using ODBC driver

问题描述

我正在C#.net(

using System.Data.Odbc;

)中执行Windows项目
并尝试使用ODBC驱动程序和server =.\sqlserver连接我的数据库，但出现连接错误

我的连接字符串是

)
and trying to connect my database using ODBC driver and server =.\sqlserver but i m getting an connection error

my connection string is

"Driver={SQL Server Native Client};Data Source=.\\sqlexpress;AttachDbFilename="+ Application .StartupPath  +"\\GIS.mdf;Integrated Security=True;"

"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

推荐答案

使用本地客户端时，连接字符串应为:
Provider = SQLNCLI10; Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword;

请检查以下链接以了解用于连接到SQL Server的其他选项:

http://www.connectionstrings.com/sql-server-2005 [

when using native client, connection string should be:
Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

Please check the following link for different options for connecting to SQL server:

http://www.connectionstrings.com/sql-server-2005[^]

< pre> OleDbConnection dbconn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + filename +; Jet OLEDB:Database Password = xxxx;");</pre>

<pre>OleDbConnection dbconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Jet OLEDB:Database Password=xxxx;");</pre>

这篇关于使用ODBC驱动程序的连接字符串出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！