468,316 Members | 2,029 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

Call DB2 database from sql stored procedure

I am in need of calling a DB2 stored procedure from MS SQL server 2005. If this is all possible.

The ultimate goal is to have a user open the vb.net program, enter the employee ssn, and it will return some employee information. The ssn would be passed from the program to the sql stored procedure, which inturn would pass along the ssn to the db2 stored procedure, which would return Employee first name, last name, annual, sick, other and family leave balances. Then i would display those items in text boxes in my vb.net program.

So is this even possible? I am usre there is or might be a better option, but I don't know it. Any suggestions, starting points, books, or any other items to help me accomplish this?

thanks!
Sep 15 '08 #1
1 2533
iburyak
1,017 Expert 512MB
I think your DBA can install DB2 drivers on your SQL server and link to DB2 database as a linked server. Then it would be easy to prefix any procedure with linked server name.
See example here but as I said you need DB2 drivers installed:
http://blogs.msdn.com/dotnetinterop/archive/2006/01/20/defining-a-db2-as-a-linked-server.aspx



Good Luck.
Sep 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Jean-Marc Blaise | last post: by
2 posts views Thread by Marcin Belczewski | last post: by
13 posts views Thread by Larry Menard | last post: by
3 posts views Thread by ckauvar | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.