📄 ado连接数据库字符串大全（vp,excel,文本,sybase,.net等).htm
字号:
Catalog=myDatabase;" & _<BR> "User ID=myUsername;"
& _<BR> "Password=myPassword;"</P>
<P>Then use a Shape command with SQL strings:<BR>sSQL = "SHAPE
{select * from authors} " & _<BR> "APPEND ({select * from
titleauthor} AS chapter " & _<BR> "RELATE au_id TO
au_id)"</P>
<P>Or use a Shape command that calls Stored Procedures:<BR>sSQL =
"SHAPE {exec spAuthors_LoadAll} " & _<BR> "APPEND ({exec
spTitleAuthor_LoadAll} AS chapter " & _<BR> "RELATE au_id
TO au_id)"</P>
<P>For more information, see: Microsoft Data Shaping Service for
OLE DB and Q288409 </P>
<P><BR></P>
<P>.NET Managed Provider Connections<BR>SQL Client .NET Managed
Provider (System.Data.SqlClient) <BR> <BR>The SQL Client .NET
Managed Provide allows you to connect to a Microsoft SQL Server
7.0 <BR>or 2000 database. For Microsoft SQL Server 6.0 or earlier,
use the OLE DB .NET Data Provider <BR>with the "SQL Server OLE DB
Provider" (SQLOLEDB).</P>
<P>Dim oSQLConnection As SqlClient.SqlConnection<BR>Dim
sConnString As String</P>
<P>sConnString = "Data Source=(local);" & _<BR>
"Initial Catalog=NorthWind;" & _<BR> "Integrated
Security=SSPI;" & _<BR> "Pooling=True;" &
_<BR> "Min Pool Size=10;" & _<BR> "Max
Pool Size=50;" & _<BR> "Connection Lifetime=30;"
& _<BR> "Connection Reset=True;" &
_<BR> "Enlist=True;"<BR>oSQLConnection = New
SqlClient.SqlConnection(sConnString)<BR>oSQLConnection.Open()</P>
<P>For more information, see: System.Data.SQL Namespace and .NET
Data Providers<BR>Note: 'SQL' namespace got renamed to
'SQLClient'</P>
<P></P>
<P>OLE DB .NET Managed Provider (System.Data.OleDb) <BR> <BR>The
OLE DB .NET Data Provider uses native OLE DB through COM interop
to enable data access. <BR>To use the OLE DB .NET Data Provider,
you must also use an OLE DB provider (e.g. SQLOLEDB,<BR>MSDAORA,
or Microsoft.JET.OLEDB.4.0).</P>
<P>For SQL Server OLE DB Provider (for SQL Server 6.0 or
earlier)</P>
<P>Dim oOleDbConnection As OleDb.OleDbConnection<BR>Dim
sConnString As String</P>
<P>sConnString = "Provider=sqloledb;" & _ <BR> "Data
Source=myServerName;" & _<BR> "Initial
Catalog=myDatabaseName;" & _<BR> "User
Id=myUsername;" & _<BR> "Password=myPassword;"
<BR>oOleDbConnection = New
OleDb.OleDbConnection(sConnString)<BR>oOleDbConnection.Open()</P>
<P>For JET OLE DB Provider:</P>
<P>Dim oOleDbConnection As OleDb.OleDbConnection<BR>Dim
sConnString As String</P>
<P>sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" &
_<BR> "Data Source=C:\Work\nwind.mdb;" &
_<BR> "User ID=Admin;" & _<BR>
"Password="";" <BR>oOleDbConnection = New
OleDb.OleDbConnection(sConnString)<BR>oOleDbConnection.Open()</P>
<P>For more information, see: System.Data.OleDb Namespace and .NET
Data Providers<BR>Note: 'ADO' namespace got renamed to 'OleDb'</P>
<P></P>
<P>ODBC .NET Managed Provider (System.Data.ODBC) <BR> <BR>The
ODBC .NET Data Provider is an add-on component to the .NET
Framework SDK Beta 2. <BR>It provides access to native ODBC
drivers the same way the OLE DB .NET Data Provider <BR>provides
access to native OLE DB providers.</P>
<P>For SQL Server ODBC Driver:</P>
<P>Dim oODBCConnection As Odbc.OdbcConnection<BR>Dim sConnString
As String<BR><BR>' Create and open a new ODBC
Connection<BR>sConnString = "Driver={SQL Server};" &
_<BR> "Server=MySQLServerName;" & _<BR>
"Database=MyDatabaseName;" & _<BR> "Uid=MyUsername;"
& _<BR> "Pwd=MyPassword;"</P>
<P>oODBCConnection = New
Odbc.OdbcConnection(sConnString)<BR>oODBCConnection.Open()</P>
<P>For Oracle ODBC Driver:</P>
<P>Dim oODBCConnection As Odbc.OdbcConnection<BR>Dim sConnString
As String<BR><BR>' Create and open a new ODBC
Connection<BR>sConnString = "Driver={Microsoft ODBC for Oracle};"
& _<BR> "Server=OracleServer.world;" &
_<BR> "Uid=myUsername;" & _<BR>
"Pwd=myPassword;"</P>
<P>oODBCConnection = New
Odbc.OdbcConnection(sConnString)<BR>oODBCConnection.Open()</P>
<P>For Access (JET) ODBC Driver:</P>
<P>Dim oODBCConnection As Odbc.OdbcConnection<BR>Dim sConnString
As String<BR><BR>' Create and open a new ODBC
Connection<BR>sConnString = "Driver={Microsoft Access Driver
(*.mdb)};" & _ <BR> "Dbq=c:\somepath\mydb.mdb;" &
_<BR> "Uid=Admin;" & _<BR> "Pwd=;"</P>
<P>oODBCConnection = New
Odbc.OdbcConnection(sConnString)<BR>oODBCConnection.Open()</P>
<P>For all other ODBC Drivers:</P>
<P>Dim oODBCConnection As Odbc.OdbcConnection<BR>Dim sConnString
As String<BR><BR>' Create and open a new ODBC
Connection<BR>sConnString = "Dsn=myDsn;" & _<BR>
"Uid=myUsername;" & _<BR> "Pwd=myPassword;"</P>
<P>oODBCConnection = New
Odbc.OdbcConnection(sConnString)<BR>oODBCConnection.Open()</P>
<P>For more information, see: Download
Center<BR><BR><BR></P></BLOCKQUOTE></TD></TR>
<TR>
<TD class=p4 vAlign=top width="50%">
<BLOCKQUOTE>原作者：Download<BR>来 源：Download<BR>共有9881位读者阅读过此文<BR>【<A
href="http://bbs.aspsky.net/list.asp?boardid=1">发表评论</A>】
</BLOCKQUOTE></TD>
<TD class=p4 vAlign=top width="50%">
<P>
<LI><FONT color=#0772b1>上篇文章</FONT>：<A
href="http://www.aspsky.net/article/list.asp?id=2489">不用询问关闭一个独立的窗口代码</A>
<BR>
<LI><FONT color=#0772b1>下篇文章</FONT>：已经没有了 </LI></TD></TR>
<TR>
<TD bgColor=#297dff class=p4 height=20 width="50%"><FONT
color=#ceffff> → 本周热门</FONT></TD>
<TD bgColor=#297dff class=p4 width="50%"><FONT color=#ceffff> →
相关文章</FONT></TD></TR>
<TR>
<TD bgColor=#586011 colSpan=2 height=1><SPACER type="block"
width="1"></TD></TR>
<TR>
<TD colSpan=2 height=7></TD></TR>
<TR>
<TD class=p4 vAlign=top width="50%">
<LI><A href="http://www.aspsky.net/article/list.asp?id=1510"
target=_top title="SQL Server 7.0 入门（一）">SQL Server 7.0
入门（...</A>[<FONT color=red>7239</FONT>]<BR>
<LI><A href="http://www.aspsky.net/article/list.asp?id=1540"
target=_top title=PHP4实际应用经验篇(1)>PHP4实际应用经验篇(1)</A>[<FONT
color=red>7135</FONT>]<BR>
<LI><A href="http://www.aspsky.net/article/list.asp?id=1536"
target=_top
title=无组件文件上传代码实例（支持多文件上传及文件和input域混合上传）>无组件文件上传代码实例（支持多文件上...</A>[<FONT
color=red>6029</FONT>]<BR>
<LI><A href="http://www.aspsky.net/article/list.asp?id=2557"
target=_top title=树型结构在ASP中的简单解决>树型结构在ASP中的简单解决</A>[<FONT
color=red>5757</FONT>]<BR>
<LI><A href="http://www.aspsky.net/article/list.asp?id=1545"
target=_top title=PHP4实际应用经验篇(6)>PHP4实际应用经验篇(6)</A>[<FONT
color=red>5599</FONT>]<BR>
<LI><A href="http://www.aspsky.net/article/list.asp?id=2563"
target=_top title=一个老个写的无组件上传>一个老个写的无组件上传</A>[<FONT
color=red>5013</FONT>]<BR>
<LI><A href="http://www.aspsky.net/article/list.asp?id=1542"
target=_top title=PHP4实际应用经验篇(3)>PHP4实际应用经验篇(3)</A>[<FONT
color=red>4731</FONT>]<BR></LI></TD>
<TD class=p4 vAlign=top width="50%">
<LI><A
href="http://www.aspsky.net/article/list.asp?id=2733">一个测试数据库连接的函数</A><BR>
<LI><A
href="http://www.aspsky.net/article/list.asp?id=2490">ADO连接数据库字符串大全（VP,Excel,文本,Sybase,.NET等)</A><BR>
<LI><A
href="http://www.aspsky.net/article/list.asp?id=1945">在config.web中保存数据库连接串</A><BR>
<LI><A
href="http://www.aspsky.net/article/list.asp?id=1470">asp+中是如何连接数据库ado+的</A><BR>
<LI><A
href="http://www.aspsky.net/article/list.asp?id=848">PHP4连接Oracle
8i的方法（转译）</A><BR></LI></TD></TR>
<TR>
<TD colSpan=2 height=7></TD></TR></TBODY></TABLE>
<TD bgColor=#297dff width=1> </TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=755>
<TBODY>
<TR>
<TD bgColor=#297dff height=1><SPACER type="block"
width="1"></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=755>
<TBODY>
<TR>
<TD align=middle height=30></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=755>
<TBODY>
<TR>
<TD align=middle class=p2 width="100%">
<TABLE border=0 cellPadding=0 cellSpacing=0 width=755>
<TBODY>
<TR>
<TD align=middle class=p2 width="100%">
<P align=center><A
href="http://www.aspsky.net/produce/index.asp">客户服务</A> -- <A
href="http://www.aspsky.net/aspads.asp">广告合作</A> -- <A
href="http://www.aspsky.net/about.asp">关于本站</A> -- <A
href="http://www.aspsky.net/tell.asp">联系方法</A><BR><BR>动网先锋版权所有 <FONT
face=Verdana, size=1 Arial, Helvetica, sans-serif>Copyright ©
2000-2001 <B>AspSky<FONT color=#cc0000>.Net</FONT></B>, All Rights
Reserved .</FONT>
</P></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></CENTER></CENTER></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -