[unixODBC-dev] SQLEndTran returns SQL_SUCCESS forHY010(Function sequence error)

[G, Hemanth Kumar]

Yes, it is resolved. Thanks Nick :-)

I have one more doubt. 
Some of the ODBC calls are trying to change the odbc.ini to insert some
index or root information.
For e.g - SQLExecDirect(hstmt, (SQLCHAR *)"create unique index unq on
tmp(f1)", SQL_NTS);
Ultimately, the odbc.ini file has extra tabs and spaces added.
Here onwards, all the subsequent calls fail whenever they try to read
the information from odbc.ini.

I found out the line of code from DriverManager which is doing this
modification.
_iniDump.c#74
uo_fprintf( hStream, "%s\t\t%c %s\n", hIni->hCurProperty->szName,
hIni->cEqual, hIni->hCurProperty->szValue );

I am not very much sure about the standard format of odbc.ini. 
Should it be of this format which you are using with two tabs and a
space.

BEFORE

[testdsn]
Driver=/opt/teradata/client/13.1/odbc_32/lib/tdata.so
Description=Teradata running Teradata V1R5.2
DBCName=gingham
LastUser=
Username=
Password=
Database=
DefaultDatabase=
SessionMode=Teradata
DateTimeFormat=III
OutputAsResultSet=Yes
UseNativeLOBSupport=Yes

AFTER

[testdsn]
Driver          = /opt/teradata/client/13.1/odbc_32/lib/tdata.so
Description             = Teradata running Teradata V1R5.2
DBCName         = gingham
LastUser                =
Username                =
Password                =
Database                =
DefaultDatabase         =
SessionMode             = Teradata
DateTimeFormat          = III
OutputAsResultSet               = Yes
UseNativeLOBSupport             = Yes
Order           = 0
IndexName0              = unq (f1) ODBC.tmp


Please help me on this.

Thanks
Hemanth.

-----Original Message-----
From: unixodbc-dev-bounces at mailman.unixodbc.org
[mailto:unixodbc-dev-bounces at mailman.unixodbc.org] On Behalf Of Nick
Gorham
Sent: Wednesday, June 17, 2009 3:26 PM
To: Development issues and topics for unixODBC
Subject: Re: [unixODBC-dev] SQLEndTran returns SQL_SUCCESS
forHY010(Function sequence error)

G, Hemanth Kumar wrote:
> Yes, it works.
> Thanks.
>
> I have found out one more issue.
>
> SQLStatistics with TableName argument as a null pointer should return
> HY009 - Invalid use of null pointer, but returns SQL_SUCCESS.
> SQLStatistics(hstmt,NULL,SQL_NTS,NULL,SQL_NTS,NULL,SQL_NTS,0,0);
> Expected : HY009
> Received : SQL_SUCCESS
>
> Please verify this one too.
>
> Thanks
> Hemanth.
>  
>   
Try now :-)

--
Nick
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev at mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev