Solved

ODBC API Constants

Posted on 1997-06-25
4
470 Views
Last Modified: 2010-05-18
Hi I am desperately looking for ODBC constants values
for example SQL_PARAM_INPUT
I have no VB CD(and no ODBC folders installed) no ODBC SDK include files too, therefore I am declaring functions manually, but cannot complete programs without constant values.
Matthew
mativare@i-2000.com
0
Comment
Question by:mativare
  • 2
4 Comments
 
LVL 7

Expert Comment

by:tward
ID: 1427727
I have the ODBC Help files etc but no where in them does it talk about SQL_PARAM_INPUT.  What version of VB, 32bit or 16Bit, what version of ODBC?
0
 
LVL 5

Accepted Solution

by:
y96andha earned 50 total points
ID: 1427728
I have a file named sqlext.h, which I think contains the values that you need in C declare statements. Here are the ones you asked for. Please comment if you need any others.

#define SQL_PARAM_TYPE_UNKNOWN           0
#define SQL_PARAM_INPUT                  1
#define SQL_PARAM_INPUT_OUTPUT           2
#define SQL_RESULT_COL                   3
#if (ODBCVER >= 0x0200)
#define SQL_PARAM_OUTPUT                 4
#define SQL_RETURN_VALUE                 5
#end if
0
 
LVL 1

Author Comment

by:mativare
ID: 1427729
Hi Thank You For a Million For Constant values.
If it is convinient for you feel free to Email me the file
SQLEXT.h as a ad.
Thanks  in advance
Matthew
mativare@i-2000.com
0
 
LVL 5

Expert Comment

by:y96andha
ID: 1427730
OK, I'll be e-mailing it right away.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question