CSDN博客

img tonybaobao

总结:Connection大全

发表于2004/9/30 12:23:00  695人阅读

1.Sqlserver
  A.ODBC
    I.Standard Security:
      "Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
    II.Trusted connection:
      "Driver={SQL Server};Server=Aron1;Database=pubs;
       Trusted_Connection=yes;"
    III.Prompt for username and password:
       oConn.Properties("Prompt") = adPromptAlways
       oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"
  B.OLE DB, OleDbConnection (.NET)
    I.Standard Security:
       "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User
       Id=sa;Password=asdasd;"
    II.Trusted Connection:
       "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;
       Integrated Security=SSPI;"
       (仅适用于Sqlserver 2000)
    III.Prompt for username and password:
       oConn.Provider = "sqloledb"
       oConn.Properties("Prompt") = adPromptAlways
       oConn.Open "Data Source=Aron1;Initial Catalog=pubs;" 
    IV.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;"
  C.SqlConnection (.NET)
    I.Standard Security:
     "Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
     或者"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;
     Trusted_Connection=False"
    II.Trusted Connection:
     "Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
     或者"Server=Aron1;Database=pubs;Trusted_Connection=True;"
     (仅适用于Sqlserver 2000)
    III.Connect via an IP address:
     "Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial
     Catalog=pubs;User ID=sa;Password=asdasd;"
     Name       Network library
     dbnmpntw   Win32 Named Pipes
     dbmssocn   Win32 Winsock TCP/IP
     dbmsspxn   Win32 SPX/IPX
     dbmsvinn   Win32 Banyan Vines
     dbmsrpcn   Win32 Multi-Protocol (Windows RPC)
     通过SQLOLEDB provider 连接,用Network Library=dbmssocn,通过MSDASQL
     provider连接,用Network=dbmssocn
    IV.声明方法:
     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()
  D.Data Shape
    MS Data Shape
    "Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial
    Catalog=pubs;User ID=sa;Password=asdasd;"
   呵呵,Data Shape没用过,请参照
   
http://www.4guysfromrolla.com/webtech/092599-1.shtml
2.Access
  A.ODBC
    I.Standard Security:
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/mydatabase.mdb;
       Uid=Admin;Pwd=;"
    II.Workgroup:
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/mydatabase.mdb;
      SystemDB=C:/mydatabase.mdw;"
    III.Exclusive:
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/mydatabase.mdb;
      Exclusive=1;Uid=admin;Pwd="
  B.OLE DB, OleDbConnection (.NET)
    I.Standard security:
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;
      User Id=admin;Password=;"
    II.Workgroup (system database):
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;
      Jet OLEDB:System Database=system.mdw;"
    III.With password:
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;
      Jet OLEDB:Database Password=MyDbPassword;"
3.Oracle
  A.ODBC
    I.New version:
      "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;
      Uid=Username;Pwd=asdasd;"
    II.Old version:
      "Driver={Microsoft ODBC Driver for Oracle};ConnectString=
      OracleServer.world;Uid=myUsername;Pwd=myPassword;"
  B.OLE DB, OleDbConnection (.NET)
    I.Standard security:
      "Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;
      Password=asdasd;"
      注:上面是用MS的驱动,下面是用Oracle提供的驱动:
      "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
      Id=Username;Password=asdasd;"
    II.Trusted Connection:
      "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
  C.OracleConnection (.NET)
    I.Standard:
      "Data Source=Oracle8i;Integrated Security=yes";
      注:此写法用于Oracle 8i release 3及以上版本。
      声明方法:
      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()
  D.Data Shape
    I.MS Data Shape:
      "Provider=MSDataShape.1;Persist Security Info=False;Data
      Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"
3.MySQL
  A.ODBC
    I.Local database:
      "Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;"
    II.Remote database:
      "Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;
      Stmt=;Database=my-database;Uid=username;Pwd=password;"
  B.OLE DB, OleDbConnection (.NET)
    I.Standard:
      "Provider=MySQLProv;Data Source=mydb;User Id=UserName;
      Password=asdasd;"
  C.MySqlConnection (.NET)
    I.eInfoDesigns.dbProvider:
      "Data Source=server;Database=mydb;User ID=username;
      Password=pwd;Command Logging=false"
      注:此写法仅用于通过eInfoDesigns dbProvider连接:
    II.声明方法:
      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()  
4.Interbase
  A.ODBC (Easysoft ODBC-Interbase driver )
   I.Local computer:
     "Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:
     C:/mydatabase.gdb;Uid=username;Pwd=password"
   II.Remote Computer:
     "Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName
     :C:/mydatabase.gdb;Uid=username;Pwd=password"
  B.ODBC (Intersolv ODBC-Interbase driver )
   I.Local computer:
     "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;
     Database=localhost:C:/mydatabase.gdb;Uid=username;Pwd=password"
   II.Remote Computer:
     "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};
     Server=ComputerName;Database=ComputerName:C:/mydatabase.gdb;
     Uid=username;Pwd=password"
  C.OLE DB (SIBPROvider Driver)
   I.Standard:
     "provider=sibprovider;location=localhost:;data source=c:
     /databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey"
   II.Specifying character set:
     "provider=sibprovider;location=localhost:;data source=c:
     /databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey;
     character set=ISO8859_1"
   III.Specifying role:
     "provider=sibprovider;location=localhost:;data source=c:
     /databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey;
     role=DIGITADORES"
6.IBM DB2
  A.OLE DB, OleDbConnection (.NET) from ms
   I.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"
   II.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" 
7.Sybase
  A.ODBC
   I.Standard Sybase System 12 (or 12.5) Enterprise Open Client:
     "Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password"
   II.Standard Sybase System 11:
     "Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"
   III.Intersolv 3.10:
     "Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;
     Pwd=password;"
   IIII.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="""""
  B.OLEDB
    I.Adaptive Server Anywhere (ASA):
    "Provider=ASAProv;Data source=myASA"
    II.Adaptive Server Enterprise (ASE) with Data Source .IDS file:
    "Provider=Sybase ASE OLE DB Provider; Data source=myASE"
    注:必须先用Data Administrator创建Data Source .IDS file 
    III.Adaptive Server Enterprise (ASE):
    "Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;
    User Id=username;Password=password"
8.Informix
  A.ODBC
    I.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
    II.Informix-CLI 2.5:
    "Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver;Database=mydb;
    Uid=username;Pwd=myPwd"
  B.OLE DB
    I.IBM Informix OLE DB Provider:
    "Provider=Ifxoledbc.2;password=myPw;User ID=myUser;Data Source=
   
dbName@serverName;Persist Security Info=true"
9.Mimer SQL
  A.ODBC
    I.Standard Security:
    "Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw;"
    II. Prompt for username and password:
    "Driver={MIMER};Database=mydb;"
10.DSN
  A.ODBC
   I.DSN:
    "DSN=myDsn;Uid=username;Pwd=;"
   II.File DSN:
    "FILEDSN=c:/myData.dsn;Uid=username;Pwd=;"
11.Excel
  A.ODBC
   I.Standard:
    "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;
    Dbq=C:/MyExcel.xls;DefaultDir=c:/mypath;"
  B.OLE DB
   I.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.
12.Text
  A.ODBC
   I.Standard:
   "Driver={Microsoft Text Driver (*.txt; *.csv)};
   Dbq=c:/txtFilesFolder/;Extensions=asc,csv,tab,txt;"
  B.OLE DB
   I.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.

13.DBF / FoxPro
  A.ODBC
   I.standard:
   "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:/mydbpath;"
  B.OLE DB, OleDbConnection (.NET)
   I.standard:
   "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/folder;Extended Properties=
   dBASE IV;User ID=Admin;Password="
14.Visual FoxPro
  A.OLE DB, OleDbConnection (.NET)
   I.Database container (.DBC):
   "Provider=vfpoledb.1;Data Source=C:/MyDbFolder/MyDbContainer.dbc;
   Password=MyPassWord;Collating Sequence=machine"
   II. Free table directory:
   "Provider=vfpoledb.1;Data Source=C:/MyDataDirectory/;Password=MyPassWord;
   Collating Sequence=general"
  B.ODBC
   I.Database container (.DBC):
   "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=
   c:/myvfpdb.dbc;Exclusive=No;Collate=Machine;"
   II.Free Table directory:
   "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=
   c:/myvfpdbfolder;Exclusive=No;Collate=Machine;"
15.Pervasive (没听说过这个东东)
  A.ODBC
   I.Standard:
   "Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"
  B.OLE DB
   I.Standard:
   "Provider=PervasiveOLEDB;Data Source=C:/path"
16.UDL
   "File Name=c:/myDataLink.udl;"

0 0

相关博文

我的热门文章

img
取 消
img