20080215 IBM DB2 OLEDB 资料
http://www.yippeesoft.com

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=zh-cn
Microsoft OLEDB Provider for DB2

      Microsoft OLE DB Provider for DB2 是一个 COM 组件，它可基于 Microsoft SQL Server 2005 Enterprise Edition 和 Developer Edition 将 IBM DB2 数据库中存储的关键数据与新的解决方案集成在一起。SQL Server 开发人员和管理员可以将此提供程序与 SQL Server Integration Services、SQL Server Analysis Services、复制和分布式查询处理器结合使用。运行自解压缩下载包以创建安装文件夹。该单个安装程序将在 x86 和 x64 计算机中安装提供程序和工具。有关更多信息，请阅读安装指南和自述文件。

      用户：客户、开发人员

            X86 Package (DB2OLEDB.exe) – 9028 KB
        http://download.microsoft.com/download/a/c/3/ac37a75a-1e0b-49ba-aea1-0f9b258e4965/DB2OLEDB.exe

You got DB2?  Got SQL?   Now you can connect them together, better.  Microsoft is making the OLEDB provider for DB2 available for download.

    The Microsoft OLE DB Provider for DB2 is a COM library for connecting to IBM DB2 databases.  It is licensed for use with solutions based on Microsoft SQL Server 2005 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with SQL Server Integration Services, SQL Server Analysis Services, Replication, and Distributed Query Processor.  The single setup program will install the provider and tools on both x86 and x64 computers. Read the installation guide and Readme for more information.

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/DB2OLEDB.exe

IBM also has an OLEDB provider for DB2, but it is licensed separately, I think at extra charge.  You have to buy the DB2 Client Access license or something like that.  This one is licensed with SQL2005 EE.  Nice!

http://blogs.msdn.com/dotnetinterop/archive/2006/01/19/oledb-provider-for-db2.aspx

http://blogs.msdn.com/dotnetinterop/archive/2006/01/19/oledb-provider-for-db2.aspx
OLE DB Provider for DB2

    * OLE DB Provider for DB2 (from Microsoft)

For TCP/IP connections

oConn.Open = "Provider=DB2OLEDB;" & _
             "Network Transport Library=TCPIP;" &  _
             "Network Address=xxx.xxx.xxx.xxx;" & _
             "Initial Catalog=MyCatalog;" & _
             "Package Collection=MyPackageCollection;" & _
             "Default Schema=MySchema;" & _
             "User ID=MyUsername;" & _
             "Password=MyPassword"
 

For APPC connections

oConn.Open = "Provider=DB2OLEDB;" &  _
             "APPC Local LU Alias=MyLocalLUAlias;" &  _
             "APPC Remote LU Alias=MyRemoteLUAlias;" &  _
             "Initial Catalog=MyCatalog;" & _
             "Package Collection=MyPackageCollection;" & _
             "Default Schema=MySchema;" & _
             "User ID=MyUsername;" & _
             "Password=MyPassword"

         Host Integration Server 2006
Brief Description
Download the Host Integration Server 2006 trial software to evaluate Microsoft’s tools and technologies for integrating existing IBM host systems with new solutions based on Microsoft Windows operating systems. Host Integration Server 2006 Evaluation Software will run for four months.
http://www.microsoft.com/downloads/details.aspx?familyid=E4A40127-D73C-4D41-B8B4-FBBE68EEC47E&displaylang=en

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0009064.htm
IBM OLE DB 提供程序 DB2 版

http://support.microsoft.com/?scid=kb%3Bzh-cn%3B218590&x=11&y=11
为 Microsoft OLE DB Provider INF： 配置用于 DB 2 数据源

ActiveConnection Property Support Using the OLE DB Provider for DB2
http://msdn2.microsoft.com/en-us/library/ms961750.aspx

select       *         from       OPENDATASOURCE(\’IBMDADB2.1\’, 
  \’Provider=IBMDADB2.1;Password=a;Persist   Security   Info=True; 
  User   ID=db2admin;Data   Source=DWCTRLDB;Location=jrc11:50000;Extended   Properties=\’\'\’).jrc11.db2admin.AGENTSITE   

  =>一般数据库操作略记：
–=======================================sqlserver全==================
—opendrowset
–操作sqlserver数据库
select * from openrowset(\’sqloledb\’,\’192.168.2.55\’;\’sa\’;\’sa\’,\’select * from hks.dbo.hks_mm_user\’)
–操作access数据库
select * from openrowset(\’Microsoft.Jet.OLEDB.4.0\’,\’d:\\data.mdb\’;\’admin\’;\’\',admin)
–操作excel数据库
select * from openrowset(\’microsoft.jet.oledb.4.0\’ ,\’excel 5.0;hdr=no;imex=2;database=D:\\data.xls\’,[sheet1$])
–操作text
select * from OPENROWSET(\’MICROSOFT.JET.OLEDB.4.0\’,\’Text;HDR=no;DATABASE=d:\\\’,[a#txt])
–操作db2
select * from openrowset(\’ibmdadb2\’,\’dsn=rich\’,\’select * from RICH.I_INSURANCEFOOD\’) –dsn 链接
select * from openrowset(\’ibmdadb2\’,\’dsn=ffff;uid=rich;pwd=*&^%4321\’,\’select * from RICH.I_INSURANCEFOOD\’) –dsn 链接 带密码

http://ahya78.spaces.live.com/Blog/cns!1p7R7kD6S3T0LDSFzkstT7_g!109.entry
 使用 IBM OLE DB provider for DB2（IBMDADB2）连接 DB2 UDB 数据库

 this provider is not included with SQL Server 2005 out-of-the-box.  However, you can download it for free at:

 

http://www.microsoft.com/Downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

 

You can download the whole feature pack, or if you just want the provider, scroll down to find the link.  The setup is pretty easy, just follow the ReadMe that comes with the provider.  There are some tricks with using it that are also in the ReadMe.  One such tip can be found on my blog (shameless plug) here:

http://mindyourdata.blogspot.com/search/label/IBM%20DB2

SQL Server 2005 Books Online (September 2007)
OLE DB Provider for DB2
http://technet.microsoft.com/en-us/library/ms178027.aspx

http://www.microsoft.com/Downloads/details.aspx?displaylang=zh-cn&FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc
Microsoft SQL Server 2005 功能包 – 2005 年 11 月

http://www.microsoft.com/Downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=zh-cn
Microsoft SQL Server 2005 功能包 – 2007 年 2 月

用Visual C＃中实现DB2数据库编程
http://www.cn-mpa.com/stu/c/300004413/

provider=ibmdadb2.1;password=db2admin;user   id=db2admin;data   source=dbname;location=xxxxx:50000;persist   security   info=true

http://www.yesky.com/imagesnew/software/tsql/ts_sp_adda_8gqa.htm

http://www.ibm.com/developerworks/cn/db2/library/techarticles/dm-0409cline2/index.html

http://www.ibm.com/developerworks/cn/db2/v9/index_download.html

DB2 9.5 免费与试用版本下载 DB2 Express-C 数据服务器     大小     下载链接
Windows 32 位 (x86)     297MB     下载

IBM Data Server Driver for ODBC, CLI and .Net

最新版的客户端下载
[url=http://www.ibm.com/developerworks/cn/db2/v9/index_download.html]

不同版本的Run-Time   Client说明
[url=http://www.ibm.com/developerworks/cn/db2/library/techarticles/dm-0409cline2/index.html]

使用 Microsoft OLE DB Provider for DB2 整合 RPG 與 CL 程式
http://www.microsoft.com/taiwan/msdn/library/2003/Nov-2003-tw/HIS_Integ_INT.htm

2
　
oconn.open = "provider=db2oledb;" &
　　　　　　　　　　 "network transport library=tcpip;" &
　　　　　　　　　　 "network address=myserver;" & _
　　　　　　　　　　 "package collection=mypackage;" &
　　　　　　　　　　 "host ccsid=1142"
　　　　　　　　　　 "initial catalog=mydb;" &
　　　　　　　　　　 "user id=myusername;" & _
　　　　　　　　　　 "password=mypassword;"

DB2OLEDB–
下面的示例创建一台名为   DB2   的链接服务器，该服务器使用用于   DB2   的   Microsoft   OLE   DB   提供程序。

EXEC   sp_addlinkedserver
      @server=\’DB2\’,
      @srvproduct=\’Microsoft   OLE   DB   Provider   for   DB2\’,
      @catalog=\’DB2\’,
      @provider=\’DB2OLEDB\’,
      @provstr=\’Initial   Catalog=PUBS;Data   Source=DB2;HostCCSID=1252;Network   Address=XYZ;Network   Port=50000;Package   Collection=admin;Default   Schema=admin;\’
———
或在企业管理里添加

 

历史博文

标签：, , ,
十一月 18, 2008 at 3:18 下午 by yippee 1,061 次
Category: Info
Tags: , , ,