ADO.NET连接数据库字符串
来源:互联网 发布:挑选加湿器 知乎 编辑:程序博客网 时间:2024/05/01 22:37
ACCESSODBC标准安全"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:/mydatabase.mdb; Uid=Admin; Pwd=; "工作组"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:/mydatabase.mdb; SystemDB=C:/mydatabase.mdw; "独占"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:/mydatabase.mdb; Exclusive=1; Uid=admin; Pwd="OLE DB, OleDbConnection (.NET)标准安全"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/somepath/mydb.mdb; User Id=admin; Password=; "工作组 (system database)"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/somepath/mydb.mdb; Jet OLEDB:System Database=system.mdw; "使用密码"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/somepath/mydb.mdb; Jet OLEDB:Database Password=MyDbPassword; " OracleODBC新版本"Driver={Microsoft ODBC for Oracle}; Server=OracleServer.world; Uid=Username; Pwd=asdasd; "旧版本"Driver={Microsoft ODBC Driver for Oracle}; ConnectString=OracleServer.world; Uid=myUsername; Pwd=myPassword; "OLE DB, OleDbConnection (.NET)标准安全"Provider=msdaora; Data Source=MyOracleDB; User Id=UserName; Password=asdasd; "
This one's from Microsoft, the following are from Oracle标准安全"Provider=OraOLEDB.Oracle; Data Source=MyOracleDB; User Id=Username; Password=asdasd; "信任的连接"Provider=OraOLEDB.Oracle; Data Source=MyOracleDB; OSAuthent=1; "OracleConnection (.NET)标准"Data Source=MyOracleDB; Integrated Security=yes; "
This one works only with Oracle 8i release 3 or later指定用户名和密码"Data Source=MyOracleDB; User Id=username; Password=passwd; Integrated Security=no; "
This one works only with Oracle 8i release 3 or later定义OracleConnection对象C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connection string";
oOracleConn.Open();VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connection string"
oOracleConn.Open()Core Labs OraDirect (.NET)标准"User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"Data Shape微软数据模型"Provider=MSDataShape.1; Persist Security Info=False; Data Provider=MSDAORA; Data Source=orac; user id=username; password=mypw"4MySQLMyODBCMyODBC 2.50 本地数据库"Driver={mySQL}; Server=localhost; Option=16834; Database=mydatabase; "MyODBC 2.50 远程数据库:"Driver={mySQL}; Server=data.domain.com; Port=3306; Option=131072; Stmt=; Database=my-database; Uid=username; Pwd=password; "MyODBC 3.51 本地数据库"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword; OPTION=3; "MyODBC 3.51 远程数据库"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=data.domain.com; PORT=3306; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword; OPTION=3; "OLE DB, OleDbConnection (.NET)标准"Provider=MySQLProv; Data Source=mydb; User Id=UserName; Password=asdasd; "Connector/Net 1.0 (.NET)标准"Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; "
Download the driver at MySQL Developer Zone指定端口"Server=Server; Port=1234; Database=Test; Uid=UserName; Pwd=asdasd; "
Default port is 3306. Enter value -1 to use a named pipe connection.定义mysqlclient 连接对象C#:
using MySql.Data.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; ";
oMySqlConn.Open();VB.NET:
Imports MySql.Data.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; "
oMySqlConn.Open()MySqlConnection (.NET)eInfoDesigns.dbProvider"Data Source=server; Database=mydb; User ID=username; Password=pwd; Command Logging=false"
This one is used with eInfoDesigns dbProvider, an add-on to .NET定义MySqlConnection连接对象C#:
using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connection string";
oMySqlConn.Open();VB.NET:
Imports eInfoDesigns.dbProvider.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connection string"
oMySqlConn.Open()SevenObjects MySqlClient (.NET)标准"Host=server; UserName=myusername; Password=mypassword; Database=mydb; "
This is a freeware ADO.Net data provider from SevenObjectsCore Labs MySQLDirect (.NET)标准"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" InterbaseODBC, Easysoft本地计算机"Driver={Easysoft IB6 ODBC}; Server=localhost; Database=localhost:C:/mydatabase.gdb; Uid=username; Pwd=password"远程计算机"Driver={Easysoft IB6 ODBC}; Server=ComputerName; Database=ComputerName:C:/mydatabase.gdb; Uid=username; Pwd=password"ODBC, Intersolv本地计算机"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)}; Server=localhost; Database=localhost:C:/mydatabase.gdb; Uid=username; Pwd=password"远程计算机"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)}; Server=ComputerName; Database=ComputerName:C:/mydatabase.gdb; Uid=username; Pwd=password"OLE DB, SIBPROvider标准"provider=sibprovider; location=localhost:; data source=c:/databases/gdbs/mygdb.gdb; user id=SYSDBA; password=masterkey"指定字符集"provider=sibprovider; location=localhost:; data source=c:/databases/gdbs/mygdb.gdb; user id=SYSDBA; password=masterkey; character set=ISO8859_1"指定规则"provider=sibprovider; location=localhost:; data source=c:/databases/gdbs/mygdb.gdb; user id=SYSDBA; password=masterkey; role=DIGITADORES" IBM DB2OLE DB, OleDbConnection (.NET) from msTCP/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"IBM's OLE DB Provider (shipped with IBM DB2 UDB v7 or above)TCP/IP"Provider=IBMDADB2; Database=sample; HOSTNAME=db2host; PROTOCOL=TCPIP; PORT=50000; uid=myUserName; pwd=myPwd;"ODBC标准"driver={IBM DB2 ODBC DRIVER}; Database=myDbName; hostname=myServerName; port=myPortNum; protocol=TCPIP; uid=myUserName; pwd=myPwd"5SybaseODBC标准 Sybase System 12 (or 12.5) Enterprise Open Client"Driver={SYBASE ASE ODBC Driver}; Srvr=Aron1; Uid=username; Pwd=password"标准 Sybase System 11"Driver={SYBASE SYSTEM 11}; Srvr=Aron1; Uid=username; Pwd=password; Database=mydb"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="""""OLE DBAdaptive 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"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 -
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() InformixODBCInformix 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 DBIBM Informix OLE DB Provider"Provider=Ifxoledbc.2; password=myPw; User ID=myUser; Data Source=dbName@serverName; Persist Security Info=true" IngresODBCDSN-less"Provider=MSDASQL.1; DRIVER=Ingres; SRVR=xxxxx; DB=xxxxx; Persist Security Info=False; uid=xxxx; pwd=xxxxx; SELECTLOOPS=N; Extended Properties="""SERVER=xxxxx; DATABASE=xxxxx; SERVERTYPE=INGRES"" Mimer SQLODBC标准安全"Driver={MIMER}; Database=mydb; Uid=myuser; Pwd=mypw; "提示输入用户名和密码"Driver={MIMER}; Database=mydb;" Lightbase标准标准"user=USERLOGIN; password=PASSWORD; UDB=USERBASE; server=SERVERNAME" PostgreSQLCore Labs PostgreSQLDirect (.NET)标准"User ID=root; Password=pwd; Host=localhost; Port=5432; Database=testdb; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"PostgreSQL driver标准"DRIVER={PostgreSQL}; SERVER=ipaddress; port=5432; DATABASE=dbname; UID=username; PWD=password; "Npgsql by pgFoundry (.NET)SSL activated"Server=127.0.0.1; Port=5432; Userid=myuserid; password=mypw; Protocol=3; SSL=true; Pooling=true; MinPoolSize=3; MaxPoolSize=20; Encoding=UNICODE; Timeout=20; SslMode=Require"Without SSL"Server=127.0.0.1; Port=5432; Userid=myuserid; password=mypw; Protocol=3; SSL=false; Pooling=true; MinPoolSize=1; MaxPoolSize=20; Encoding=UNICODE; Timeout=15; SslMode=Disable" ParadoxODBC5.X"Driver={Microsoft Paradox Driver (*.db )}; DriverID=538; Fil=Paradox 5.X; DefaultDir=c:/pathToDb/; Dbq=c:/pathToDb/; CollatingSequence=ASCII"7.X"Provider=MSDASQL.1; Persist Security Info=False; Mode=Read; Extended Properties='DSN=Paradox; DBQ=C:/myDb; DefaultDir=C:/myDb; DriverId=538; FIL=Paradox 7.X; MaxBufferSize=2048; PageTimeout=600; '; Initial Catalog=C:/myDb"OleDbConnection (.NET)标准"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/myDb; Extended Properties=Paradox 5.x;" DNSODBCDSN"DSN=myDsn; Uid=username; Pwd=; "File DSN"FILEDSN=c:/myData.dsn; Uid=username; Pwd=;"6FirebirdODBC - IBPhoenix Open Source标准"DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=masterkey; DBNAME=D:/FIREBIRD/examples/TEST.FDB".NET - Firebird .Net Data Provider标准"User=SYSDBA; Password=masterkey; Database=SampleDatabase.fdb; DataSource=localhost; Port=3050; Dialect=3; Charset=NONE; Role=; Connection lifetime=15; Pooling=true; MinPoolSize=0; MaxPoolSize=50; Packet Size=8192; ServerType=0" ExcelODBC标准"Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=C:/MyExcel.xls; DefaultDir=c:/mypath; "OLE DB标准"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. TextODBC标准"Driver={Microsoft Text Driver (*.txt; *.csv)}; Dbq=c:/txtFilesFolder/; Extensions=asc,csv,tab,txt; "OLE DB标准"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 / FoxProODBC标准"Driver={Microsoft dBASE Driver (*.dbf)}; DriverID=277; Dbq=c:/mydbpath; "OLE DB, OleDbConnection (.NET)标准"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/folder; Extended Properties=dBASE IV; User ID=Admin; Password=" AS/400 (iSeries)OLE DB, OleDbConnection (.NET)IBM Client Access OLE DB provider"PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME; USER ID=myUserName; PASSWORD=myPwd"IBM Client Access OLE DB provider"PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME; USER ID=myUserName; PASSWORD=myPwd; DEFAULT COLLECTION=MY_LIBRARY; "ODBCIBM Client Access ODBC driver"Driver={Client Access ODBC Driver (32-bit)}; System=my_system_name; Uid=myUserName; Pwd=myPwd" ExchangeOLE DBExchange OLE DB provider"ExOLEDB.DataSource"
Specify store in the connection open command like this: conn.open "http://servername/mypublicstore" Visual FoxProOLE DB, OleDbConnection (.NET)Database container (.DBC)"Provider=vfpoledb.1; Data Source=C:/MyDbFolder/MyDbContainer.dbc; Collating Sequence=machine"Free table directory"Provider=vfpoledb.1; Data Source=C:/MyDataDirectory/; Collating Sequence=general"Force the provider to use an ODBC DSN"Provider=vfpoledb.1; DSN=MyDSN"ODBCDatabase container (.DBC)"Driver={Microsoft Visual FoxPro Driver}; SourceType=DBC; SourceDB=c:/myvfpdb.dbc; Exclusive=No; NULL=NO; Collate=Machine; BACKGROUNDFETCH=NO; DELETED=NO"Free Table directory"Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF; SourceDB=c:/myvfpdbfolder;Exclusive=No; Collate=Machine; NULL=NO; DELETED=NO; BACKGROUNDFETCH=NO" PervasiveODBC标准:"Driver={Pervasive ODBC Client Interface}; ServerName=srvname; dbq=@dbname"OLD DB标准:"Provider=PervasiveOLEDB; Data Source=C:/path" UDLUDLUDL"File Name=c:/myDataLink.udl;"
This one's from Microsoft, the following are from Oracle标准安全"Provider=OraOLEDB.Oracle; Data Source=MyOracleDB; User Id=Username; Password=asdasd; "信任的连接"Provider=OraOLEDB.Oracle; Data Source=MyOracleDB; OSAuthent=1; "OracleConnection (.NET)标准"Data Source=MyOracleDB; Integrated Security=yes; "
This one works only with Oracle 8i release 3 or later指定用户名和密码"Data Source=MyOracleDB; User Id=username; Password=passwd; Integrated Security=no; "
This one works only with Oracle 8i release 3 or later定义OracleConnection对象C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connection string";
oOracleConn.Open();VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connection string"
oOracleConn.Open()Core Labs OraDirect (.NET)标准"User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"Data Shape微软数据模型"Provider=MSDataShape.1; Persist Security Info=False; Data Provider=MSDAORA; Data Source=orac; user id=username; password=mypw"4MySQLMyODBCMyODBC 2.50 本地数据库"Driver={mySQL}; Server=localhost; Option=16834; Database=mydatabase; "MyODBC 2.50 远程数据库:"Driver={mySQL}; Server=data.domain.com; Port=3306; Option=131072; Stmt=; Database=my-database; Uid=username; Pwd=password; "MyODBC 3.51 本地数据库"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword; OPTION=3; "MyODBC 3.51 远程数据库"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=data.domain.com; PORT=3306; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword; OPTION=3; "OLE DB, OleDbConnection (.NET)标准"Provider=MySQLProv; Data Source=mydb; User Id=UserName; Password=asdasd; "Connector/Net 1.0 (.NET)标准"Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; "
Download the driver at MySQL Developer Zone指定端口"Server=Server; Port=1234; Database=Test; Uid=UserName; Pwd=asdasd; "
Default port is 3306. Enter value -1 to use a named pipe connection.定义mysqlclient 连接对象C#:
using MySql.Data.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; ";
oMySqlConn.Open();VB.NET:
Imports MySql.Data.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; "
oMySqlConn.Open()MySqlConnection (.NET)eInfoDesigns.dbProvider"Data Source=server; Database=mydb; User ID=username; Password=pwd; Command Logging=false"
This one is used with eInfoDesigns dbProvider, an add-on to .NET定义MySqlConnection连接对象C#:
using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connection string";
oMySqlConn.Open();VB.NET:
Imports eInfoDesigns.dbProvider.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connection string"
oMySqlConn.Open()SevenObjects MySqlClient (.NET)标准"Host=server; UserName=myusername; Password=mypassword; Database=mydb; "
This is a freeware ADO.Net data provider from SevenObjectsCore Labs MySQLDirect (.NET)标准"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" InterbaseODBC, Easysoft本地计算机"Driver={Easysoft IB6 ODBC}; Server=localhost; Database=localhost:C:/mydatabase.gdb; Uid=username; Pwd=password"远程计算机"Driver={Easysoft IB6 ODBC}; Server=ComputerName; Database=ComputerName:C:/mydatabase.gdb; Uid=username; Pwd=password"ODBC, Intersolv本地计算机"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)}; Server=localhost; Database=localhost:C:/mydatabase.gdb; Uid=username; Pwd=password"远程计算机"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)}; Server=ComputerName; Database=ComputerName:C:/mydatabase.gdb; Uid=username; Pwd=password"OLE DB, SIBPROvider标准"provider=sibprovider; location=localhost:; data source=c:/databases/gdbs/mygdb.gdb; user id=SYSDBA; password=masterkey"指定字符集"provider=sibprovider; location=localhost:; data source=c:/databases/gdbs/mygdb.gdb; user id=SYSDBA; password=masterkey; character set=ISO8859_1"指定规则"provider=sibprovider; location=localhost:; data source=c:/databases/gdbs/mygdb.gdb; user id=SYSDBA; password=masterkey; role=DIGITADORES" IBM DB2OLE DB, OleDbConnection (.NET) from msTCP/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"IBM's OLE DB Provider (shipped with IBM DB2 UDB v7 or above)TCP/IP"Provider=IBMDADB2; Database=sample; HOSTNAME=db2host; PROTOCOL=TCPIP; PORT=50000; uid=myUserName; pwd=myPwd;"ODBC标准"driver={IBM DB2 ODBC DRIVER}; Database=myDbName; hostname=myServerName; port=myPortNum; protocol=TCPIP; uid=myUserName; pwd=myPwd"5SybaseODBC标准 Sybase System 12 (or 12.5) Enterprise Open Client"Driver={SYBASE ASE ODBC Driver}; Srvr=Aron1; Uid=username; Pwd=password"标准 Sybase System 11"Driver={SYBASE SYSTEM 11}; Srvr=Aron1; Uid=username; Pwd=password; Database=mydb"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="""""OLE DBAdaptive 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"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,following fully qualified connection strings to be used without definingfony .IDS Data Source files.
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() InformixODBCInformix 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 DBIBM Informix OLE DB Provider"Provider=Ifxoledbc.2; password=myPw; User ID=myUser; Data Source=dbName@serverName; Persist Security Info=true" IngresODBCDSN-less"Provider=MSDASQL.1; DRIVER=Ingres; SRVR=xxxxx; DB=xxxxx; Persist Security Info=False; uid=xxxx; pwd=xxxxx; SELECTLOOPS=N; Extended Properties="""SERVER=xxxxx; DATABASE=xxxxx; SERVERTYPE=INGRES"" Mimer SQLODBC标准安全"Driver={MIMER}; Database=mydb; Uid=myuser; Pwd=mypw; "提示输入用户名和密码"Driver={MIMER}; Database=mydb;" Lightbase标准标准"user=USERLOGIN; password=PASSWORD; UDB=USERBASE; server=SERVERNAME" PostgreSQLCore Labs PostgreSQLDirect (.NET)标准"User ID=root; Password=pwd; Host=localhost; Port=5432; Database=testdb; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"PostgreSQL driver标准"DRIVER={PostgreSQL}; SERVER=ipaddress; port=5432; DATABASE=dbname; UID=username; PWD=password; "Npgsql by pgFoundry (.NET)SSL activated"Server=127.0.0.1; Port=5432; Userid=myuserid; password=mypw; Protocol=3; SSL=true; Pooling=true; MinPoolSize=3; MaxPoolSize=20; Encoding=UNICODE; Timeout=20; SslMode=Require"Without SSL"Server=127.0.0.1; Port=5432; Userid=myuserid; password=mypw; Protocol=3; SSL=false; Pooling=true; MinPoolSize=1; MaxPoolSize=20; Encoding=UNICODE; Timeout=15; SslMode=Disable" ParadoxODBC5.X"Driver={Microsoft Paradox Driver (*.db )}; DriverID=538; Fil=Paradox 5.X; DefaultDir=c:/pathToDb/; Dbq=c:/pathToDb/; CollatingSequence=ASCII"7.X"Provider=MSDASQL.1; Persist Security Info=False; Mode=Read; Extended Properties='DSN=Paradox; DBQ=C:/myDb; DefaultDir=C:/myDb; DriverId=538; FIL=Paradox 7.X; MaxBufferSize=2048; PageTimeout=600; '; Initial Catalog=C:/myDb"OleDbConnection (.NET)标准"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/myDb; Extended Properties=Paradox 5.x;" DNSODBCDSN"DSN=myDsn; Uid=username; Pwd=; "File DSN"FILEDSN=c:/myData.dsn; Uid=username; Pwd=;"6FirebirdODBC - IBPhoenix Open Source标准"DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=masterkey; DBNAME=D:/FIREBIRD/examples/TEST.FDB".NET - Firebird .Net Data Provider标准"User=SYSDBA; Password=masterkey; Database=SampleDatabase.fdb; DataSource=localhost; Port=3050; Dialect=3; Charset=NONE; Role=; Connection lifetime=15; Pooling=true; MinPoolSize=0; MaxPoolSize=50; Packet Size=8192; ServerType=0" ExcelODBC标准"Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=C:/MyExcel.xls; DefaultDir=c:/mypath; "OLE DB标准"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. TextODBC标准"Driver={Microsoft Text Driver (*.txt; *.csv)}; Dbq=c:/txtFilesFolder/; Extensions=asc,csv,tab,txt; "OLE DB标准"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 / FoxProODBC标准"Driver={Microsoft dBASE Driver (*.dbf)}; DriverID=277; Dbq=c:/mydbpath; "OLE DB, OleDbConnection (.NET)标准"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/folder; Extended Properties=dBASE IV; User ID=Admin; Password=" AS/400 (iSeries)OLE DB, OleDbConnection (.NET)IBM Client Access OLE DB provider"PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME; USER ID=myUserName; PASSWORD=myPwd"IBM Client Access OLE DB provider"PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME; USER ID=myUserName; PASSWORD=myPwd; DEFAULT COLLECTION=MY_LIBRARY; "ODBCIBM Client Access ODBC driver"Driver={Client Access ODBC Driver (32-bit)}; System=my_system_name; Uid=myUserName; Pwd=myPwd" ExchangeOLE DBExchange OLE DB provider"ExOLEDB.DataSource"
Specify store in the connection open command like this: conn.open "http://servername/mypublicstore" Visual FoxProOLE DB, OleDbConnection (.NET)Database container (.DBC)"Provider=vfpoledb.1; Data Source=C:/MyDbFolder/MyDbContainer.dbc; Collating Sequence=machine"Free table directory"Provider=vfpoledb.1; Data Source=C:/MyDataDirectory/; Collating Sequence=general"Force the provider to use an ODBC DSN"Provider=vfpoledb.1; DSN=MyDSN"ODBCDatabase container (.DBC)"Driver={Microsoft Visual FoxPro Driver}; SourceType=DBC; SourceDB=c:/myvfpdb.dbc; Exclusive=No; NULL=NO; Collate=Machine; BACKGROUNDFETCH=NO; DELETED=NO"Free Table directory"Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF; SourceDB=c:/myvfpdbfolder;Exclusive=No; Collate=Machine; NULL=NO; DELETED=NO; BACKGROUNDFETCH=NO" PervasiveODBC标准:"Driver={Pervasive ODBC Client Interface}; ServerName=srvname; dbq=@dbname"OLD DB标准:"Provider=PervasiveOLEDB; Data Source=C:/path" UDLUDLUDL"File Name=c:/myDataLink.udl;"
- ADO.NET连接数据库字符串
- ADO.NET连接数据库字符串
- ADO.NET连接数据库字符串
- ADO.NET连接数据库字符串
- ADO.NET连接数据库字符串
- ADO.NET 连接字符串
- ADO.NET连接字符串
- ADO.NET 连接字符串
- ADO.NET连接字符串
- ADO.NET连接字符串
- ADO.NET连接字符串
- ADO.NET连接字符串
- ADO.NET连接字符串
- ADO.NET连接字符串
- 数据库ADO连接字符串
- ADO.Net-数据库的连接-连接字符串的格式---ShinePans
- ADO.NET连接数据库
- 连接数据库Ado.net
- actionscript 中 如何控制数字精度(小数位数)
- Ext智能提示 - Spket(Visual Studio 2008 插件)
- 用nginx+tomcat来代替apache+jk+tomcat
- 使用mysqlbinlog工具恢复数据
- 嵌入式Linux驱动程序开发要点
- ADO.NET连接数据库字符串
- C# Winform DataGridView实现行[Row]的上下移动........
- Linux字符设备驱动程序的编写框架
- Same org.omg.CORBA.Object with different IOR string expression
- 终端融合:GOOGLE的三合一竞争法
- 传真机常见故障中英文说明
- 如何合理创建c#对象
- 用Java实现断点续传(HTTP)
- 数据库面试题集