数据库连接代码大全
codev常用代码
codev常用代码Codev常用代码一、介绍在编程过程中，我们经常会使用一些常用的代码片段来实现特定的功能。
这些常用代码可以帮助我们节省时间和精力，提高开发效率。
在Codev平台上，也有一些常用的代码片段被广泛使用。
本文将介绍一些Codev常用代码，并对其功能和用法进行详细说明。
二、代码示例1. 数据库连接代码数据库连接是编写应用程序时经常需要使用的代码。
在Codev中，我们可以使用以下代码来连接数据库：```import pymysqlconn = pymysql.connect(host='localhost', user='root', password='123456', database='testdb')```这段代码使用pymysql库来连接MySQL数据库。
其中，host参数指定数据库的主机地址，user参数指定用户名，password参数指定密码，database参数指定要连接的数据库名。
通过调用`pymysql.connect()`方法，我们可以获取到数据库的连接对象`conn`。
2. 文件读取代码在处理文件时，我们经常需要读取文件的内容。
在Codev中，可以使用以下代码来读取文件：```with open('file.txt', 'r') as file:content = file.read()```这段代码使用`open()`函数打开名为`file.txt`的文件，并指定文件的打开模式为`'r'`，表示只读模式。
然后，通过调用`file.read()`方法，我们可以将文件的内容读取到变量`content`中。
3. 数据排序代码对数据进行排序是常见的需求。
在Codev中，可以使用以下代码来对数据进行排序：```data = [3, 1, 2, 5, 4]sorted_data = sorted(data)```排序后的结果赋值给变量`sorted_data`。
c语言数据库连接
1."+="后面的"@"符号是防止将后面字符串中的"\"解析为转义字符. 2.如果要连接的数据库文件和当前文件在同一个目录下,还可以使用如下的方法连接: strConnection+="Data Source="; strConnection+=MapPath("Northwind.mdb"); 这样就可以省得你写一大堆东西了! 3.要注意连接字符串中的参数之间要用分号来分隔. "OleDbConnection objC OleDbConnection(strConnection);"这一句是利用定义好的连接字符串来建立了一 个链接对象,以后对数据库的操作我们都要和这个对象打交道. "objConnection.Open();"这用来打开连接.至此,与Access数据库的连接完成. -------------------------------------------------------------------------------2.C#连接SQL Server 程序代码: -------------------------------------------------------------------------------using System.Data; using System.Data.SqlClient; ... string strC; strConnection+="initial catalog=Northwind;Server=YourSQLServer;"; strConnection+="Connect Timeout=30"; SqlConnection objC SqlConnection(strConnection); ... objConnection.Open(); objConnection.Close(); ... --------------------------------------------------------------------------------
Mysql数据库连接、查询、记录集操作代码
Mysql数据库连接、查询、记录集操作代码Mysql数据库链接代码function dbConnect($hostname,$username,$pass,$db_name,$pconnect =0){$func=empty($pconnect) ? 'mysql_connect':'mysql_pconnect';if(!$connect){$connect=@$func($hostname,$username,$pass) or die("<font size='2'>Mysql_Error : ".mysql_error()."<br>Mysql Error Num : ".mysql_errno()."</font>");}@mysql_select_db($db_name,$connect) or die("<font size='2'> Mysql_Error : ".mysql_error()."<br>Mysql Error Num : ".mysql_errno()."</font>");return $connect;}注释：参数$hostname,$username,$pass,$db_name分别代表Mysql数据库服务器地址，⽤户名，密码，以及连接的数据库名，通常情况下hostname⼀般都是localhost或者127.0.0.1。
参数$pconnect默认为0，表⽰通常情况下是以 mysql_connect函数连接Mysql数据库。
知识点：mysql_connect与mysql_pconnect的区别：当执⾏完当前PHP程序后，PHP⾃动关闭mysql_connect建⽴的数据库连接，⽽mysql_pconnect返回⼀个持久稳固的数据库连接，在⼀定时间内有下⼀个连接请求时可以被复⽤，节省了反复连接Mysql数据库的时间，使得访问速度加快，其适⽤于并发访问量不⼤的情况，如并发访问量⽐较⼤，则可能会因为Mysql已达到最⼤连接数, 使之后的请求得不到满⾜。
数据库连接代码大全
-----------MySQL 连接方式-----------MySQL Connector/ODBC 2.50 (MyODBC 2.50)连接方式本地数据库连接Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;远程数据连接：Driver={mySQL};Server=myServerAddress;Option=131072;Stmt=;Database=myDataBas e; User=myUsername;Password=myPassword;特殊的TCP/IP端口连接Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=;Database= myDataBase; User=myUsername;Password=myPassword;说明：此Driver的默认端口是3306。
如果没有在连接字符串中特别指出就是连接Mysql的3306端口。
MySQL Connector/ODBC 3.51 (MyODBC 3.51)连接方式本地数据库连接Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;远程数据连接Driver={MySQL ODBC 3.51Driver};Server=;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;特殊的TCP/IP端口连接Driver={MySQL ODBC 3.51Driver};Server=;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;说明：此Driver的默认端口是3306。
javaide、连接mysql数据库的代码
javaide、连接mysql数据库的代码在JavaIDE中连接MySQL数据库需要先下载MySQL的JDBC驱动程序，并将其添加到项目的构建路径中。
然后，在代码中使用以下步骤连接MySQL数据库：1. 导入必要的类。
import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;2. 声明数据库连接变量和数据库连接信息。
Connection conn = null;String url ='jdbc:mysql://localhost:3306/database_name';String user = 'username';String password = 'password';3. 注册驱动程序并创建连接。
try {Class.forName('com.mysql.jdbc.Driver');conn = DriverManager.getConnection(url, user, password); } catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}4. 检查连接是否成功。
if (conn != null) {System.out.println('Database connected');} else {System.out.println('Database not connected');}注意：在连接数据库时，需要将 'database_name' 替换为实际数据库名称；'username' 和 'password' 替换为实际数据库用户和密码。
ASP.NETC#各种数据库连接字符串大全——SQLServer、Oracle、Access
C#各种数据库连接字符串⼤全——SQLServer、Oracle、Access 刚开始学习C#开发项⽬时，长期会为了写⼀个安全的⾼效的数据库连接发愁。
我发现现在很多刚开始学习的朋友和有些做了⼀两年的朋友，也有点犯愁，我就贴上这个代码，给⾃⼰以后做个参考，也给朋友做个学习的参考。
我主要在这⾥统计了.NET项⽬下常⽤的数据库连接字符串：SQLServer、Oracle、Access三种数据库（MySql、SQLLite、Excel、HTML Table等等暂不列⼊）。
⼀、常⽤连接字符串参数说明如需查看详细说明请参见：关键字默认描述Server 或 Data Source N/A要连接的数据库实例的名称或⽹络地址(可以在名称后指定端⼝号),指定本地实例可⽤(Local),如果是SqlExpress(名称\SqlExpress)。
Initial Catalog 或 Database N/A数据库的名称。
User ID 或 UID N/A登录帐户。
Password 或 Pwd N/A帐户登录的密码。
Persist Security Info 'false'当该值设置为 false 或 no（强烈推荐）时，如果连接是打开的或者⼀直处于打开状态，那么安全敏感信息（如密码）将不会作为连接的⼀部分返回。
重置连接字符串将重置包括密码在内的所有连接字符串值。
可识别的值为 true、false、yes 和 no。
Enlist 'false'true 表明连接池程序在创建线程的当前事务上下⽂中⾃动登记连接。
可识别的值为 true、false、yes 和 no。
Connection Lifetime 0当连接被返回到池时，将其创建时间与当前时间作⽐较，如果时间长度（以秒为单位）超出了由 Connection Lifetime 指定的值，该连接就会被销毁。
这在聚集配置中很有⽤（⽤于强制执⾏运⾏中的服务器和刚置于联机状态的服务器之间的负载平衡）。
dbvisualizer 数据库连接源代码
dbvisualizer是一个功能强大的数据库管理和开发工具。
在dbvisualizer中，您可以使用多种编程语言和协议（如JDBC、ODBC、数据库连接字符串等）来连接到各种数据库。
如果您正在寻找使用dbvisualizer进行数据库连接的源代码，我可以为您提供一些示例。
例如，使用JDBC连接到MySQL数据库的示例代码如下：
```java
import java.sql.*;
public class Main {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "myusername";
String password = "mypassword";
try (Connection conn = DriverManager.getConnection(url, username, password)) {
System.out.println("Connected to the database!");
} catch (SQLException e) {
System.out.println("Connection failed: " +
e.getMessage());
}
}
}
```
如果您正在使用其他编程语言或协议连接到数据库，请提供更多详细信息，我将尽力提供帮助。
几种常见的数据库连接方法
几种常见的数据库连接方法一、连接Access数据库1.使用已有DSN的连接字符串进行连接（ODBC）使用DSN进行连接〃导入命名空间using System.Data.Odbc;protected void Page_Load(Object sender,EventArgs e)(〃设置连接字符串String connstr=@"DSN=sample";〃实例化Connection对象OdbcConnection myConnection = new OdbcConnection(connstr);〃执行Open方法打开连接myConnection.Open();〃执行SQL语句OdbcCommand myCommand new OdbcCommand("select * from sampletable",myConnection);〃将查询的结果赋给GridView的数据源gv.DataSource = myCommand.ExecuteReader();〃绑定GridViewgv.DataBind();〃关闭连接myConnection.Close();)2.使用无DSN的连接字符串进行连接（ODBC）不使用DSN进行连接〃导入命名空间using System.Data.Odbc;protected void Page_Load(Object sender,EventArgs e)(〃设置连接字符串String connstr=@"Driver=Microsoft Access Driver (*.mdb);Dbq=c:\sample.mdb;";〃实例化Connection对象OdbcConnection myConnection = new OdbcConnection(connstr);〃执行Open方法打开连接myConnection.Open();〃执行SQL语句OdbcCommand myCommand new OdbcCommand("select * from sampletable",myConnection);〃将查询的结果赋给GridView的数据源gv.DataSource = myCommand.ExecuteReader();〃绑定GridViewgv.DataBind();〃关闭连接myConnection.Close();)3.使用连接字符串进行连接(OLEDB) Data Provider 支持的OLEDB Provider：SQLOLEDB：用来访问SQL Server数据库MSDAORA：用来访问Oracle数据库Microsoft.Jet.OLEDB.4.0：用来访问Access 数据库。
php基本代码大全
if($startpage>0)
echo " ... <b><a href=$PHP_SELF?page=".($page-$shownum*2)."$queryString>?</a></b>";
?>
<?php
mysql_close();
?>
4、服务器端包含
<?php require_once('conn.php'); ?>
5、如何将一条记录写入数据库，然后提示并跳转页面
<?php
$ly_title=$_POST["ly_title"];
$ly_content=$_POST["ly_content"];
$ly_time=$_POST["ly_time"];
$ly_author=$_POST["ly_author"];
$ly_email=$_POST["ly_email"];
$sql="update liuyan set ly_title='$ly_title',ly_content='$ly_content',ly_time='$ly_time',ly_author='$ly_author',ly_email='$ly_email' where ly_id=$_GET[id]";
cmd命令窗口连接mysql的命令大全
cmd命令窗⼝连接mysql的命令⼤全连接：mysql -h主机地址 -u⽤户名－p⽤户密码（注:u与root可以不⽤加空格，其它也⼀样）断开：exit （回车）创建授权：grant select on 数据库.* to ⽤户名@登录主机 identified by \"密码\"修改密码：mysqladmin -u⽤户名 -p旧密码 password 新密码删除授权: revoke select,insert,update,delete om *.* fromtest2@localhost;显⽰数据库：show databases;显⽰数据表：show tables;显⽰表结构：describe 表名;创建库：create database 库名;删除库：drop database 库名;使⽤库：use 库名;创建表：create table 表名 (字段设定列表);删除表：drop table 表名;修改表：alter table t1 rename t2查询表：select * from 表名;清空表：delete from 表名;备份表: mysqlbinmysqldump -h(ip) -uroot -p(password) databasenametablename > tablename.sql恢复表: mysqlbinmysql -h(ip) -uroot -p(password) databasenametablename < tablename.sql（操作前先把原来表删除）增加列：ALTER TABLE t2 ADD c INT UNSIGNED NOT NULL AUTO_INCREMENT,ADDINDEX (c);修改列：ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b cCHAR(20);删除列：ALTER TABLE t2 DROP COLUMN c;备份数据库：mysql\bin\mysqldump -h(ip) -uroot -p(password) databasename> database.sql恢复数据库：mysql\bin\mysql -h(ip) -uroot -p(password) databasename< database.sql复制数据库：mysql\bin\mysqldump --all-databases >all-databases.sql修复数据库：mysqlcheck -A -o -uroot -p54safer⽂本数据导⼊： load data local infile \"⽂件名\" into table 表名;数据导⼊导出：mysql\bin\mysqlimport database tables.txt第⼀招、mysql服务的启动和停⽌net stop mysqlnet start mysql第⼆招、登陆mysql语法如下： mysql -u⽤户名-p⽤户密码键⼊命令mysql -uroot -p，回车后提⽰你输⼊密码，输⼊12345，然后回车即可进⼊到mysql中了，mysql的提⽰符是：mysql>注意，如果是连接到另外的机器上，则需要加⼊⼀个参数-h机器IP第三招、增加新⽤户格式：grant 权限 on 数据库.* to ⽤户名@登录主机 identified by "密码"如，增加⼀个⽤户user1密码为password1，让其可以在本机上登录，并对所有数据库有查询、插⼊、修改、删除的权限。
jdbc+代码oracle数据库连接,JDBC连接Oracle数据库代码
jdbc+代码oracle数据库连接,JDBC连接Oracle数据库代码import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestOracle {public static void main(String[] args) {Connection conn = null;Statement stmt = null;ResultSet rs = null;try {Class.forName("oracle.jdbc.driver.OracleDriver");//实例化oracle数据库驱动程序(建⽴中间件)String url = "jdbc:oracle:thin:@localhost:1521:oar92";//@localhost为服务器名，sjzwish为数据库实例名conn = DriverManager.getConnection(url, "guchao", "jimmy");//连接数据库，a代表帐户,a代表密码stmt = conn.createStatement();//提交sql语句,创建⼀个Statement对象来将SQL语句发送到数据库//查询数据⽤executeQueryrs = stmt.executeQuery("select * from ruby");//执⾏查询,(ruby)为表名while (rs.next()) {//使当前记录指针定位到记录集的第⼀条记录System.out.println(rs.getString("sid") +" "+ rs.getString("sname"));}//1代表当前记录的第⼀个字段的值，可以写成字段名。
sql server 2008数据库连接字符串大全
一、.NET Framework Data Provider for SQL Server类型：.NET Framework类库使用：System.Data.SqlClient.SqlConnection厂商：Microsoft1.标准安全连接复制代码代码如下:Data Source = myServerAddress;Initial Catalog = myDataBase;User Id = myUsername;Password = myPassword;使用服务器名\实例名作为连接指定SQL Server实例的数据源。
如果你使用的是SQL Server 2008 Express版，实例名为SQLEXPRESS。
2.可替代的标准安全连接复制代码代码如下:Server = myServerAddress;Database = myDataBase;User ID = myUsername;Password = myPassword;Trusted_Connection = False;这条连接字符串跟上一条效果一样。
把这条写出来只是想说，其实很多连接字符串的关键字有多种写法。
3.信任连接复制代码代码如下:Data Source = myServerAddress;Initial Catalog = myDataBase;Integrated Security = SSPI;可替代的信任连接复制代码代码如下:Server = myServerAddress;Database = myDataBase;Trusted_Connection = True;4.连接Windows CE设备的信任连接通常一台Windows CE设备在一个域里是不能被认证和登录的。
为了让一台CE设备使用SSPI或信任连接和认证，可以使用下面的连接字符串：复制代码代码如下:Data Source = myServerAddress;Initial Catalog = myDataBase;Integrated Security = SSPI;User ID = myDomain\myUsername;Password = myPassword;说明一下，这条语句只能在CE设备上用。
java连接数据库语句
java连接数据库语句在Java中，可以使用JDBC（Java Database Connectivity）来连接和操作数据库。
下面是连接数据库的常见语句示例：1. 加载数据库驱动：```javaClass.forName("com.mysql.jdbc.Driver");```2. 建立数据库连接：```javaString url = "jdbc:mysql://localhost:3306/mydatabase";String username = "root";String password = "password";Connection connection = DriverManager.getConnection(url, username, password);```其中，url是数据库的地址，username和password是登录数据库的用户名和密码。
3. 执行SQL查询或更新：```javaStatement statement = connection.createStatement();String sql = "SELECT * FROM mytable";ResultSet resultSet = statement.executeQuery(sql);``````javaString sql = "INSERT INTO mytable (column1, column2) VALUES ('value1', 'value2')";int rowsAffected = statement.executeUpdate(sql);```4. 处理结果集：```javawhile (resultSet.next()) {String column1 = resultSet.getString("column1");String column2 = resultSet.getString("column2");// 处理每一行数据}```5. 关闭数据库连接：```javaresultSet.close();statement.close();connection.close();```以上是连接和操作数据库的基本语句示例，具体的语句会根据使用的数据库类型、需要执行的SQL语句和具体业务需求进行调整。
SQL数据库ODBC连接错误代码集合
CodeError Mess age 0 操作成功完成。
1 功能错误。
2 系统找不到指定的文件。
3 系统找不到指定的路径。
4 系统无法打开文件。
5拒绝访问。
6句柄无效。
7 存储控制块被损坏。
8 存储空间不足，无法处理此命令。
9存储控制块地址无效。
10环境错误。
11试图加载格式错误的程序。
12 访问码无效。
13 数据无效。
14 存储器不足，无法完成此操作。
15 系统找不到指定的驱动器。
16无法删除目录。
17 系统无法将文件移到不同的驱动器。
18 没有更多文件。
19介质受写入保护。
20 系统找不到指定的设备。
21 设备未就绪。
22设备不识别此命令。
23 数据错误(循环冗余检查)。
24 程序发出命令，但命令长度不正确。
25 驱动器无法找出磁盘上特定区域或磁道的位置。
26无法访问指定的磁盘或软盘。
27 驱动器找不到请求的扇区。
28打印机缺纸。
29系统无法写入指定的设备。
30 系统无法从指定的设备上读取。
31 连到系统上的设备没有发挥作用。
32 进程无法访问文件，因为另一个程序正在使用此文件。
33进程无法访问文件，因为另一个程序已锁定文件的一部分。
36 用来共享的打开文件过多。
38 到达文件结尾。
39磁盘已满。
50不支持网络请求。
51 远程计算机不可用。
52 在网络上已有重复的名称。
53找不到网络路径。
54 网络忙。
55 指定的网络资源或设备不再可用。
56 已到达网络B IOS 命令限制。
57 网络适配器硬件出错。
58 指定的服务器无法运行请求的操作。
59发生意外的网络错误。
60远程适配器不兼容。
61 打印机队列已满。
各种数据库连接代码
各种数据库连接代码MS Access数据库连接⽤DSN连接并且没有⽤户名和密码：<%set conn = Server.CreateObject("ADODB.Connection")conn.open "YourDSNName"%>⽤DSN连接并且有⽤户名和密码：<%set conn = Server.CreateObject("ADODB.Connection")conn.open "YourDSNName","username","password"%>⽤实际的数据库绝对路径连接：<%Set conn = Server.CreateObject("ADODB.Connection")Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "Strconn=Strconn & "DBQ=e:\yanhang\database.mdb"conn.Open Strconn%>⽤实际的数据库相对路径连接：<%Set conn = Server.CreateObject("ADODB.Connection")Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "Strconn=Strconn & "DBQ=" & Server.MapPath("/database/yanhang.mdb")conn.Open Strconn%>MS SQL Server数据库连接⽤DSN连接：<%set conn = Server.CreateObject("ADODB.Connection")conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename"%>不⽤DSN连接：<%Set conn = Server.CreateObject("ADODB.Connection")DSNtemp="DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=databasename" conn.open DSNtemp%>FoxPro数据库连接<%Set Conn = Server.CreateObject("ADODB.connection")ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=C:\yanhang\database.dbc" Conn.Open ConnStr%>Oracle数据库连接：<%set conn=server.createobject("adodb.connection")conn.cursorlocation=adUseClientDSNTemp="Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang;Data Source=xxx.world" conn.open DSNtemp%>。
数据库命令大全
数据库命令⼤全1、连接Mysql格式： mysql -h主机地址 -u⽤户名－p⽤户密码1、连接到本机上的MYSQL。
⾸先打开DOS窗⼝，然后进⼊⽬录mysql\bin，再键⼊命令mysql -u root -p，回车后提⽰你输密码.注意⽤户名前可以有空格也可以没有空格，但是密码前必须没有空格，否则让你重新输⼊密码。
如果刚安装好MYSQL，超级⽤户root是没有密码的，故直接回车即可进⼊到MYSQL中了，MYSQL的提⽰符是： mysql>2、连接到远程主机上的MYSQL。
假设远程主机的IP为：110.110.110.110，⽤户名为root,密码为abcd123。
则键⼊以下命令：mysql -h110.110.110.110 -u root -p 123;（注:u与root之间可以不⽤加空格，其它也⼀样）3、退出MYSQL命令： exit （回车）2、修改密码格式：mysqladmin -u⽤户名 -p旧密码 password 新密码1、给root加个密码ab12。
⾸先在DOS下进⼊⽬录mysql\bin，然后键⼊以下命令mysqladmin -u root -password ab12注：因为开始时root没有密码，所以-p旧密码⼀项就可以省略了。
2、再将root的密码改为djg345。
mysqladmin -u root -p ab12 password djg3453、增加新⽤户注意：和上⾯不同，下⾯的因为是MYSQL环境中的命令，所以后⾯都带⼀个分号作为命令结束符格式：grant select on 数据库.* to ⽤户名@登录主机 identified by “密码”1、增加⼀个⽤户test1密码为abc，让他可以在任何主机上登录，并对所有数据库有查询、插⼊、修改、删除的权限。
⾸先⽤root⽤户连⼊MYSQL，然后键⼊以下命令：grant select,insert,update,delete on *.* to [email=test1@”%]test1@”%[/email]” Identified by “abc”;但增加的⽤户是⼗分危险的，你想如某个⼈知道test1的密码，那么他就可以在internet上的任何⼀台电脑上登录你的mysql数据库并对你的数据可以为所欲为了，解决办法见2。
python与数据库连接的代码
python与数据库连接的代码Python中连接数据库的代码可以使用Python标准库中的sqlite3模块或者第三方库如MySQLdb、pymysql等。
以下示例使用SQLite作为示例数据库：1. 引入sqlite3模块```pythonimport sqlite3```2. 连接到数据库```pythonconn = sqlite3.connect('example.db')```3. 创建游标```pythoncursor = conn.cursor()```4. 执行SQL语句```python# 创建表格cursor.execute('''CREATE TABLE users(id INTEGER PRIMARY KEY,name TEXT,age INTEGER)''')# 插入数据cursor.execute("INSERT INTO users VALUES (1, 'Alice', 20)") # 提交更改mit()```5. 查询数据```python# 查询整个表格cursor.execute("SELECT * FROM users")rows = cursor.fetchall()for row in rows:print(row)```6. 关闭连接```pythonconn.close()```以上是Python连接SQLite数据库的简单代码示例。
使用其他数据库时，连接和操作方式可能有所不同，需要根据具体情况进行调整。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
数据库连接代码大全SQL ServerODBCStandard Security:"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"Trusted connection:"Driver={SQLServer};Server=Aron1;Database=pubs;Trusted_Connection=yes;"Prompt for username and password:oConn.Properties("Prompt") = adPromptAlwaysoConn.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") = adPromptAlwaysoConn.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;UserID=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();:Imports System.Data.SqlClientDim oSQLConn As SqlConnection = New SqlConnection()oSQLConn.ConnectionString="my connectionstring"oSQLConn.Open()Data ShapeMS Data Shape"Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog=pubs;User ID=sa;Password=asdasd;"Want to learn data shaping? Check out 4GuyfFromRolla's great article about Data Shaping >>Read moreHow to define which network protocol to useExample:"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;" Name Network librarydbnmpntw Win32 Named Pipesdbmssocn Win32 Winsock TCP/IPdbmsspxn Win32 SPX/IPXdbmsvinn Win32 Banyan Vinesdbmsrpcn Win32 Multi-Protocol (Windows RPC)Important note!When connecting through the SQLOLEDB provider use the syntax Network Library=dbmssocnand when connecting through MSDASQL provider use the syntaxNetwork=dbmssocnAll SqlConnection connectionstring propertiesThis table shows all connectionstring properties for the SqlConnection object. Most of the properties are also used in ADO. All properties and descriptions is from msdn.Name Default DescriptionApplication Name The name of the application, or '.Net SqlClient Data Provider' if no application name is provided.AttachDBFilename-or-extended properties-or-Initial File Name The name of the primary file, including the full path name, of an attachable database. The database name must be specified with the keyword 'database'.Connect Timeout-or-Connection Timeout 15 The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. Connection Lifetime 0 When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by connection lifetime. Useful in clustered configurations to force load balancing between a running server and a server just brought on-line.Connection Reset 'true' Determines whether the database connection is reset when being removed from the pool. Setting to 'false' avoids making an additional server round-trip when obtaining a connection, but the programmer must be aware that the connection state is not being reset.Current Language The SQL Server Language record name.Data Source-or-Server-or-Address-or-Addr-or-Network Address The name or network address of the instance of SQL Server to which to connect.Enlist 'true' When true, the pooler automatically enlists the connection in the creation thread's current transaction context.Initial Catalog-or-Database The name of the database.Integrated Security-or-Trusted_Connection 'false' Whether the connection is to be a secure connection or not. Recognized values are 'true', 'false', and 'sspi', which is equivalent to 'true'.Max Pool Size 100 The maximum number of connections allowed in the pool. Min Pool Size 0 The minimum number of connections allowed in the pool. Network Library-or-Net 'dbmssocn' The network library used to establish a connection to an instance of SQL Server. Supported values include dbnmpntw (Named Pipes), dbmsrpcn (Multiprotocol), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmsipcn (Shared Memory) and dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP).The corresponding network DLL must be installed on the system to which you connect. If you do not specify a network and you use a local server (for example, "." or "(local)"), shared memory is used.Packet Size 8192 Size in bytes of the network packets used to communicate with an instance of SQL Server.Password-or-Pwd The password for the SQL Server account logging on.Persist Security Info 'false' When set to 'false', security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password.Pooling 'true' When true, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool. User ID The SQL Server login account.Workstation ID the local computer name The name of the workstation connecting to SQL Server.NoteUse ; to separate each property.If a name occurs more than once, the value from the last one in the connectionstring will be used.If you are building your connectionstring in your app using values from user input fields, make sure the user can't change the connectionstring by inserting an additional property with another value within the user value.AccessODBCStandard 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;"OracleODBCNew 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=myPassw ord;"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 OracleStandard 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=MyOracleDB;Integrated Security=yes;"This one works only with Oracle 8i release 3 or laterSpecifying username and password:"Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated Security=no;"This one works only with Oracle 8i release 3 or laterDeclare the OracleConnection:C#:using System.Data.OracleClient;OracleConnection oOracleConn = new OracleConnection();oOracleConn.ConnectionString = "my connectionstring";oOracleConn.Open();:Imports System.Data.OracleClientDim oOracleConn As OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "my connectionstring"oOracleConn.Open()Missing the System.Data.OracleClient namespace? Download .NET Managed Provider for Oracle »Great article! "Features of Oracle Data Provider for .NET" by Rama Mohan G. at C# CornerCore Labs OraDirect (.NET)Standard:"User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"Read more at Core Lab and the product page.Data ShapeMS Data Shape:"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw" Want to learn data shaping? Check out 4GuyfFromRolla's great article about Data Shaping >>MySQLODBCODBC 2.50 Local database:"Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;"ODBC 2.50 Remote database:"Driver={mySQL};Server=;Port=3306;Option=131072;Stm t=;Database=my-database;Uid=username;Pwd=password;"ODBC 3.51 Local database:"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PAS SWORD=myPassword;OPTION=3;"ODBC 3.51 Remote database:"DRIVER={MySQL ODBC 3.51 Driver};SERVER=;PORT=3306;DATABASE=myDatabase;US ER=myUsername;PASSWORD=myPassword;OPTION=3;"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"This one is used with eInfoDesigns dbProvider, an add-on to .NETDeclare the MySqlConnection:C#:using eInfoDesigns.dbProvider.MySqlClient;MySqlConnection oMySqlConn = new MySqlConnection();oMySqlConn.ConnectionString = "my connectionstring";oMySqlConn.Open();:Imports eInfoDesigns.dbProvider.MySqlClientDim oMySqlConn As MySqlConnection = New MySqlConnection() oMySqlConn.ConnectionString = "my connectionstring"oMySqlConn.Open()SevenObjects MySqlClient (.NET)Standard:"Host=server; UserName=myusername; Password=mypassword;Database=mydb;"This is a freeware data provider from SevenObjectsCore 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"Read more at Core Lab and the product page.InterbaseODBC, EasysoftLocal computer:"Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=usern ame;Pwd=password"Remote Computer:"Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName:C:\mydatabase.g db;Uid=username;Pwd=password"Read more about this driver: Easysoft ODBC-Interbase driver >>ODBC, IntersolvLocal computer:"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=user name;Pwd=password"Remote Computer:"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=ComputerName;Database=ComputerName:C:\mydatabase. gdb;Uid=username;Pwd=password"This driver are provided by DataDirect Technologies >> (formerly Intersolv) OLE DB, SIBPROviderStandard:"provider=sibprovider;location=localhost:;datasource=c:\databases\gdbs\mygdb.gdb;userid=SYSDBA;password=masterkey"Specifying character set:"provider=sibprovider;location=localhost:;datasource=c:\databases\gdbs\mygdb.gdb;userid=SYSDBA;password=masterkey;character set=ISO8859_1"Specifying role:"provider=sibprovider;location=localhost:;datasource=c:\databases\gdbs\mygdb.gdb;userid=SYSDBA;password=masterkey;role=DIGITADORES"Read more about SIBPROvider >>Read more about connecting to Interbase in this Borland Developer Network article /article/0,1410,27152,00.htmlIBM 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=TC PIP;PORT=50000;uid=myUserName;pwd=myPwd;ODBCStandard:"driver={IBM DB2 ODBC DRIVER};Database=myDbName;hostname=myServerName;port=myPortNu m;protocol=TCPIP; uid=myUserName; pwd=myPwd"SybaseODBCStandard 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;" Do you know a userguide for Sybase System 11, 12, 12.5? E-mail the URL to now!! >>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=passwor d;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.Read more in the Sybase SQL Anywhere User Guide >>OLE DBAdaptive Server Anywhere (ASA):"Provider=ASAProv;Data source=myASA"Read more in the ASA User Guide >>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=myD Bname;User Id=username;Password=password"- some reports on problem using the above one, try the following as an alternative -"Provider=Sybase.ASEOLEDBProvider;ServerName=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:"DataSource='myASEserver';Port=5000;Database='myDBname';UID='username';P WD='password';"Declare the AseConnection:C#:using Sybase.Data.AseClient;AseConnection oCon = new AseConnection();oCon.ConnectionString="my connection string";oCon.Open();:Imports System.Data.AseClientDim 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=olso ctcp;Database=mydb;UID=username;PWD=myPwdInformix-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 SQLODBCStandard Security:"Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw;"Prompt for username and password:"Driver={MIMER};Database=mydb;"LightbaseStandardStandard:"user=USERLOGIN;password=PASSWORD;UDB=USERBASE;server=SERVERN AME"PostgreSQLCore 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"Read more at Core Lab and the product page.DSNODBCDSN:"DSN=myDsn;Uid=username;Pwd=;"File DSN:"FILEDSN=c:\myData.dsn;Uid=username;Pwd=;"FirebirdODBC - IBPhoenix Open SourceStandard:"DRIVER=Firebird/InterBase(r)driver;UID=SYSDBA;PWD=masterkey;DBNAME=D:\FIREBIRD\examples\TES T.FDB"IBPhoenix ODBC; More info, download etc >>.NET - Firebird .Net Data ProviderStandard:"User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSo urce=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;PacketSize=8192;ServerType=0"Firebird project >>Firebird downloads >>ExcelODBCStandard:"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.OLE DBStandard:"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.TextODBCStandard:"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;"OLE DBStandard:"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 dataDBF / FoxProODBCstandard:"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="AS/400OLE DBIBM Client Access OLE DB provider:"PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME;Uid=myUserName;Pwd=myPwd"Where MY_SYSTEM_NAME is the name given to the system connection in OperationsNavigatorODBCIBM 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"Check out this article at msdn >> and this one at Addison-Wesley >>Visual FoxProOLE DB, OleDbConnection (.NET)Database container (.DBC):"Provider=vfpoledb.1;DataSource=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""Read more (Microsoft msdn) >>ODBCDatabase container (.DBC):"Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=N O;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""Collate=Machine" is the default setting, for other settings check the list of supported collating sequences >>Microsoft Visual Foxpro site: /vfoxproPervasiveODBCStandard:"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"Pervasive ODBC info >>OLE DBStandard:"Provider=PervasiveOLEDB;Data Source=C:\path"Pervasive OLE DB info >>UDLUDLUDL:。