Linked Server to DB2 using IBMs OLEDB Provider (IBMDADB2)
-
Has anyone gotten that driver to work as a linked server? It works fine as a Linked Server using the MS ODBC, and it works fine as a OLEDB provider in a DTS package (which annoyed me even more).
What are the values that the 3 settings need to be (Product Name, Data Source, Provider String)?
What security options should I use?
I would be eternally grateful for any assiatance
-
is this db2 on os390 or AS400 or UDB on win/unix/..
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Thanks for responding.
It's UDB on UNIX...
-
I haven't used that combination yet.
We only use linked servers to non-sqlserver for problem solving. Only then the definitions are added and removed asap.
This is because we don't want to have all systems down because one is in maintenance or has an issue.
And (maybe more important) we have had serveral issues with these drivers failing when applying db2-fixpacks or ptf-s.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Product Name IBMDADB2, and can be anything really.
Data Source normally this is the DB2 DBname
Provider String can be something like
"Provider=IBMDADB2;Database=dbname;hostname=dbserver; port=dbserverport;protocol=TCPIP;uid=dbusername; pwd=db2pass"
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply