數(shù)據(jù)庫(kù)原理課程設(shè)計(jì)實(shí)驗(yàn)指導(dǎo)書-在線瀏覽
2024-09-14 00:21本頁(yè)面
【正文】 (4) 單擊下一步以后進(jìn)入用戶名稱信息的有關(guān)設(shè)置，如圖設(shè)置用戶名稱為“student”，密碼仍然和以前實(shí)驗(yàn)一樣，是空的。(6) 單擊下一步以后進(jìn)入語(yǔ)言等其他參數(shù)的設(shè)置界面，這里我們不需要進(jìn)行改動(dòng)(7)單擊完成以后可以結(jié)束ODBC數(shù)據(jù)源的設(shè)置。② ADO ADO（ActiveXDataObjects）是Microsoft提供和建議使用的新型的數(shù)據(jù)訪問(wèn)接口，具體實(shí)現(xiàn)為Automation。ADO被實(shí)現(xiàn)為OLEDB之上的一個(gè)薄層，這使得ADO可以有更快的訪問(wèn)速度，更易使用，同時(shí)更節(jié)省資源。這意味著程序員可以更為廣泛地使用ADO接口，甚至在所有的基于Windows平臺(tái)的數(shù)據(jù)訪問(wèn)中使用它?！∫弧?duì)ADO對(duì)象的主要操作 對(duì)ADO對(duì)象的主要操作，同DAO、RDO庫(kù)的實(shí)現(xiàn)基本相同。這是可選的、通常涉及ADO的Connection對(duì)象。通常涉及ADO的Command對(duì)象?！ 。热缫粋€(gè)SELECT腳本?！ 。蓪⒕彺嬷斜恍薷牡臄?shù)據(jù)更新到物理的存儲(chǔ)上。通常涉及ADO的Error對(duì)象。但使用ADO對(duì)象要比DAO和RDO簡(jiǎn)單得多。因此，ADO提供了一種更靈活的編程方式。使用Connection對(duì)象的成員，可以使用相應(yīng)的屬性打開(kāi)到數(shù)據(jù)源的連接，設(shè)置游標(biāo)的位置，設(shè)置默認(rèn)的當(dāng)前數(shù)據(jù)庫(kù)，設(shè)置將使用的OLEDBProvider，直接提交SQL腳本等。另外，對(duì)Connection對(duì)象的創(chuàng)建是同其他對(duì)象無(wú)關(guān)的。也可以進(jìn)行批操作和操縱數(shù)據(jù)庫(kù)的結(jié)構(gòu)，當(dāng)然，這需要使用的OLEDBProvider提供相應(yīng)的支持?！ ecordset對(duì)象，用來(lái)封裝查詢的結(jié)果，可稱為結(jié)果集。Error對(duì)象，用來(lái)檢測(cè)和判斷在數(shù)據(jù)庫(kù)操作中出現(xiàn)的錯(cuò)誤，比如連接失敗。添加s意味著是相應(yīng)對(duì)象的Collection（集合）對(duì)象，比如Errors是Error對(duì)象的Collection對(duì)象。所以，在看到一個(gè)對(duì)象名最后是s，通常表明這是一個(gè)Collection對(duì)象，比如Errors中的各元素是由Error對(duì)象的實(shí)例組成的。①.NET(1)SQL Server 1ODBC: Standard Security:Driver={SQL Server}。Database=pubs。Pwd=asdasd。Server=Aron1。Trusted_Connection=yes。Server=Aron1。2OLE DB, OleDbConnection (.NET) Standard Security:Provider=sqloledb。Initial Catalog=pubs。Password=asdasd。Data Source=Aron1。Integrated Security=SSPI。Initial Catalog=pubs。Data Source=,1433。Initial Catalog=pubs。Password=asdasd。Initial Catalog=pubs。Password=asdasd。Database=pubs。Password=asdasd。Initial Catalog=pubs。 or Server=Aron1。Trusted_Connection=True。Network Library=DBMSSOCN。User ID=sa。 (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 。=my connection string。 :Imports Dim oSQLConn As SqlConnection = New SqlConnection()=my connection string() Data Shape MS Data ShapeProvider=MSDataShape。Data Source=Aron1。User ID=sa。 (2) Access 1ODBC Standard Security:Driver={Microsoft Access Driver (*.mdb)}。Uid=Admin。 Workgroup:Driver={Microsoft Access Driver (*.mdb)}。SystemDB=C:\。Dbq=C:\。Uid=admin。Data Source=\somepath\。Password=。Data Source=\somepath\。Password=。Data Source=\somepath\。 With password:Provider=。Jet OLEDB:Database Password=MyDbPassword。Data Source=\somepath\。 With password:Provider=。Jet OLEDB:Database(3)Oracle1ODBC New version:Driver={Microsoft ODBC for Oracle}。Uid=Username。 Old version:Driver={Microsoft ODBC Driver for Oracle}。Uid=myUsername。 2 OLE DB, OleDbConnection (.NET) Standard security:Provider=msdaora。User Id=UserName。 This one39。Data Source=MyOracleDB。Password=asdasd。Data Source=MyOracleDB。 3 OracleConnection (.NET) Standard:Data Source=MyOracleDB。 This one works only with Oracle 8i release 3 or later Specifying username and password:Data Source=MyOracleDB。Password=passwd。 This one works only with Oracle 8i release 3 or later Declare the OracleConnection:C:using 。 = my connection string。 :Imports Dim oOracleConn As OracleConnection = New OracleConnection() = my connection string() Missing the namespace? Download .NET Managed Provider for Oracle Great article! Features of Oracle Data Provider for .NET by Rama Mohan G. at C Corner4 Core Labs OraDirect (.NET) Standard:User ID=scott。 Host=ora。 Min Pool Size=0。 Connection Lifetime=0 Read more at Core Lab and the product page. Data Shape MS Data Shape:Provider=。Data Provider=MSDAORA。user id=username。Server=localhost。Database=mydatabase。Server=。Option=131072。Database=mydatabase。Pwd=password。SERVER=localhost。USER=myUsername。OPTION=3。SERVER=。DATABASE=myDatabase。PASSWORD=myPassword。 2 OLE DB, OleDbConnection (.NET) Standard:Provider=MySQLProv。User Id=UserName。3 Connector/Net (.NET) Standard:Server=Server。Uid=UserName。 Download the driver at MySQL Developer Zone. Specifying port:Server=Server。Database=Test。Pwd=asdasd。MySqlConnection oMySqlConn = new MySqlConnection()。Database=Test。Pwd=asdasd。 :Imports Dim oMySqlConn As MySqlConnection = New MySqlConnection() = Server=Server。Uid=UserName。() 4MySqlConnection (.NET) :Data Source=server。User ID=username。Command Logging=false This one is used with eInfoDesigns dbProvider, an addon to .NET Declare the MySqlConnection:C:using 。 = my connection string。 :Imports Dim oMySqlConn As MySqlConnection = New MySqlConnection() = my connection string() 5 SevenObjects MySqlClient (.NET) Standard:Host=server。 Password=mypassword。 This is a freeware data provider from SevenObjects Core Labs MySQLDirect (.NET) Standard:User ID=root。 Host=localhost。 Database=test。 Protocol=TCP。 Pooling=true。Max Pool Size=100。Network Transport Library=TCPIP。Initial Catalog=MyCtlg。Default Schema=Schema。Password=MyPW APPC:Provider=DB2OLEDB。APPC Remote LU Alias=MyRemote。Package Collection=MyPkgCol。User ID=MyUser。s OLE DB Provider (shipped with IBM DB2 UDB v7 or above) TCP/IP:Provider=IBMDADB2。HOSTNAME=db2host。PORT=50000。pwd=myPwd。Database=myDbName。port=myPortNum。 uid=myUserName。Srvr=Aron1。Pwd=password Standard Sybase System 11:Driver={SYBASE SYSTEM 11}。Uid=username。Database=mydb For more information check out the Adaptive Server Enterprise Document Sets Intersolv :Driver={INTERSOLV 32BIT Sybase}。Uid=username。 Sybase SQL Anywhere (former Wat SQL ODBC driver):ODBC。 DefaultDir=c:\dbfolder\。Data source=myASA Read more in the ASA User Guide (part 1, chapter 2) Adaptive Server Enterprise (ASE) with Data Source .IDS file:Provider=Sybase ASE OLE DB Provider。Srvr=myASEserver,5000。User Id=username。Server Name=myASEserver,5000。User Id=username。myASEserver39。Database=39。UID=39。PWD=39。 Declare the AseConnection:C:using 。=my connection string。 :Imports Dim oCon As AseConnection = New AseConnection()=my connection string()(7)Visual Foxpro1OLE DB, OleDbConnection (.NET) Database container (.DBC):Provider=。Collating Sequence=machine Free table directory:
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號(hào)-1