I am just following the same process what you said here. The TestConnection on the Management Studio is successfull but when i look under the linked databases it does not show me tables, what can I do? Give it a name, paste connection string in "Provider String".Select 'Microsoft OLE DB Provider for DB2'.Open UDL file in notepad, copy entire "Provider=." string. Thanks!įor others who come along later, here's what I successfully used. Just wanted to say this works great! I was having trouble getting the linked servers to show any tables using the traditional linked servers config, but after finding your post and applying a few tweaks, I managed to get exactly what I needed. Please note the main correction I did being used the parameter instead of ĮXEC = ID=XXX Password=XXX Initial Catalog=TWS Network Transport Library=TCPIP Host CCSID=37 PC Code Page=1252 Network Address= Network Port=50000 Package Collection=TWS Default Schema=MDL Process Binary as Character=False Connect Timeout=15 Units of Work=RUW DBMS Platform=DB2/NT Defer Prepare=False DateTime As Char=False Rowset Cache Size=0 DateTime As Date=False Auth Encrypt=False Max Pool Size=100 Database Name=TWS AutoCommit=True Authentication=Server Persist Security Info=True Connection Pooling=True Derive Octo10:48:08 AM - TigerJohn I am connecting to a DB2 server hosted on Windows platform (DB2/NT). I was able to use it to a greater extent and I want to point out few things that worked out for me with some alterations. I am a iSeries programer and working in c#. I then get the error "Cannot initialize the data source objectof OLE DB provider "DB2OLEDB" FOR LINKED SERVER iseriesĪny suggestion on how to resolve this. Everything goes fine until I try to connect at the end. I am trying to create a linked server to an iSeries. Tuesday, Decem7:00:40 PM - Lonnie kendall What steps would we need to take? Is it simply modifying the Linked Server definition? We want to replace Shadow Direct with DB2 Direct drivers. We currently have a SQL Server linked server set up to IBM DB2 on mainframe using Shadow Direct drivers. Wednesday, Septem3:45:41 PM - Angela Love This worked on SSMS latest version of October 2021!īut please fix the last image: the string generated should be inserted into the "Provider string" not the "Catalog" Monday, Octo5:49:25 AM - Francesco Mantovani
0 Comments
Leave a Reply. |