转至繁体中文版　　　  | 网站首页 | 图文教程 | 资源下载 | 站长博客 | 图片素材 | 武汉seo | 武汉网站优化 | 
最新公告：     敏韬网|教学资源学习资料永久免费分享站！  [mintao  2008年9月2日]        
您现在的位置： 学习笔记 >> 图文教程 >> 站长学院 >> Web开发 >> 正文
ADO连接数据库字符串大全    热     ★★★★

ADO连接数据库字符串大全

作者：闵涛 文章来源：闵涛的学习笔记 点击数：4145 更新时间：2009/4/23 10:50:20
　　　　　　 "Password=myPassword;"

Note:
- xxx.xxx.xxx.xxx is an IP address
- "Network Library=DBMSSOCN" tells OLE DB to use TCP/IP rather than Named Pipes (Q238949)
- 1433 is the default port number for SQL Server
- You can also add "Encrypt=yes" for encryption

For more information, see: Microsoft OLE DB Provider for SQL Server




Remote Data Service (RDS) Connections
The following examples show how to connect to a remote database using the RDS Data Control.
When using the RDS DataControl''''s Server/SQL/Connect properties, the RDS DataControl uses the
RDS DataFactory on the remote server. If you use the RDS DataControl''''s URL property,
then the RDS DataFactory is not used at all.

WARNING: The RDS DataFactory can be a major security hole if not setup and configured correctly!
For more information, see RDS FAQ #24

RDS DataControl - Connect Property
　
With the RDS default handler disabled (not recommend due to security risks):

With oRdc
　 .Server = "http://carl2"
　 .Sql = "Select * From Authors Where State = ''''CA''''"
　 .Connect = "Provider=sqloledb;" & _
　　　　　　　　　　 "Data Source=(local);" & _
　　　　　　　　　　 "Initial Catalog=pubs;" & _
　　　　　　　　　　 "User Id=sa;" & _
　　　　　　　　　　 "Password=;"
　 .Refresh
End With

With the RDS default handler enabled (recommend):

With oRdc
　 .Server = "http://carl2"
　 .Handler = "MSDFMAP.Handler"
　 .Connect = "Data Source=MyConnectTag;"
　 .Sql = "MySQLTag(""CA"")"
　 .Refresh
End With

The corresponding CONNECT and SQL sections in the default handler \WINNT\MSDFMAP.INI file would be:

[connect MyConnectTag]
Access = ReadWrite
Connect = "Provider=sqloledb;Data Source=(local);Initial Catalog=pubs;User Id=sa;Password=;"

[sql MySQLTag]
Sql = "Select * From Authors Where State = ''''?''''"

For more information about the RDS Default Handler, see:
Q243245, Q230680, and RDS Customization Handler Microsoft articles


RDS DataControl - URL Property
　
To get records from a remote database:

With oRdc
　 .URL = "http://carlp0/Authors_GetByState.asp?state=CA"
　 .Refresh
End With

To save, set the URL property to an ASP web page:

With oRdc
　 .URL = "http://carlp0/rdsdatacontrol/Authors_Save.asp"
　 .SubmitChanges
End With

For more information, see: RDS URL Property




ADO URL Connections
ADO 2.5+ allows you to open up a Recordset based on XML returned from an ASP file over HTTP.　
This feature doesn''''t use RDS at all.

ADO Recordset
　
To get records from a remote database:

oRs.Open "http://carlp0/Authors_GetByState.asp?state=CA", , _
　　　　　　　　　　　　　　　　　　　　　 adOpenStatic, adLockBatchOptimistic

To save changes, you must use the MSXML''''s XMLHTTP object to POST back the updated XML.　
The Recordset''''s Update and UpdateBatch methods will not work in this case.

'''' Save Recordset into Stream
Set oStm = New ADODB.Stream
oRs.Save oStm, adPersistXML

'''' Use MSXML''''s XMLHTTP object to open ASP and post a XML stream
Set oXMLHTTP = New MSXML2.XMLHTTP30
oXMLHTTP.Open "POST", "http://carlp0/Authors_Save.asp", False
oXMLHTTP.Send oStm.ReadText

'''' If an error occurred
If oXMLHTTP.Status = 500 Then
　 Debug.Print oXMLHTTP.statusText
End If

For more information, see: ADO Recordset''''s Open Method




MS Remote Provider Connections
The following connections strings use Microsoft''''s remote provider (MS Remote). The MS Remote
provider tells ADO to communicate with the remote server (via the RDS DataFactory) and to use
the remote provider that is installed on the remote server.

WARNING: The RDS DataFactory can be a major security hole if not setup and configured correctly!　
For more information, see RDS FAQ #24
　　

MS Remote - Access (Jet)
　
If you want to use an ODBC DSN on the remote machine:

oConn.Open "Provider=MS Remote;" & _
　　　　　　　　　 "Remote Server=http://myServerName;" & _
　　　　　　　　　 "Remote Provider=MSDASQL;" & _
　　　　　　　　　 "DSN=AdvWorks;" & _
　　　　　　　　　 "Uid=myUsername;" & _
　　　　　　　　　 "Pwd=myPassword;"

If you want to use an OLE DB Provider on the remote machine:

oConn.Open "Provider=MS Remote;" & _
　　　　　　　　　 "Remote Server=http://myServerName;" & _
　　　　　　　　　 "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
　　　　　　　　　 "Data Source=c:\somepath\mydb.mdb;", _
　　　　　　　　　 "admin", ""

If you want to use an OLE DB Provider on the remote machine (via RDS DataFactory Default Handler):

oConn.Open "Provider=MS Remote;" & _
　　　　　　　　　 "Remote Server=http://myServerName;" & _
　　　　　　　　　 "Handler=MSDFMAP.Handler;" & _
　　　　　　　　　 "Data Source=MyAdvworksConn;"

The corresponding entry in the \winnt\Msdfmap.ini file would be:

[connect MyAdvworksConn]
Access = ReadWrite
Connect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
　　　　　　　 "Data Source=mydb.mdb;" & _
　　　　　　　 "User Id=admin;" & _
　　　　　　　 "Password=;"
　

MS Remote - SQL Server
　
If you want to use an ODBC DSN on the remote machine:

oConn.Open "Provider=MS Remote;" & _
　　　　　　　　　 "Remote Server=http://myServerName;" & _
　　　　　　　　　 "Remote Provider=MSDASQL;" & _
　　　　　　　　　 "DSN=myDatabaseName;" & _
　　　　　　　　　 "Uid=myUsername;" & _
　　　　　　　　　 "Pwd=myPassword;"

If you want to use an OLE DB Provider on the remote machine:

oConn.Open "Remote Provider=MS Remote;" & _
　　　　　　　　　 "Remote Server=http://myServerName;" & _
　　　　　　　　　 "Provider=SQLOLEDB;" & _
　　　　　　　　 "Data Source=myServerName;" & _
　　　　　　　　 "Initial Catalog=myDatabaseName;" & _
　　　　　　　　 "User ID=myUsername;" & _
　　　　　　　　　 "Password=myPassword;"

If you want to use an OLE DB Provider on the remote machine (via RDS DataFactory Default Handler):

oConn.Open "Provider=MS Remote;" & _
　　　　　　　　 　"Remote Server=http://myServerName;" & _
　　　　　　　　 　"Handler=MSDFMAP.Handler;" & _
　　　　　　　　 　"Data Source=MyPubsConn;"

The corresponding entry in the \winnt\Msdfmap.ini file would be:

[connect MyPubsConn]
Access = ReadWrite
Connect = "Provider=SQLOLEDB;" & _
　　　　　　　 "Data Source=myServerName;" & _
　　　　　　　 "Initial Catalog=myDatabaseName;" & _
　　　　　　　 "User ID=myUsername;" & _
　　　　　　　 "Password=myPassword;"

For more information, see: Microsoft OLE DB Remoting Provider　 and Q240838




Data Shape Provider Connections
MS DataShape - SQL Server
　
oConn.Open "Provider=MSDataShape;" & _
　　　　　　　　　 "Data Provider=SQLOLEDB;" & _
　　　　　　　　　 "Data Source=mySQLServerName;" & _
　　　　　　　　　 "Initial Catalog=myDatabase;" & _
　　　　　　　　　 "User ID=myUsername;" & _
　　　　　　　　　 "Password=myPassword;"

Then use a Shape command with SQL strings:
sSQL = "SHAPE {select * from authors} " & _
　　　　　 "APPEND ({select * from titleauthor} AS chapter " & _
　　　　　 "RELATE au_id TO au_id)"

Or use a Shape command that calls Stored Procedures:
sSQL = "SHAPE {exec spAuthors_LoadAll} " & _
　　　　　 "APPEND ({exec spTitleAuthor_LoadAll} AS chapter " & _
　　　　　 "RELATE au_id TO au_id)"

For more information, see: Microsoft Data Shaping Service for OLE DB and Q288409




.NET Managed Provider Connections
SQL Client .NET Managed Provider (System.Data.SqlClient)
　
The SQL Client .NET Managed Provide allows you to connect to a Microsoft SQL Server 7.0
or 2000 database. For Microsoft SQL Server 6.0 or earlier, use the OLE DB .NET Data Provider
with the "SQL Server OLE DB Provider" (SQLOLEDB).

Dim oSQLConnection As SqlClient.SqlConnection
Dim sConnString As String

sConnString = "Data Source=(local);" & _
　　　　　　　　　　 "Initial Catalog=NorthWind;" & _
　　　　　　　　　　 "Integrated Security=SSPI;" & _
　　　　　　　　　　 "Pooling=True;" & _
　　　　　　　　　　 "Min Pool Size=10;" & _
　　　　　　　　　　 "Max Pool Size=50;" & _
　　　　　　　　　　 "Connection Lifetime=30;" & _
　　　　　　　　　　 "Connection Reset=True;" & _
　　　　　　　　　　 "Enlist=True;"
oSQLConnection = New SqlClient.SqlConnection(sConnString)
oSQLConnection.Open()

For more information, see: System.Data.SQL Namespace and .NET Data Providers
Note: ''''SQL'''' namespace got renamed to ''''SQLClient''''


OLE DB .NET Managed Provider (System.Data.OleDb)
　
The OLE DB .NET Data Provider uses native OLE DB through COM interop to enable data access.　
To use the OLE DB .NET Data Provider, you must also use an OLE DB provider (e.g. SQLOLEDB,
MSDAORA, or Microsoft.JET.OLEDB.4.0).

For SQL Server OLE DB Provider (for SQL Server 6.0 or earlier)

Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String

sConnString = "Provider=sqloledb;" & _
　　　　　　　　　　 "Data Source=myServerName;" & _
　　　　　　　　 　 "Initial Catalog=myDatabaseName;" & _
　　　　　　　　 　 "User Id=myUsername;" & _
　　　　　　　　　 "Password=myPassword;"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

For JET OLE DB Provider:

Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String

sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
　　　　　　　　　　 "Data Source=C:\Work\nwind.mdb;" & _
　　　　　　　　　　 "User ID=Admin;" & _
　　　　　　　　　　 "Password="";"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOl

上一页  [1] [2] [3] [4]  下一页


没有相关教程
教程录入：mintao    责任编辑：mintao 
  • 上一篇教程：

  • 下一篇教程：
    • 【字体：小 大】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口】
    　 注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网]
    　　网友评论：（只显示最新10条。评论内容只代表网友观点，与本站立场无关！）
    同类栏目
    · Web开发  · 网页制作
    · 平面设计  · 网站运营
    · 网站推广  · 搜索优化
    · 建站心得  · 站长故事
    · 互联动态
    更多内容
    热门推荐 更多内容
  • 没有教程
    		•
    赞助链接
    更多内容
    闵涛博文 更多关于武汉SEO的内容
    500 - 内部服务器错误。

    500 - 内部服务器错误。

    您查找的资源存在问题，因而无法显示。
    | 设为首页 |加入收藏 | 联系站长 | 友情链接 | 版权申明 | 广告服务
    MinTao学以致用网

    Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
    闵涛 投放广告、内容合作请Q我! E_mail:admin@mintao.net(欢迎提供学习资源)

    站长：MinTao ICP备案号：鄂ICP备11006601号-18

    闵涛站盟:医药大全-武穴网。A打造B、C、D……
    		咸宁网络警察报警平台