I am trying to write a simple DB2 CLI application but somehow there is always an SQL_ERROR while allocating Connection Handle. Can someone please have a look and help me figure out the issue ( I am using Visual Studio Express, DB2 9). The code is pasted below:
I have changed a couple of things around and I've figured out that the error is SQLSTATE HY010 , [Microsoft][ODBC Driver Manager] Function sequence error! As far as I can see, The environment handle is correctly setup before I am trying to allocate the Connection Handle. Is there anything wrong with what I'm trying to do.
I have a feeling that this question is more of a 'C' question, than a Db2 question now, but any help would be appreciated. Programming in C after a stint in COBOL and zOS has it's effects!
you could have a look at the ibm supplied samples : below sqllib/samples you have samples for many coding languages....
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
Thanks for the Reply. In fact I have been looking at the sample codes under SQLLIB\samples\cli and the IBM Manuals "Call Level Interface Guide and Reference Vols 1 & 2" as I've just started with ODBC/CLI and DB2 programming.