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

Subscribe Post Reply

2693

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

by: aychai | last post by:

Hi all, I am trying to make use Oracle9i db to call an external .Net Web Service from a JAva Stored Procedure. I created the .Net Web Service and use JDeveloper 9.0.3.4Build(1247) to create...

Oracle Database

HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET

by: Nashat Wanly | last post by:

HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET View products that this article applies to. This article was previously published under Q310070 For a Microsoft...

Microsoft SQL Server

call db2dari proc pb on V8.1 FP4

by: Jean-Marc Blaise | last post by:

Dear all, I have simulated the windows MULTI application with a java program calling the SQLTP1DL proc referenced as DB2DARI application, on Linux Intel or ZLinux. If the proc is NOT FENCED,...

DB2 Database

ASP.NET page doesn't timeout when hanging on database call

by: Marcin Belczewski | last post by:

I have ASP.NET page that invokes a stored procedure in the database. It takes about 60 seconds for the stored procedure to complete. In web.config I have <httpRuntime executionTimeout="10"/> and...

ASP.NET

Help creating a stored procedure to call from .Net

by: RSH | last post by:

Im trying to create a stored procedure of the following code. I want to set it so that I have to send the first 4 variables (@DB, @BackUpFile,@TestDB,@RestoreFile). I am having trouble when i try...

Visual Basic .NET

CLI0119E from "call sqlj_install_jar()" in PHP

by: Larry Menard | last post by:

Test code: $dbconn = odbc_connect($dbname, $username, $password); $path = "C:\Temp\myJar.jar"; $statement = "CALL SQLJ.INSTALL_JAR('file://$path', 'myJarId')"; $result = odbc_exec($dbconn,...

DB2 Database

PHP and MySQL: How to Properly call a Stored Procedure with Output Parameters from PHP - mysql, mysqli, or PDO

by: IamtheEvster | last post by:

Hi All, I am currently using PHP 5 and MySQL 5, both on Fedora Core 5. I am unable to call a MySQL stored procedure that returns output parameters using mysql, mysqli, or PDO. I'm having a...

PHP

ASP.net insists on using dbo. to call aspnet_* stored procedures

by: Pedro Vera | last post by:

I am helping somebody setup one of the asp.net starter kits. I converted it from sql express to sql server with no real issues, and I got it running local perfectly. On my first attempt to run...

ASP.NET

OBDC Stored Procedure Call using PHP

by: ckauvar | last post by:

The PHP below calls a stored procedure in a MSSQL database when I am using SQL in a Windows environment. I've recently switched to a UNIX environment and am now using ODBC (via FreeTDS) to connect...

PHP

Web service to call sql stored procedure

by: barmatt80 | last post by:

I don't know if this is the right part of the forum. But.... I have been working all night trying to create a web service to call a stored procedure in sql server 2008. The stored procedure calls...

ASP.NET

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...

Oracle Database

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...

PHP

FPGA Question

by: Oralloy | last post by:

Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...

General

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...

General

Problems to capture mouse_down event on a control within a form with lots of controls

by: Ricardo de Mila | last post by:

Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

Microsoft Access / VBA

Datasheet Form, iterate through records

by: Johno34 | last post by:

I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...

Microsoft Access / VBA

Hide Labels depending on checkbox value

by: ezappsrUS | last post by:

Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...

Microsoft Access / VBA

Handling .click() in the Safari browser

by: DizelArs | last post by:

Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...

Javascript

Call DB2 database from sql stored procedure

Similar topics