unixODBC developer's list

headers G, Hemanth Kumar | 1 Jul 2009 07:15

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

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

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

G, Hemanth Kumar wrote:
>
> Hello Nick,
>
>      SQLSetParam with zero ValueType is expected to return HY003, but 
> returns success.
>
> SQLSetParam(hstmt,1,0,4,10,0,rgbValue,NULL);
> Expected: HY003
> Received : SQL_SUCCESS
>
> Pls validate.
>
> Thanks
> Hemanth.
>
I will be away for a couple of days, so I will take a look when I get back.

--

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

G, Hemanth Kumar wrote:
>
> Hello Nick,
>
> SQLTransact(henv, NULL, 0) when called before connecting is expected 
> to return SQL_SUCCESS. Instead, is returning 08003.
>
> SQLTransact(henv,SQL_NULL_HDBC,SQL_COMMIT);
> Expected: SQL_SUCCESS
> Received : 08003 (Connection does not exit)
>
> SQLTransact with statement handle is giving success. Ideally, should 
> return invalid handle.
> SQLTransact(hstmt, hdbc, SQL_COMMIT);
> Expected : SQL_INVALID_HANDLE
> Received: SQL_SUCCESS
>
> Please verify them once.
>
> Thanks
> Hemanth.
>
Should be done now.

--

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

G, Hemanth Kumar wrote:
>
> Hello Nick,
>
>      SQLSetParam with zero ValueType is expected to return HY003, but 
> returns success.
>
> SQLSetParam(hstmt,1,0,4,10,0,rgbValue,NULL);
> Expected: HY003
> Received : SQL_SUCCESS
>
> Pls validate.
>
> Thanks
> Hemanth.
>
Should be done now.

--

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

G, Hemanth Kumar wrote:
>
> Nick,
>
> SQLConnect Using DSN with length of zero, is expected to return IM002, 
> but returns success.
> SQLConnect(hdbc, dsn, 0, uid, SQL_NTS, pwd, SQL_NTS);
> Expected: IM002
> Received : 000000
>

Can you check there isnt a [DEFAULT] section in the ini file?
>
> SQLConnect with null DSN and with length above zero, is expected to 
> return IM002, returns IM010 instead.
> SQLConnect(hdbc, NULL, 10, uid, SQL_NTS, pwd, SQL_NTS);
> Expected: IM002
> Received: IM010
>
Should be done now.

--

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

Thanks Nick.

DEFAULT section was intentionally removed to check whether the API was
returning the expected return code or not. 

-----Original Message-----

Can you check there isnt a [DEFAULT] section in the ini file?
>
> SQLConnect with null DSN and with length above zero, is expected to 
> return IM002, returns IM010 instead.
> SQLConnect(hdbc, NULL, 10, uid, SQL_NTS, pwd, SQL_NTS);
> Expected: IM002
> Received: IM010
>
Should be done now.

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

This is an FYI...

openSuse x64

Built the latest unixODBC (from cvs) and then tried building sqliteodbc. 
Perhaps a problem here...

creating ./config.status
creating Makefile
creating sqliteodbc.spec
pharvey <at> xeon:~/Downloads/sqliteodbc-0.83> make
./libtool --mode=compile gcc -g -O2 -DDRIVER_VER_INFO=\"0.83\"  -c \
                    -I/usr/include -DHAVE_UNIXODBC=1 -I/usr/include 
-DHAVE_ODBCINSTEXT_H=1 -Imissing -DHAVE_SQLLEN=1 -DHAVE_SQLULEN=1 
-DHAVE_SQLSETPOSIROW=1 -DCOLATTRIBUTE_LAST_ARG_TYPE=SQLLEN_PTR 
-DHAVE_LONG_LONG=1 -DPTRDIFF_T=ptrdiff_t -DUSE_DLOPEN_FOR_GPPS 
-DCANT_PASS_VALIST_AS_CHARPTR=1 -DHAVE_USLEEP=1 -DHAVE_LOCALECONV=1 
-DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DWITHOUT_WINTERFACE=1 \
                    -DHAVE_SQLITE3COLUMNTABLENAME=1 
-DHAVE_SQLITE3LOADEXTENSION=0 -DHAVE_SQLITE3OVERLOADFUNCTION=1 
-DHAVE_SQLITE3PREPAREV2=1 -DHAVE_SQLITE3CLEARBINDINGS=1 
-DHAVE_SQLITE3CREATEMODULEV2=1 -DHAVE_SQLITE3VFS=1 
-DHAVE_SQLITE3TABLECOLUMNMETADATA=1 sqlite3odbc.c
mkdir .libs
gcc -g -O2 -DDRIVER_VER_INFO=\"0.83\" -c -I/usr/include 
-DHAVE_UNIXODBC=1 -I/usr/include -DHAVE_ODBCINSTEXT_H=1 -Imissing 
-DHAVE_SQLLEN=1 -DHAVE_SQLULEN=1 -DHAVE_SQLSETPOSIROW=1 
-DCOLATTRIBUTE_LAST_ARG_TYPE=SQLLEN_PTR -DHAVE_LONG_LONG=1 
-DPTRDIFF_T=ptrdiff_t -DUSE_DLOPEN_FOR_GPPS 
-DCANT_PASS_VALIST_AS_CHARPTR=1 -DHAVE_USLEEP=1 -DHAVE_LOCALECONV=1 
-DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DWITHOUT_WINTERFACE=1 
-DHAVE_SQLITE3COLUMNTABLENAME=1 -DHAVE_SQLITE3LOADEXTENSION=0 
-DHAVE_SQLITE3OVERLOADFUNCTION=1 -DHAVE_SQLITE3PREPAREV2=1 
-DHAVE_SQLITE3CLEARBINDINGS=1 -DHAVE_SQLITE3CREATEMODULEV2=1 
-DHAVE_SQLITE3VFS=1 -DHAVE_SQLITE3TABLECOLUMNMETADATA=1 sqlite3odbc.c  
-fPIC -DPIC -o .libs/sqlite3odbc.lo
sqlite3odbc.c:7676: error: conflicting types for 'SQLSetStmtOption'
/usr/include/sql.h:796: error: previous declaration of 
'SQLSetStmtOption' was here
make: *** [sqlite3odbc.lo] Error 1
pharvey <at> xeon:~/Downloads/sqliteodbc-0.83>

--
Peter

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

Peter Harvey wrote:
> This is an FYI...
>
> openSuse x64
>
> Built the latest unixODBC (from cvs) and then tried building 
> sqliteodbc. Perhaps a problem here...

I need to do some work on the CVS status, 2.2.15pre is not back in CVS 
at the moment. There will be a lot of changes, mainly relating to 
removing the bits that are now in their own projects now. I was musing 
changing to SVN at this point. What do people think?

The current 2.2.15pre source is on the ftp site though if needed.

--

-- 
Nick

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

Mon	Tue	Wed	Thu	Fri	Sat	Sun

		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

3	May 2013
22	April 2013
2	February 2013
1	January 2013
12	November 2012
9	October 2012
5	July 2012
2	June 2012
2	March 2012
8	February 2012
3	December 2011
6	August 2011
18	July 2011
14	June 2011
5	May 2011
8	April 2011
2	March 2011
2	February 2011
1	November 2010
9	July 2010
2	May 2010
3	April 2010
5	March 2010
12	February 2010
4	December 2009
3	October 2009
2	September 2009
20	August 2009
15	July 2009
73	June 2009
10	May 2009
4	April 2009
5	March 2009
38	February 2009
57	January 2009
56	December 2008
26	November 2008
23	October 2008
11	September 2008
29	August 2008
19	July 2008
21	June 2008
13	May 2008
1	April 2008
36	March 2008
1	February 2008
20	January 2008
13	December 2007
26	November 2007
8	October 2007
2	August 2007
3	June 2007
35	May 2007
11	April 2007
12	March 2007
62	February 2007
4	January 2007
1	December 2006
8	October 2006
9	August 2006
6	July 2006
14	May 2006
19	April 2006
3	March 2006
1	February 2006
17	January 2006
13	December 2005
87	November 2005
38	October 2005
56	September 2005
15	August 2005
41	July 2005
30	June 2005
37	May 2005
24	April 2005
134	March 2005
38	February 2005
26	January 2005
56	December 2004
48	November 2004
49	October 2004
42	September 2004
60	August 2004
74	July 2004
77	June 2004
74	May 2004
67	April 2004
53	March 2004
80	February 2004
65	January 2004
89	December 2003
32	November 2003
38	September 2003
28	August 2003
39	July 2003
55	May 2003
66	April 2003
51	March 2003
30	February 2003
28	January 2003
10	December 2002

Incorrect states with SQLTransact

Incorrect states with SQLConnect

SQLSetParam returning success for HY003

Re: SQLSetParam returning success for HY003

Re: Incorrect states with SQLTransact

Re: SQLSetParam returning success for HY003

Re: Incorrect states with SQLConnect

Re: Incorrect states with SQLConnect

unixODBC (as per cvs) and current source for sqlite odbc

Re: unixODBC (as per cvs) and current source for sqlite odbc