Re: I am getting "Function Sequence Error" When I try to do SQLDescribeParam() using my native ODBC

Thank a lot Nick for the reply. I will start DM tracing and see which call failed before SQLDescribeParam.

Thanks
~Aniruddha

From: [email protected] [mailto:[email protected]] On Behalf Of Nick Gorham
Sent: Thursday, November 08, 2012 6:51 PM
To: Development issues and topics for unixODBC
Subject: Re: [unixODBC-dev] I am getting "Function Sequence Error" When I try to do SQLDescribeParam() using my native ODBC

On 08/11/12 12:24, Aniruddha Kulkarni wrote:
Hi,

I am stuck with some issue here. I am trying to do certain operations on back-end using my native ODBC driver however when I call SQLDescribeParam() through my application it gives me an error as - SQLDescribeParam -> Rc = SQL_ERROR, Msg = [unixODBC][Driver Manager]Function sequence error

Here is the scenario which encountered this problem:

1>   Connect to backend using SQLConnect()

2>   Prepare an insert query having geometry as col type using SQLPrepare()

3>   Set the statement attributes using SQLSetStmtAttr()

4>   Bind the parameters with the data type using SQLBindParameter()

5>   Then execute the parameterized query using - SQLExecute()

6>   Call SQLNumParams() on statement

7>   Then in a loop, call SQLDescribeParam() with the appropriate function arguments.

With this sequence of functions I am getting the mentioned error. My doubt is on unixODBC driver manager I have been using, because if I try to run the application without DM then it works as expected. So I believe there is some error that is caught by driver manager and error is thrown.

Can anybody please shed some light on the probable cause of the error?

Thanks
~Aniruddha

You don't say which version of the DM you are using, but I would turn DM tracing on and see if one of the calls before the SQLDescribeParam failed.

--
Nick

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev