连接数据库的字符串

原创 2004年06月29日 15:32:00
 SQL Server  ODBC

  •  Standard Security:
    "Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"


  •  Trusted connection:
    "Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"


  •  Prompt for username and password:
    oConn.Properties("Prompt") = adPromptAlways
    oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"


 OLE DB, OleDbConnection (.NET)

  •  Standard Security:
    "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"


  •  Trusted Connection:
    "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
    (use serverName/instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
  •  Prompt for username and password:
    oConn.Provider = "sqloledb"
    oConn.Properties("Prompt") = adPromptAlways
    oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"


  •  Connect via an IP address:
    "Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
    (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
 SqlConnection (.NET)

  •  Standard Security:
    "Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
       - or -
    "Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False"
       (booth connection strings produces the same result)


  •  Trusted Connection:
    "Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
       - or -
    "Server=Aron1;Database=pubs;Trusted_Connection=True;"
       (booth connection strings produces the same result)
    (use serverName/instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
  •  Connect via an IP address:
    "Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
    (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
  •  Declare the SqlConnection:
    C#:
    using System.Data.SqlClient;
    SqlConnection oSQLConn = new SqlConnection();
    oSQLConn.ConnectionString="my connectionstring";
    oSQLConn.Open();


    VB.NET:
    Imports System.Data.SqlClient
    Dim oSQLConn As SqlConnection = New SqlConnection()
    oSQLConn.ConnectionString="my connectionstring"
    oSQLConn.Open()

 Data Shape

  •  MS Data Shape
    "Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
     
 Access  ODBC

  •  Standard Security:
    "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/mydatabase.mdb;Uid=Admin;Pwd=;"


  •  Workgroup:
    "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/mydatabase.mdb;SystemDB=C:/mydatabase.mdw;"


  •  Exclusive:
    "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="


 OLE DB, OleDbConnection (.NET)

  •  Standard security:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;User Id=admin;Password=;"


  •  Workgroup (system database):
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;Jet OLEDB:System Database=system.mdw;"


  •  With password:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"


 Oracle  ODBC

  •  New version:
    "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"


  •  Old version:
    "Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"


 OLE DB, OleDbConnection (.NET)

  •  Standard security:
    "Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
    This one's from Microsoft, the following are from Oracle
  •  Standard Security:
    "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"


  •  Trusted Connection:
    "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"


 OracleConnection (.NET)

  •  Standard:
    "Data Source=Oracle8i;Integrated Security=yes;"
    This one works only with Oracle 8i release 3 or later
  •  Specifying username and password:
    "Data Source=Oracle8i;User Id=username;Password=passwd;Integrated Security=no;"
    This one works only with Oracle 8i release 3 or later
  •  Declare the OracleConnection:
    C#:
    using System.Data.OracleClient;
    OracleConnection oOracleConn = new OracleConnection();
    oOracleConn.ConnectionString = "my connectionstring";
    oOracleConn.Open();


    VB.NET:
    Imports System.Data.OracleClient
    Dim oOracleConn As OracleConnection = New OracleConnection()
    oOracleConn.ConnectionString = "my connectionstring"
    oOracleConn.Open()

 Core Labs OraDirect (.NET)

  •  Standard:
    "User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"

 

 Data Shape

  •  MS Data Shape:
    "Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"

 

 MySQL  ODBC

  •  Local database:
    "Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;"


  •  Remote database:
    "Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"


 OLE DB, OleDbConnection (.NET)

  •  Standard:
    "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
 MySqlConnection (.NET)

  •  eInfoDesigns.dbProvider:
    "Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false"
     
  •  Declare the MySqlConnection:
    C#:
    using eInfoDesigns.dbProvider.MySqlClient;
    MySqlConnection oMySqlConn = new MySqlConnection();
    oMySqlConn.ConnectionString = "my connectionstring";
    oMySqlConn.Open();


    VB.NET:
    Imports eInfoDesigns.dbProvider.MySqlClient
    Dim oMySqlConn As MySqlConnection = New MySqlConnection()
    oMySqlConn.ConnectionString = "my connectionstring"
    oMySqlConn.Open()

 SevenObjects MySqlClient (.NET)

  •  Standard:
    "Host=server; UserName=myusername; Password=mypassword;Database=mydb;"
     
 Core Labs MySQLDirect (.NET)

  •  Standard:
    "User ID=root; Password=pwd; Host=localhost; Port=3306; Database=test;Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"

     

 Interbase  ODBC, Easysoft

  •  Local computer:
    "Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:/mydatabase.gdb;Uid=username;Pwd=password"


  •  Remote Computer:
    "Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName:C:/mydatabase.gdb;Uid=username;Pwd=password"

 ODBC, Intersolv

  •  Local computer:
    "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;Database=localhost:C:/mydatabase.gdb;Uid=username;Pwd=password"


  •  Remote Computer:
    "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=ComputerName;Database=ComputerName:C:/mydatabase.gdb;Uid=username;Pwd=password"
     


 OLE DB, SIBPROvider

  •  Standard:
    "provider=sibprovider;location=localhost:;data source=c:/databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey"


  •  Specifying character set:
    "provider=sibprovider;location=localhost:;data source=c:/databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey;character set=ISO8859_1"


  •  Specifying role:
    "provider=sibprovider;location=localhost:;data source=c:/databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey;role=DIGITADORES"




 IBM DB2  OLE DB, OleDbConnection (.NET) from ms

  •  TCP/IP:
    "Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"


  •  APPC:
    "Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"


 ODBC

  •  Standard:
    "driver={IBM DB2 ODBC DRIVER};Database=myDbName;hostname=myServerName;port=myPortNum;protocol=TCPIP; uid=myUserName; pwd=myPwd"


 Sybase  ODBC

  •  Standard Sybase System 12 (or 12.5) Enterprise Open Client:
    "Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password"


  •  Standard Sybase System 11:
    "Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"
     
  •  Intersolv 3.10:
    "Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;"


  •  Sybase SQL Anywhere (former Watcom SQL ODBC driver):
    "ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:/dbfolder/;Dbf=c:/mydatabase.db;Uid=username;Pwd=password;Dsn="""""
    Note! The two double quota following the DSN parameter at the end are escaped quotas (VB syntax), you may have to change this to your language specific escape syntax. The empty DSN parameter is indeed critical as not including it will result in error 7778.


     
 OLE DB

  •  Adaptive Server Anywhere (ASA):
    "Provider=ASAProv;Data source=myASA"

     

  •  Adaptive Server Enterprise (ASE) with Data Source .IDS file:
    "Provider=Sybase ASE OLE DB Provider; Data source=myASE"
    Note that you must create a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.
  •  Adaptive Server Enterprise (ASE):
    "Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;User Id=username;Password=password"
       - some reports on problem using the above one, try the following as an alternative -

    "Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial Catalog=myDBname;User Id=username;Password=password"
    This one works only from Open Client 12.5 where the server port number feature works,燼llowing fully qualified connection strings to be used without defining燼ny .IDS Data Source files.
 AseConnection (.NET)

  •  Standard:
    "Data Source='myASEserver';Port=5000;Database='myDBname';UID='username';PWD='password';"


  •  Declare the AseConnection:
    C#:
    using Sybase.Data.AseClient;
    AseConnection oCon = new AseConnection();
    oCon.ConnectionString="my connection string";
    oCon.Open();


    VB.NET:
    Imports System.Data.AseClient
    Dim oCon As AseConnection = New AseConnection()
    oCon.ConnectionString="my connection string"
    oCon.Open()

 Informix  ODBC

  •  Informix 3.30:
    "Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd


  •  Informix-CLI 2.5:
    "Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver;Database=mydb;Uid=username;Pwd=myPwd"


 OLE DB

  •  IBM Informix OLE DB Provider:
    "Provider=Ifxoledbc.2;password=myPw;User ID=myUser;Data Source=dbName@serverName;Persist Security Info=true"


 Mimer SQL  ODBC

  •  Standard Security:
    "Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw;"


  •  Prompt for username and password:
    "Driver={MIMER};Database=mydb;"


 PostgreSQL  Core Labs PostgreSQLDirect (.NET)

  •  Standard:
    "User ID=root; Password=pwd; Host=localhost; Port=5432; Database=testdb;Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"
     


 DSN  ODBC

  •  DSN:
    "DSN=myDsn;Uid=username;Pwd=;"


  •  File DSN:
    "FILEDSN=c:/myData.dsn;Uid=username;Pwd=;"


 Excel  ODBC

  •  Standard:
    "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:/MyExcel.xls;DefaultDir=c:/mypath;"


 OLE DB

  •  Standard:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
    "HDR=Yes;" indicates that the first row contains columnnames, not data
    "IMEX=1;" tells the driver to always read "intermixed" data columns as text
    TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
 Text  ODBC

  •  Standard:
    "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:/txtFilesFolder/;Extensions=asc,csv,tab,txt;"


 OLE DB

  •  Standard:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/txtFilesFolder/;Extended Properties=""text;HDR=Yes;FMT=Delimited"""
    "HDR=Yes;" indicates that the first row contains columnnames, not data
 DBF / FoxPro  ODBC

  •  standard:
    "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:/mydbpath;"


 OLE DB, OleDbConnection (.NET)

  •  standard:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/folder;Extended Properties=dBASE IV;User ID=Admin;Password="


 Visual FoxPro  OLE DB, OleDbConnection (.NET)

  •  Database container (.DBC):
    "Provider=vfpoledb.1;Data Source=C:/MyDbFolder/MyDbContainer.dbc;Password=MyPassWord;Collating Sequence=machine"


  •  Free table directory:
    "Provider=vfpoledb.1;Data Source=C:/MyDataDirectory/;Password=MyPassWord;Collating Sequence=general"
     
 ODBC

  •  Database container (.DBC):
    "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:/myvfpdb.dbc;Exclusive=No;Collate=Machine;"


  •  Free Table directory:
    "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:/myvfpdbfolder;Exclusive=No;Collate=Machine;"
    "Collate=Machine" is the default setting, for other settings check the

Microsoft Visual Foxpro site:

 Pervasive  ODBC

  •  Standard:
    "Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"
     
 OLE DB

  •  Standard:
    "Provider=PervasiveOLEDB;Data Source=C:/path"

     

 UDL  UDL

  •  UDL:
    "File Name=c:/myDataLink.udl;"


C#连接数据库字符串的写法

对于.NET,主要有四种连接方式: SqlConnection,OleDbConnection,OdbcConnection和OracleConnection。 sqlConnect 表示一个到 ...
  • o7456
  • o7456
  • 2016年03月11日 14:59
  • 497

连接数据库字符串

Access数据库放到App_Data中 Access 2003:Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|EFFris...
  • likexing1987
  • likexing1987
  • 2014年08月17日 03:00
  • 160

在 appSettings 里配置字符串,不在 connectionStrings 里写连接数据库的配置

一点点的不注意就不能成功。在web.config 里面写的连接数据库有两种,一种在里面写,现在采用的比较多,另一种是在里写,都能实现,但是不同的连接方法也有细微的差别。今天一天不在状态,磨磨蹭蹭终于修...
  • eqiang8271
  • eqiang8271
  • 2008年01月31日 17:54
  • 1196

轻松得到适用于C# ADO.NET的各种数据库连接字符串

有时候,你是不是会因为忘了某个数据库的连接字符串而头痛啊? 呵呵!  下面介绍一个可以轻松得到数据库连接字符串的方法。 下面以Access为例: 1. 首先,新建一个文本文件txt,把他的后缀名该为u...
  • xtxoje
  • xtxoje
  • 2008年05月13日 15:42
  • 102

MFC使用ODBC连接数据库

我们在MFC中可以很方便的对数据库进行操作。例如对SQL Server,我们在MFC的类向导中选择添加新类-->ODBC Consumer,然后选择我们已经在本机上安装的数据库实例并且也在ODBC数据...
  • rayborn1105
  • rayborn1105
  • 2012年11月16日 13:02
  • 8064

VS2010配置连接远程数据库的字符串

VS2010配置连接远程数据库的字符串    本地项目访问远程的数据库
  • u014368040
  • u014368040
  • 2016年09月29日 17:34
  • 1076

C#中数据库连接字符串写入配置文件

在C#2010中,如何保存和访问数据库的连接字符串呢? 在Winform下要新增App.config文件,在Asp.net下要新增web.config文件。 1.打开配置文件添加相关代码后...
  • u011981242
  • u011981242
  • 2016年04月07日 11:34
  • 1977

c#数据库连接字符串

连接字符串包含作为参数传递给数据源的初始化信息。在设置后会立即分析连接字符串。语法错误将生成运行时异常,但是只有在数据源验证了连接字符串中的信息后,才可以发现其他错误。验证后,数据源设置启用该连接的各...
  • jerry0597
  • jerry0597
  • 2007年11月13日 13:09
  • 3201

连接数据库文件并使用Windows验证的连接字符串

Data Source=./SQLEXPRESS;AttachDbFilename=|DataDirectory|DB.MDF;Integrated Security=True;Connect Tim...
  • crescens
  • crescens
  • 2008年03月11日 16:46
  • 391

连接数据库的字符串参数介绍

SQL数据库    "user   id=sa":连接数据库的验证用户名为sa.他还有一个别名"uid",所以这句我们还可以写成"uid=sa".      "password=":连接数据库的...
  • feng_enlove
  • feng_enlove
  • 2011年05月17日 10:39
  • 528
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:连接数据库的字符串
举报原因:
原因补充:

(最多只允许输入30个字)