SSMS Linked server connection for DB2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

SSMS Linked server connection for DB2

Author

Topic

vasu4us
Posting Yak Master

102 Posts

Posted - 2008-03-19 : 09:50:37

I am trying to establish a OLEDB connection for a db2 server from SSMS adn some one tell me the settings. I haver tried different options but failed.
This is my connection string from SSIS
"Data Source=DB2W;User ID=myid;Provider=IBMDADB2.1;Persist Security Info=True;"

I gave
Linked Server: DB2W
Provider: IBM OLEDB provider for DB2
Product name: ???
DataSource: ???
Provider string:???
Location: ???

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-19 : 09:59:41

Does this helps?

http://www.connectionstrings.com/?carrier=ibmdb2

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-19 : 10:03:50

Also see this: http://blogs.msdn.com/dotnetinterop/archive/2006/01/20/defining-a-db2-as-a-linked-server.aspx

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

vasu4us
Posting Yak Master

102 Posts

Posted - 2008-03-19 : 10:14:26

thanks - Connectionstrings really helped me for .net scripts for dynamic connections in SSIS.Here iam trying to configure inGUI mode in SSMS

I am trying to do in the gui mode right click Linked server and new then trying to set the properties -
Linked Server: DB2W
Provider: IBM OLEDB provider for DB2
Product name: ???
DataSource: ???
Provider string:???
Location: ???

looking at the connection string can someone tell me what should be this properties.
"Data Source=DB2W;User ID=myid;Provider=IBMDADB2.1;Persist Security Info=True;"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources