473,322 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Problems calling proc from MSVC via ODBC

1
A client has set up an ODBC connector to their DB2 database and requested my (existing) program call a proc they've defined. From my perspective, everything is working perfectly. Not so from their point of view. Turns out that their Proc is not receiving the variable's I'm passing in. If they hard-code the variables, I receive the return value and all is well. If their proc attempts to actually use the variables, then they are null. They've also (intermittently) reported seeing an error: 'CLI0110E Invalid output or Indicator buffer specified.'.

I have no recent experience with DB2 and no prior experience with ODBC in conjuction with DB2. I also don't have any direct access to the machine running my program.

Given that error message, I've spent some time fiddling with the SQLBindParameter and trying different values for the fParamType parameter and any others that seems significant. My existing code works quite nicely with MSSQL, Oracle, Centura, and even Excel, which, of course, means absolutely nothing in reguards to DB2, but still leads me to think I'm not doing something totally stupid here.

I would be thrilled if someone could offer some experience/thoughts/links to something that might give me a clue as to why their proc isn't seeing the data I'm attempting to pass.

Thanks,
Adam
May 15 '07 #1
0 1001

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

Similar topics

7
by: Együd Csaba | last post by:
Hi, I've a problem with some of my stored procs. My config is: RH7.1, Postgres 7.3.2 I had converted a few fields of a few tables from one type to another and after this I made all the...
2
by: Robert Oschler | last post by:
Need help with HEAP CORRUPTION and my MSVC 6 DLL I have a MSVC 6 DLL that I've written. It is used heavily by a Delphi 6 app I've written. For two months everything has been working fine. ...
2
by: Tim | last post by:
Hi, I am writing a console app in C++ that is going to be communicating with an MS SQL Server Database. I was going to use ODBC to do this and read that I need to include the afxdb.h header. ...
6
by: Uli | last post by:
Hello, I'm trying to use a DLL (by static linking) which was compiled with Borland C++Builder (BCB) in Visual C++ (Visual-Studio 2003). All functions are declared with the directive 'extern...
10
by: Eric E | last post by:
Hi all, I am using an Access client linked to a PG 7.4 server via ODBC. I have a stored proc on the server that inserts rows into a table.particular table, accomplished via an INSERT within the...
0
by: harsha_forum | last post by:
Hi All, Iam having a proc which has dynamic sql inside that. ex- Use Northwind CREATE PROC TEST(
10
by: syntego | last post by:
I think I have discovered a bug in the handling of null values (vs NULL values) passed as parameters to a stored proc. I have always believed that the database handled NULL and null the same. ...
2
by: rfdes | last post by:
Hi- I could use some help resolving a problem. This explanation will be lengthy as I am trying to describe my problem without posting real code. I currently have a Win32 console application & a...
4
by: raghuvendra | last post by:
Hi I have a jsp page with 4 columns: namely Category name , Category order, Input field and a submit button. All these are aligned in a row. And Each Category Name has its corresponding Category...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.