![](../../com.ibm.help.doc/images/IC-im-sm.gif)
驗證 IBM Data Server Driver Package (Windows) 安裝
您可以驗證最常用介面(例如 CLI/ODBC、ADO.NET 及 Visual Studio)的 IBM® Data Server Driver Package 安裝。
您可以使用下列鏈結來下載 IBM Data Server Driver Package:https://www-304.ibm.com/support/docview.wss?rs=4020&uid=swg27016878。
安裝 IBM Data Server Driver Package 之後,您可以使用 db2cli validate 指令來驗證 CLI/ODBC 的安裝。
- 在 db2dsdriver.cfg 檔案中建立別名。然後,您可以將 DSN 別名、資料庫名稱、主機名稱及用來與之建立連線的埠移入配置檔。您可以執行 db2cli validate 指令以顯示 db2dsdriver.cfg 檔案位置,來取得 IBM Data Server Driver Package 產品在 Windows 上的 db2dsdriver.cfg 路徑。
- 向 db2cli 應用程式驗證 DSN 別名。
- 建立別名的 ODBC DSN。
- 使用 MS Excel 來測試 ODBC DSN。
範例 db2dsdriver.cfg
下列範例 db2dsdriver.cfg 檔案已使用 DSN 別名 sampledsn、資料庫名稱 sample、主機名稱 samplehost.domain.com 及埠 19766 進行配置。
<configuration>
<dsncollection>
<dsn alias="sampledsn" name="sample" host="samplehost.domain.com" port="19766"/>
</dsncollection>
<databases>
<database name="sample" host="samplehost.domain.com" port="19766">
</database>
</databases>
</configuration>
已安裝的用戶端套件清單
對於 IBM Data Server Client(IBM Data Server Client 或 IBM Data Server Runtime Client),您可以使用 db2cli validate 指令來列出 Windows 作業系統上已安裝的用戶端套件。 從 IBM Data Server Client 發出 db2cli validate 指令時,此清單會限制為 Windows 作業系統上已安裝的 IBM Data Server Client。 若要列出 Windows 作業系統上已安裝的 IBM Data Server Driver for ODBC and CLI 套件及 IBM Data Server Client 套件,您必須從 IBM Data Server Driver for ODBC and CLI 安裝中發出 db2cli validate 指令。 此清單將現行副本名稱指出為 [C],而將預設副本名稱指出為 [D]。
C:\CLIDRIVER\bin>db2cli validate
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------
[ CLI Driver Version : 10.0X.0000 ]
[ Informational Tokens : "DB2 v10.X.XXX.XXX","nXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Driver for ODBC and CLI ]
IBM Data Server client packages on the current workstation:
Copyname Version Installed Location
---------------------------------------------------------------------
C_CLIDRIVER[C] 09.07.0600 C:\CLIDRIVER
DB2COPY1[D] 09.07.0500 E:\SQLLIB
DB2COPY2 09.01.0700 C:\Program Files\IBM\SQLLIB_01\
DB2COPY3 09.07.0301 C:\Program Files\IBM\SQLLIB\
DSCOPY 09.07.0500 C:\IBM\IBM DATA SERVER DRIVER\
---------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Success: The schema validation operation completed successfully.
The configuration file C:\Documents and Settings\All Users\Application Data\IBM\
DB2\C_CLIDRIVER\cfg\db2dsdriver.cfg is valid
The validation completed.
在 64 位元 Windows 系統中,db2cli32.exe 及 db2cli.exe 的輸出會相同。db2dsdriver.cfg 檔案的位置
IBM Data Server Client 與 IBM Data Server Driver 之間的 db2dsdriver.cfg 檔案位置不同。
- 在 IBM Data Server Client 中:%instance_path%/cfg
- 在資料庫伺服器中:%installation_path%/cfg
您可以搭配使用 db2cli 指令與 validate 參數,來尋找 db2dsdriver.cfg 檔案的位置。
db2cli.exe validate -dsn dummy
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------------
[ CLI Driver Version : 10.XX.0000 ]
[ Informational Tokens : "DB2 v10.X.X.X","sXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Driver For ODBC and CLI ]
---------------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Success: The schema validation operation completed successfully.
The configuration file ../cfg/db2dsdriver.cfg is valid
Note: The validation operation utility could not find the
configuration file named db2cli.ini.
The file is searched at ../cfg/db2cli.ini
db2dsdriver.cfg Validation :
---------------------------------------------------------------------------
[ DB2DSDRIVER_CFG_PATH env var : unset ]
[ db2dsdriver.cfg Path : ../cfg/db2dsdriver.cfg ]
---------------------------------------------------------------------------
[ Valid keywords used for DSN : alias1 ]
Keyword Value
--------------------------------------------------
DATABASE name1
HOSTNAME server1.net1.com
PORT 50001
CURRENTSCHEMA OWNER1
[ Parameters used for WLB ]
Parameter Value
--------------------------------------------------
enableWLB true
maxTransports 50
[ Parameters used for ACR ]
Parameter Value
--------------------------------------------------
enableACR true
[ Keywords UNKNOWN for DSN : alias1 ]
Keyword Value
--------------------------------------------------
GlobalParam Value
---------------------------------------------------------------------------
The validation completed.
驗證 DSN 別名
您可以發出 db2cli validate -dsn sampledsn 指令,以發出 db2dsdriver.cfg 檔案中配置的 DSN 別名 sampledsn。所有有效項目列在指令輸出中。
db2cli validate -dsn alias1
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------------
[ CLI Driver Version : 10.0X.0000 ]
[ Informational Tokens : "DB2 v10.X.XXX.XXX","nXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Client ]
[ db2diag.log Path : C:\Documents and Settings\All Users\Application Data\IBM\DB2\db2build\DB5\db2diag.log ]
---------------------------------------------------------------------------
IBM Data Server Client packages on the current workstation :
Copyname Version Installed Location
---------------------------------------------------------------------------
db2build[C] 10.XX.XXXX E:\sqllib
IBMDBCL1[D] 10.XX.XXXX C:\Program Files\IBM\IBM DATA SERVER DRIVER
---------------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Success: The schema validation operation completed successfully.
The configuration file C:\Documents and Settings\All Users\Application Data\IBM\DB2\db2build\cfg\db2dsdriver.cfg is valid
Note: The validation operation utility could not find the configuration file named db2cli.ini.
The file is searched at C:\Documents and Settings\All Users\Application Data\IBM\DB2\db2build\cfg\db2cli.ini
db2dsdriver.cfg Validation :
---------------------------------------------------------------------------
[ DB2DSDRIVER_CFG_PATH env var : unset ]
[ db2dsdriver.cfg Path : C:\Documents and Settings\All Users\Application Data\IBM\DB2\db2build\cfg\db2dsdriver.cfg ]
---------------------------------------------------------------------------
[ List of Keywords used for DSN : alias1 ]
Keywords Valid For Value
----------------------------------------------------------
DATABASE CLI,.NET,ESQL STLEC1
HOSTNAME CLI,.NET,ESQL INEC002.svldev.svl.ibm.com
PORT CLI,.NET,ESQL 446
CURRENTSCHEMA CLI,.NET **DUPLICATE**
DISABLEAUTOCOMMIT CLI FALSE
COMMPROTOCOL CLI TCPIP
COMMITONEOF CLI,.NET TRUE
COLUMNWISEMRI CLI TRUE
DISABLEPOOLING .NET TRUE
csmbuffersize **UNKNOWN**
XMLDeclaration **UNKNOWN**
[ Parameters used for WLB ]
Parameter Value
----------------------------------------------------------
enableWLB true
maxTransports 50
[ Parameters used for ACR ]
Parameter Value
----------------------------------------------------------
enableACR true
enableSeamlessACR true
Alternate Server List :
Name - S1 Hostname - jcc.svl.ibm.com Port - 446
Name - S2 Hostname - host1_placeholder Port - 446
Name - S3 Hostname - host2_placeholder Port - 446
Affinity List :
Name - list1 Serverorder - S1,S2,S3
Name - list2 Serverorder - S2,S1,S3
---------------------------------------------------------------------------
The validation completed.
db2cli validate -dsn sampledsn
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------------
[ CLI Driver Version : 10.XX.XXXX ]
[ Informational Tokens : "DB2 v10.X.XXX.XXX","sXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Driver Package ]
[ CLI Copy Name : IBMDBCL1 ]
---------------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Warning: The schema validation operation completed successfully.
The following data source name was not found in the db2cli.ini file: "sampledsn".
The file is at C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2cli.ini
db2dsdriver.cfg Validation :
-----------------------------------------------------------------------------------
[ DB2DSDRIVER_CFG_PATH env var : unset ]
[ db2dsdriver.cfg Path : C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg ]
-----------------------------------------------------------------------------------
[ Keywords used by CLI for DSN : sampledsn ]
Keyword Value
------------------------------------------
DATABASE sample
HOSTNAME samplehost.domain.com
PORT 19766
------------------------------------------
The validation completed.
db2cli validate -all
===============================================================================
Client information for the current copy (copy name: IBMDBCL1):
===============================================================================
Client Package Type : IBM Data Server Driver Package
Client Version (level/bit): DB2 v10.XX.XXX.XXX (nXXXXXX/XX-bit)
Client Platform : NT
Install/Instance Path : C:\SQLLIB\clidriver
Common App Data Path : C:\Documents and Settings\All Users\Application Data
\IBM\DB2\db2build
DB2DSDRIVER_CFG_PATH value: <not-set>
db2dsdriver.cfg Path : <Common App Data Path>\cfg\db2dsdriver.cfg
DB2CLIINIPATH value : <not-set>
db2cli.ini Path : <Common App Data Path>\cfg\db2cli.ini
db2diag.log Path : <Common App Data Path>\db2diag.log
===============================================================================
List of all IBM Data Server client packages on the current workstation:
===============================================================================
Copy name Version Package Language Installed Location
--------------------------------------------------------------------------------
DB2COPY1 10.X.XX ESE EN C:\Program Files\IBM\SQLLIB
IBMDBCL1[C,D] 10.X.XX DSD ALL_LANG C:\Program Files\IBM\IBM DATA SERVER DRIVER
--------------------------------------------------------------------------------
ESE : IBM DB2 Enterprise Server Edition
DSD : IBM Data Server Driver Package
--------------------------------------------------------------------------------
===============================================================================
db2dsdriver.cfg schema validation for the entire file:
===============================================================================
Success: The schema validation completed successfully without any errors.
===============================================================================
db2cli.ini validation for data source name "dsnName":
===============================================================================
Note: The validation utility could not find the configuration file db2cli.ini.
The file is searched at "C:\Documents and Settings\All Users\Application
Data\IBM\DB2\db2build\cfg\db2cli.ini".
===============================================================================
db2dsdriver.cfg validation for data source name "dsnName":
===============================================================================
[ Parameters used for the connection ]
Keywords Valid For Value
---------------------------------------------------------------------------
DATABASE CLI,.NET,ESQL sample
HOSTNAME CLI,.NET,ESQL localhost
PORT CLI,.NET,ESQL 50000
COMMITONEOF CLI,.NET 1
ISOLATIONLEVEL CLI,.NET readcommitted
CURRENTSCHEMA CLI,.NET test1
COMMPROTOCOL CLI tcpip
AUTHENTICATION CLI,.NET server_encrypt
ClientAplicationName **UNKNOWN**
isolatonlevel **UNKNOWN**
isolationlevl **UNKNOWN**
[ Parameters used for WLB ]
Parameter Value
---------------------------------------------------------------------------
enablewlb true
maxtransports 25
enableSeamlessAcr **UNKNOWN**
[ Parameters used for ACR ]
Parameter Value
---------------------------------------------------------------------------
enableacr true
maxacrretries 3
acrRetryIntrval **UNKNOWN**
Connecting to: sample:localhost:50000 [SUCCESS]
===============================================================================
db2cli.ini validation for database "prod:localhost:50000":
===============================================================================
Note: The validation utility could not find the configuration file db2cli.ini.
The file is searched at "C:\Documents and Settings\All Users\Application
Data\IBM\DB2\db2build\cfg\db2cli.ini".
===============================================================================
db2dsdriver.cfg validation for database "prod:localhost:50000":
===============================================================================
[ Parameters used for the connection ]
Keywords Valid For Value
---------------------------------------------------------------------------
CURRENTSCHEMA CLI,.NET test2
COMMPROTOCOL CLI tcpip
AUTHENTICATION CLI,.NET server_encrypt
isolationlevl **UNKNOWN**
[ Parameters used for WLB ]
Parameter Value
---------------------------------------------------------------------------
enablewlb true
maxtransports 15
[ Parameters used for ACR ]
Parameter Value
---------------------------------------------------------------------------
enableacr true
Connecting to: prod:localhost:50000 [FAILED]
[IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USE
RNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
===============================================================================
db2cli.ini validation for database "sample:localhost:50000":
===============================================================================
Note: The validation utility could not find the configuration file db2cli.ini.
The file is searched at "C:\Documents and Settings\All Users\Application
Data\IBM\DB2\db2build\cfg\db2cli.ini".
===============================================================================
db2dsdriver.cfg validation for database "sample:localhost:50000":
===============================================================================
[ Parameters used for the connection ]
Keywords Valid For Value
---------------------------------------------------------------------------
CURRENTSCHEMA CLI,.NET test1
COMMPROTOCOL CLI tcpip
AUTHENTICATION CLI,.NET server_encrypt
isolatonlevel **UNKNOWN**
isolationlevl **UNKNOWN**
[ Parameters used for WLB ]
Parameter Value
---------------------------------------------------------------------------
enablewlb true
maxtransports 25
enableSeamlessAcr **UNKNOWN**
[ Parameters used for ACR ]
Parameter Value
---------------------------------------------------------------------------
enableacr true
maxacrretries 3
acrRetryIntrval **UNKNOWN**
Connecting to: sample:localhost:50000 [SUCCESS]
===============================================================================
The validation is completed.
===============================================================================
[IBM][CLI 驅動程式] SQL1598N 因為發生授權問題,所以嘗試連接至資料庫伺服器失敗。SQLSTATE=42968
如果您是使用 DB2 Connect Unlimited Edition for z/OS®,則可以使用伺服器型授權碼。如果執行此一步驟,則不需要用戶端型授權碼。如需詳細資料,請參閱與啟動 DB2 Connect Unlimited Edition for System z® 的授權碼有關的主題。
如果您無法使用伺服器型授權碼,請從所購買的 DB2 Connect Edition 中取得 DB2 Connect 授權碼(例如:db2conpe.lic),並將它鍵入至 C:\Program Files\IBM\IBM DATA SERVER DRIVER\license 授權目錄(位於 IBM Data Server Driver 套件的安裝位置底下)。
db2cli bind "@<ds driver install path> \bnd\db2cli.lst" -dsn sampledsn -user <userid> -passwd <password> -options "grant public collection nullid"
將正確的資料庫連線資訊移入 db2dsdriver.cfg 檔案之後,請使用 ODBC 驅動程式管理程式將 DSN 別名登錄為資料來源。您可以讓資料來源可供系統的所有使用者(系統資料來源)或只限現行使用者(使用者資料來源)使用。
測試 CLI 驅動程式的連線功能
若要測試使用 db2dsdriver.cfg 檔案中 DSN 及資料庫區段項目的 CLI 連線,請發出 db2cli validate -dsn dsnName -connect -user userID -passwd password,如下列範例所示:
db2cli validate -dsn sample -connect -user userID -passwd password
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------------
[ CLI Driver Version : 10.0X.XXXX ]
[ Informational Tokens : "DB2 v10.X.XXX.XXX","sXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Driver Package ]
[ CLI Copy Name : IBMDBCL1 ]
---------------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Success: The schema validation operation completed successfully.
The configuration file C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg is valid
Note: The validation operation utility could not find the
configuration file named db2cli.ini.
The file is searched at C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2cli.ini
db2dsdriver.cfg Validation :
---------------------------------------------------------------------------
[ DB2DSDRIVER_CFG_PATH env var : unset ]
[ db2dsdriver.cfg Path : C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg ]
---------------------------------------------------------------------------
[ Valid keywords used for DSN : sample ]
Keyword Value
--------------------------------------------------
DATABASE STLEC1
HOSTNAME TOREC48.ibm.com
PORT 446
---------------------------------------------------------------------------
Connection Section :
---------------------------------------------------------------------------
Connecting to: sample
Connect Status: success
End Connection Section
---------------------------------------------------------------------------
The validation completed.
驗證 CLPPlus
- 在作業系統提示中,鍵入具有 username 及 dsn-alias 參數的 clpplus 指令,以啟動 CLPPlus。
- 輸入與所提供使用者名稱相關聯的密碼。
C:\>clpplus db2admin@sampledsn
CLPPlus: Version 1.4
Copyright (c) 2009, 2011, IBM CORPORATION. All rights reserved.
Enter password: **********
Database Connection Information :
---------------------------------
Hostname = samplehost.domain.com
Database server = DB2/NT SQLXXXXX
SQL authorization ID = db2admin
Local database alias = SAMPLEDSN
Port = 19766
建立別名的 ODBC DSN
使用 db2cli registerdsn -add sampledsn -system 指令,建立 DSN 別名 sampledsn 的系統資料來源名稱 (DSN)。
db2cli32 registerdsn -add sampledsn -system
使用 MS Excel 來測試 ODBC DSN
您可以使用 Microsoft 應用程式(例如 MS Excel)來測試新建立的 ODBC DSN。
程序
- 從控制台 -> 系統管理工具 -> 資料來源 (ODBC)(64 位元二進位),啟動 ODBC 管理者工具。針對 64 位元機器中的 32 位元二進位,請從 System Drive:\windows\SysWOW64\odbcad32.exe 中啟動 ODBC 管理者工具。例如:c:\windows\syswow64\ odbcad32.exe
- 依預設會顯示使用者資料來源清單。按一下系統 DSN 標籤。
- 選取新建立的 DSN(即範例中的 sampledsn),然後按一下配置。
- 輸入使用者名稱及密碼,然後按一下連接。此時會顯示「已順利測試連線」訊息。
- 啟動 Microsoft 應用程式,以及使用新建立的 DSN。例如,
- 啟動 MS Excel。
- 跳至資料 -> 匯入外部資料 -> 新增資料庫查詢。ODBC DSN 清單會顯示在清單框中。註: 32 位元 Excel 應用程式只會在清單框中顯示 32 位元 DSN,而 64 位元 Excel 只會在清單框中顯示 64 位元 DSN。
- 選取想要連接的 DSN(在此範例中為 sampledsn),然後提供登入詳細資料。此時會在資料庫中顯示表格清單。
測試 ADO.NET 驅動程式的連線功能
C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20 -dtc "database=sampledsn;uid=username;pwd=password"
adding MSDTC step
Step 1: Printing version info
.NET Framework version: X.X.XXXXX.XXXX
DB2 .NET provider version: X.X.X.X
DB2 .NET file version: XX.X.X.X
Capability bits: ALLDEFINED
Build: sXXXXXX
Factory for invariant name IBM.Data.DB2 verified
Elapsed: 1.2969165
Step 2: Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg against C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.xsd
Elapsed: 0
Step 3: Connecting using "database=sampledsn;uid=username;pwd=password"
Server type and version: DB2/NT 09.07.0003
Elapsed: 2.8594665
Step 4: Selecting rows from SYSIBM.SYSTABLES to validate existence of packages
SELECT * FROM SYSIBM.SYSTABLES FETCH FIRST 5 rows only
Elapsed: 0.3281355
Step 5: Calling GetSchema for tables to validate existence of schema functions
Elapsed: 0.906279
Step 6: Creating XA connection
DB2TransactionScope: Connection Closed.
Elapsed: 3.2657295
Test passed.
您可以忽略未適當地安裝 VSAI 錯誤。因為 VSAI 只適用於 32 位元,而 64 位元 testconn20 偵測不到,所以會顯示此錯誤。32 位元版本的 testconn20 應該適當地報告 VSAI 資訊。C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20 -dtc "database=sample;server=samplehost.domain.com:19766;uid=username;pwd=password"
C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20_32 -dtc "database=sampledsn;uid=username;pwd=password" adding MSDTC step
Step 1: Printing version info
.NET Framework version: X.X.XXXXX.XXXX
DB2 .NET provider version: X.X.X.X
DB2 .NET file version: XX.X.X.X
Capability bits: ALLDEFINED
Build: sXXXXXX
Factory for invariant name IBM.Data.DB2 verified
Elapsed: 1.2969165
Step 2: Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg against C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.xsd
Elapsed: 0
Step 3: Connecting using "database=sampledsn;uid=username;pwd=password"
Server type and version: DB2/NT 09.07.0003
Elapsed: 2.8594665
Step 4: Selecting rows from SYSIBM.SYSTABLES to validate existence of packages
SELECT * FROM SYSIBM.SYSTABLES FETCH FIRST 5 rows only
Elapsed: 0.3281355
Step 5: Calling GetSchema for tables to validate existence of schema functions
Elapsed: 0.906279
Step 6: Creating XA connection
DB2TransactionScope: Connection Closed.
Elapsed: 3.2657295
Test passed.
在伺服器總管中建立與 IBM Database Add-ins for Visual Studio 的連線
- 啟動 Visual Studio。
- 在「伺服器總管」中,於「資料連線」節點上按一下滑鼠右鍵,然後按一下「新增連線...」。
- 在新增連線對話框中,選取 .Net 資料來源的 IBM DB2 及 Informix® Data Provider。
- 按一下資料庫下拉清單,以列出 db2dsdriver.cfg 檔案中所定義的別名。請從下拉清單中選擇別名,或在資料庫名稱欄位中鍵入別名。
- 選取 sampledsn,並輸入使用者名稱及密碼,然後按一下測試連線。會顯示訊息框,以指出已通過測試連線。請關閉訊息框。
- 按一下連線對話框中的確定。現在會在「伺服器總管」中建立連線。
測試 IBM OLE DB Provider 的連線功能
透過將資料匯入至試算表應用程式,例如 MD Excel,您可以測試 IBM OLE DB Provider 連線功能。 不過,開始程序之前,請確定您已完成下列作業:- 安裝 Microsoft Excel 2003/2007/201 0/2013。
- 定義 db2dsdriver.cfg 檔案中的 DSN。 Data Server 驅動程式配置檔,db2dsdriver.cfg, 是包含 DSN 別名及其內容清單的 XML 檔案。 它是用來在某處儲存連線詳細資料。IBM OLE DB Provider 會使用該資訊自動連接至資料來源,而不是以互動方式詢問每一個連接嘗試的所有連線詳細資料。
- 啟動 Microsoft Excel。
- 若要開啟「資料連線精靈」,請根據 MS Excel 的版本來完成下列步驟中的其中一項:
Microsoft Excel 2003 - 選取 。
- 在「選取資料來源」視窗中,選取連接至 New Data Source.odc 再按一下開啟。
Microsoft Excel 2007/2010/2013 選取
。 - 在「資料連線精靈」中,選取其他/進階再按下一步。
- 在「資料鏈結內容」視窗的「提供者」標籤中,選取安裝期間選取的對應於 IBM Data Server Driver 副本名稱的 IBM OLE DB Provider for DB2,再按下一步。
- 在「全部」標籤中,選取資料來源,並且當您在 db2dsdriver.cfg 檔案中定義 DSN 名稱時進行鍵入。
- 輸入您嘗試連接資料庫的使用者 ID 及密碼,再按一下連接。
- 在「選取資料庫及表格」視窗中, 選取包含嘗試匯入資料的表格,再按一下確定。即會顯示預設資料連線檔案。 此檔案會儲存連線資訊,因此下次您從相同資料來源匯入資料時,您無需全部輸入。
- 按一下完成。
- 在「匯入表格」視窗中,選取工作表的起始欄來匯入表格資料,再按一下確定。 從資料庫表格將資料拉入選取工作表。
- 按一下確定。如果您的資料顯示於 Excel 中,則會連接 IBM OLE DB Provider。
安裝 PHP 驅動程式及驗證安裝
有兩種類型的 PHP 建置可用。一個 PHP 建置是 TS(執行緒安全),另一個則是 NTS(非執行緒安全)。您需要使用 PHP 驅動程式的對應建置類型。若要檢查已安裝的 PHP 建置類型,請執行下列指令:
$ php -i | findstr "Thread Safety"
DS 驅動程式只會隨附 32 位元版本的 PHP 驅動程式。
需要遵循下列步驟,以安裝 PHP 驅動程式:
- 執行下列根據所使用 PHP 驅動程式的指令:
兩個 PHP 驅動程式是 ibm_db2 及 pdo_db2。 而且,local_php_directory 指的是已安裝 PHP 的路徑。$ copy IBM DS Driver Install Path/php32/ibm_db2_XX[ts/nts].dlllocal_php_directory/php/ext $ copy IBM DS Driver Install Path/php32/pdo_db2_XX[ts/nts].dlllocal_php_directory/php/ext
- 使用下列資訊編輯 local_php_directory 目錄中的 php.ini 檔案,以在執行時期載入 ibm_db2 及 pdo_db2 模組:
您可以執行驗證程式 validate_install.php(位於已安裝 DS Driver 的 bin 目錄中),以驗證已順利配置 IBM PHP 驅動程式模組。 若要使用 validate_install.php 程式來驗證 IBM PHP 驅動程式,您可以連接至 db2dsdriver.cfg 檔案中所指定的 DSN 別名 sampledsn。您也可以指定連線詳細資料作為 validate_install.php 程式的引數。 validate_install.php 程式會連接至所指定伺服器上的資料庫,並傳回通知您連線成功或失敗的訊息。請執行下列指令,以執行 validate_install.php 程式:extension=ibm_db2_XX_[ts/nts].dll extension=pdo_ibm_XX_[ts/nts].dll
下列範例輸出是建立成功連線之後所傳回內容的範例:$php validate_install.php database name DSN alias port number username password
$ cd IBM DS Driver Install Path/ $ php bin/validate_install.php sampledsn Connection to database sampledsn, using ibm_db2 module, is successful. Connection to database sampledsn, using pdo_ibm module, is successful. [OR] $ php bin/validate_install.php sample samplehost.domain.com 50000 username password Connection to database sample, using ibm_db2 module, is successful. Connection to database sample, using pdo_ibm module, is successful.
註: 執行 validate_install.php 程式之後,可能會傳回下列訊息:
此訊息表示 PHP 是針對 64 位元架構所建置,或未適當地複製 PHP 驅動程式模組。The Program cannot start because phpx<ts>.dll is missing from your computer. Try reinstalling the program to fix this problem
安裝 Python 驅動程式及驗證安裝
DS Driver 包含 32 位元版本的 Python 驅動程式。若要安裝 32 位元 Python 驅動程式元件,請執行下列指令:
$ easy_install IBM DS Driver Install Path/python32/ibm_db-xx-xx.egg$
easy_install IBM DS Driver Install Path/python32/ibm_db_django-xx-xx.egg
$ easy_install IBM DS Driver Install Path/python32/ibm_db_sa-xx-xx.egg
您可以執行 validate_install.py 程式,以驗證 Python 驅動程式的安裝是否成功。validate_install.py 程式位於已安裝 DS Driver 的目錄中。若要使用 validate_install.py 程式來驗證 Python 驅動程式,您可以連接至 db2dsdriver.cfg 檔案中所定義的 DSN 別名 sampledsn。您也可以指定連線詳細資料作為 validate_install.py 程式的引數。 此 Python 程式會連接至所指定伺服器上的資料庫,並列印連線是否成功。請執行下列指令,以執行 validate_install.py 程式:
$python validate_install.py database name DSN alias port number username password
下列範例輸出是建立成功連線之後所傳回內容的範例:$ cd IBM DS Driver Install Path/
$ python bin/validate_install.py sampledsn
Connection to database sampledsn is successful.
[OR]
$ python bin/validate_install.py sample samplehost.domain.com
50000 username password
Connection to database sample is successful.