How to configure ODBC DSN in Client to access DB2 for Windows.docx
- 文档编号:2460636
- 上传时间:2023-05-03
- 格式:DOCX
- 页数:11
- 大小:579.14KB
How to configure ODBC DSN in Client to access DB2 for Windows.docx
《How to configure ODBC DSN in Client to access DB2 for Windows.docx》由会员分享,可在线阅读,更多相关《How to configure ODBC DSN in Client to access DB2 for Windows.docx(11页珍藏版)》请在冰点文库上搜索。
HowtoconfigureODBCDSNinClienttoaccessDB2forWindows
HowtoconfigureODBCDSNinClienttoaccessremoteDB2forWindows
MAGenfeng
(GuangdongUnitollServicesincorporated,Guangzhou510300)
AbstractThisarticleintroduceshowtoconfigureODBCDSNinClienttoaccessremoteDB2forwindowsindetail.ThenIgiveasamplehowtoaccessremoteDB2databasewithODBCbyDBQueryAnalyzerexpediently.
It’salsoapplicabletoconfigureODBCDSNtoaccessremoteDB2forotherOSsuchasAix,Linux,Solarisandsoon.
KeywordsODBC;DBQueryAnalyzer;DB2
1GetportnumberofDB2instance
WeshouldgetportnumberofDB2instanceatfirst.Pleaserundb2commandlineprocess,theninput‘DB2getdbmcfg|find"SVCENAME"’togettheSVCENAMEdb2c_DB2ofDB2TCP/IP.
Figure1GettheSVCENAMEdb2c_DB2ofDB2TCP/IP
ClickonStart->Runandtypedriverstolocatethedirectoryc:
\winnt\system32\driversinwindows2000orc:
\windows\system32\driversinWindowsXPorWin7andsoon.Thenopenthesubdirectoryetcandopenthefileservices.ThisisshowninFigure2.
Figure2Locateandopenfileservices
Thenyou’llseetheportnumberofdb2c_DB2is50000.
2ConfigureODBCDSNinClient
OpentheDB2configurationAssistantfirstandthenstarttoconfigureODBCDSNasit’sshownfromFigure3toFigure11.
Figure3ConfigureODBCDSNwithDB2configurationAssistant
Figure4ConfigureODBCDSNwithDB2configurationAssistant
Figure5ConfigureODBCDSNwithDB2configurationAssistant
Figure6ConfigureODBCDSNwithDB2configurationAssistant
Figure7ConfigureODBCDSNwithDB2configurationAssistant
Figure8ConfigureODBCDSNwithDB2configurationAssistant
Inthedrop-downlistbox,selectOStoconfigureODBCDSNtoaccessremoteDB2forotherOSsuchasWindows,Aix,Linux,Solarisandsoon.
Figure9ConfigureODBCDSNwithDB2configurationAssistant
Figure10ConfigureODBCDSNwithDB2configurationAssistant
Figure11ConfigureODBCDSNwithDB2configurationAssistant
Finally,Clickbutton‘Finish’toendtheprocess.
3AccessDB2databasewithDBQueryAnalyzer
DBQueryAnalyzerispresentedbyMasterGenfeng,MafromChineseMainland.IthasEnglishversionnamed‘DBQueryAnalyzer’andSimplifiedChineseversionnamed‘万能数据库查询分析器(DB查询分析器)’.
DBQueryAnalyzerisoneofthefewexcellentClientToolsintheworldforits’powerfulfunction,friendlyinterface,easyoperationandapplicabilitytoeveryproductionofRDBMS.
ItletsyouqueryODBCdatasources,authorSQLscriptsandqueries,returnqueryresultstoagridorfree-formtextorafile,retrieveODBCdriverinformation,executemultipleSQLscriptsorstoredproceduressimultaneously,andmore.
IntheNewproducts&Toolsreviewsofprogrammersecondissueof2007,DBQueryAnalyzerhadbeenstronglyrecommended.
NowtheSimplifiedChineseversionofDBQueryAnalyzeristhetop50databaseapplicationsoftwareinthefamoussoftwarewebsite.Inmostcaseitliesthetop20andithasbeendownloadmorethan92,000times.
DownloadandinstallDBQueryAnalyzer.ThenrunitandinputtheDSN’MGF_DB1’,UserNameandPassword.
Figure12RunDBQueryAnalzyer
Figure13ObjectViewinDBQueryAnalyzerandfastSQLScriptprogram
Remarks:
Pleaseuninstalltheformerversionfirst,theninstallthelatestversion.
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- How to configure ODBC DSN in Client access DB2 for Windows
链接地址:https://www.bingdoc.com/p-2460636.html