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

Nick Gorham <[email protected]>
Newsgroups gmane.comp.db.unixodbc.devel
Message-ID <[email protected]>
On 08/11/12 13:26, Martin J. Evans wrote:
> 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
>
> The driver manager issued the function sequence error as can be seen 
> by "[unixODBC][Driver Manager]". If the driver reported the issue, it 
> would be named in [] at the right.
>

Just checked the statement state transition docs.

A SQLDescribeParam in S4 (Executed) will return a HY010, so its doing 
what it should, you need to call the describe before the execute (S2 or S3)

http://msdn.microsoft.com/en-us/library/windows/desktop/ms710996%28v=vs.85%29.aspx

-- 
Nick
_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.