unixODBC developer's list

Nick Gorham | 16 Oct 2008 17:31

test (sorry)

Testing list manager out...

--

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

headers

Marco Vieira | 16 Oct 2008 21:00

odbc.ini configuration

Hi all,

Could some one help me solving this problem.

in my odbc.ini I'm trying to add the following parameter:

DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={CLASSPATH=/path_for_jar/jarFile.jar}

When i use "isql DEMOBRIDGE" to test my driver on the trace file a get this msg that says that is missing a class from the jarFile.jar.

[ODBC][3855][SQLConnect.c][3576]
                Entry:
                        Connection = 0x8050380
                        Server Name = [DEMOBRIDGE][length = 12 (SQL_NTS)]
                        User Name = [NULL]
                        Authentication = [NULL]
                ENV ATTR [SQL_ATTR_UNIXODBC_ENVATTR=$CLASSPATH=/path_for_jar/jarFile.jar] ret = -1

I've also put jarFile.jar in the jvm that is defined in odbcinst.ini (JvmPath), located in:
a) /path_to_jre/lib
b) /path_to_jre/lib/ext

When testing my driver with isql got the same error in my driver log:

Root exception is java.lang.ClassNotFoundException:......

Thanks in advance for your time.

Best Regards

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

headers

Nick Gorham | 16 Oct 2008 21:27

Re: odbc.ini configuration

Marco Vieira wrote:

> Hi all,
>
> Could some one help me solving this problem.
>
> in my odbc.ini I'm trying to add the following parameter:
>
> *DMEnvAttr = 
> SQL_ATTR_UNIXODBC_ENVATTR={CLASSPATH=/path_for_jar/jarFile.jar}*
>
> When i use "*isql DEMOBRIDGE*" to test my driver on the trace file a 
> get this msg that says that is missing a class from the jarFile.jar.
>
> *[ODBC][3855][SQLConnect.c][3576]
>                 Entry:
>                         Connection = 0x8050380
>                         Server Name = [DEMOBRIDGE][length = 12 (SQL_NTS)]
>                         User Name = [NULL]
>                         Authentication = [NULL]
>                 ENV ATTR 
> [SQL_ATTR_UNIXODBC_ENVATTR=$CLASSPATH=**/path_for_jar/jarFile.jar**] 
> ret = -1*
>
Hi,

the -1 indicates that it failed to set the value. So for example:

        DMEnvAttr       = 
SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/home/nick/product/9.2.0/}

Shows in the log file

        ENV ATTR 
[SQL_ATTR_UNIXODBC_ENVATTR=ORACLE_HOME=/home/nick/product/9.2.0/] ret = 0

I would check where the $ has come from

--

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

headers

Marco Vieira | 17 Oct 2008 09:43

Re: odbc.ini configuration

The $ came from test that I've made. In fact I've tested with and without the $, same result.

Any more ideas!?

2008/10/16 Nick Gorham <nick <at> lurcher.org>

Marco Vieira wrote:

Hi all,

Could some one help me solving this problem.

in my odbc.ini I'm trying to add the following parameter:

*DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={CLASSPATH=/path_for_jar/jarFile.jar}*

When i use "*isql DEMOBRIDGE*" to test my driver on the trace file a get this msg that says that is missing a class from the jarFile.jar.

*[ODBC][3855][SQLConnect.c][3576]
Entry:
Connection = 0x8050380
Server Name = [DEMOBRIDGE][length = 12 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]

ENV ATTR [SQL_ATTR_UNIXODBC_ENVATTR=$CLASSPATH=**/path_for_jar/jarFile.jar**] ret = -1*

Hi,

the -1 indicates that it failed to set the value. So for example:

DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/home/nick/product/9.2.0/}

Shows in the log file

ENV ATTR [SQL_ATTR_UNIXODBC_ENVATTR=ORACLE_HOME=/home/nick/product/9.2.0/] ret = 0

I would check where the $ has come from

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

--
Melhores Cumprimentos,

Marco António Vieira

PS:
Não mostre aos outros os endereços electrónicos dos teus amigos, apaga-os e use "Bcc" ou "Cco" (cópia oculta), para os reenvios.
Dificulta a propagação de Vírus, Spams e Banners. É para o bem de todos nós.

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

headers

Nick Gorham | 17 Oct 2008 10:21

Re: odbc.ini configuration

Marco Vieira wrote:

>The $ came from test that I've made. In fact I've tested with and without
>the $, same result.
>
>Any more ideas!?
>  
>

Do you get the -1 without the $

--

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

headers

Marco Vieira | 17 Oct 2008 11:14

Re: odbc.ini configuration

Yes.

[ODBC][4511][SQLConnect.c][3576]
                Entry:
                        Connection = 0x8050380
                        Server Name = [DEMOBRIDGE][length = 12 (SQL_NTS)]
                        User Name = [NULL]
                        Authentication = [NULL]
                ENV ATTR [SQL_ATTR_UNIXODBC_ENVATTR=CLASSPATH=/path_to_jarFile.jar] ret = -1

2008/10/17 Nick Gorham <nick <at> lurcher.org>

Marco Vieira wrote:

The $ came from test that I've made. In fact I've tested with and without
the $, same result.

Any more ideas!?

Do you get the -1 without the $

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

--
Melhores Cumprimentos,

Marco António Vieira

PS:
Não mostre aos outros os endereços electrónicos dos teus amigos, apaga-os e use "Bcc" ou "Cco" (cópia oculta), para os reenvios.
Dificulta a propagação de Vírus, Spams e Banners. É para o bem de todos nós.

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

headers

Nick Gorham | 17 Oct 2008 11:22

Re: odbc.ini configuration

Marco Vieira wrote:

>Yes.
>
>[ODBC][4511][SQLConnect.c][3576]
>                Entry:
>                        Connection = 0x8050380
>                        Server Name = [DEMOBRIDGE][length = 12 (SQL_NTS)]
>                        User Name = [NULL]
>                        Authentication = [NULL]
>                ENV ATTR
>[SQL_ATTR_UNIXODBC_ENVATTR=CLASSPATH=/path_to_jarFile.jar] ret = -1
>  
>

Just tried exactly what you have and it seems to work fine,

All I can suggest is try 2.2.13pre, as there may be a change I have 
forgotton in there, and if that still fails, then edit 
DriverManager/__attribute.c abd add some debug in __set_local_attribute 
after the putenv to displat errno and see just why its failing.

--

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

headers

Marco Vieira | 17 Oct 2008 15:15

Re: odbc.ini configuration

I'm using unixODBC 2.2.12, I'll give a try to 2.2.13pre

2008/10/17 Nick Gorham <nick <at> lurcher.org>

Marco Vieira wrote:

Yes.

[ODBC][4511][SQLConnect.c][3576]
Entry:
Connection = 0x8050380
Server Name = [DEMOBRIDGE][length = 12 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]
ENV ATTR
[SQL_ATTR_UNIXODBC_ENVATTR=CLASSPATH=/path_to_jarFile.jar] ret = -1

Just tried exactly what you have and it seems to work fine,

All I can suggest is try 2.2.13pre, as there may be a change I have forgotton in there, and if that still fails, then edit DriverManager/__attribute.c abd add some debug in __set_local_attribute after the putenv to displat errno and see just why its failing.

--
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

headers

Tony Khalil | 23 Oct 2008 11:06

HY003 error

Hi there,

I am using unixODBC with easysoft ODBC Driver for Linux. I downloaded odbcpp library in order to use it as an intermediate level between ODBC and MSSQL server. When trying to fetch data from the DB I get the following error:

[state HY003][unixODBC][Driver Manager]: Invalid Application Buffer Type.

This error does not occur if all the fields of the table accessed are of type “int”.

Do you have an idea what causes such an error and how could it be solved?

Regards,

Tony Khalil

===============

Beirut Office:

Yahchouchi Bldg.

Charles Malek Street – Achrafieh

Beirut – Lebanon

Tel: 961 1 213 027

Mob: 961 70839 646

Fax: 961 1 201 832

Paris office:

PRONERGY

5 rue Ampère

91380 CHILLY MAZARIN

Tel. +33 1 69194303

Fax. +33 1 69194301

Dubai Office:

Jebel Ali Free Zone

PO Box: 261 840

LOB 16-236

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

headers

Nick Gorham | 23 Oct 2008 11:15

Re: HY003 error

Tony Khalil wrote:

>Hi there,
>
> 
>
>I am using unixODBC with easysoft ODBC Driver for Linux. I downloaded odbcpp
>library in order to use it as an intermediate level between ODBC and MSSQL
>server. When trying to fetch data from the DB I get the following error:
>
>[state HY003][unixODBC][Driver Manager]: Invalid Application Buffer Type.
>
> This error does not occur if all the fields of the table accessed are of
>type “int”.
>
> 
>
>Do you have an idea what causes such an error and how could it be solved?
>
> 
>
I would expect its the functio that checks the buffer type that has 
signaled a invalid type

check_target_type( target_type )

That checks that the SQL Type is one of the folowing:

switch( c_type ) {
case SQL_C_CHAR:
case SQL_C_LONG:
case SQL_C_SHORT:
case SQL_C_FLOAT:
case SQL_C_NUMERIC:
case SQL_C_DEFAULT:
case SQL_C_DATE:
case SQL_C_TIME:
case SQL_C_TIMESTAMP:
case SQL_C_TYPE_DATE:
case SQL_C_TYPE_TIME:
case SQL_C_TYPE_TIMESTAMP:
case SQL_C_INTERVAL_YEAR:
case SQL_C_INTERVAL_MONTH:
case SQL_C_INTERVAL_DAY:
case SQL_C_INTERVAL_HOUR:
case SQL_C_INTERVAL_MINUTE:
case SQL_C_INTERVAL_SECOND:
case SQL_C_INTERVAL_YEAR_TO_MONTH:
case SQL_C_INTERVAL_DAY_TO_HOUR:
case SQL_C_INTERVAL_DAY_TO_MINUTE:
case SQL_C_INTERVAL_DAY_TO_SECOND:
case SQL_C_INTERVAL_HOUR_TO_MINUTE:
case SQL_C_INTERVAL_HOUR_TO_SECOND:
case SQL_C_INTERVAL_MINUTE_TO_SECOND:
case SQL_C_BINARY:
case SQL_C_BIT:
case SQL_C_SBIGINT:
case SQL_C_UBIGINT:
case SQL_C_TINYINT:
case SQL_C_SLONG:
case SQL_C_SSHORT:
case SQL_C_STINYINT:
case SQL_C_ULONG:
case SQL_C_USHORT:
case SQL_C_UTINYINT:
case SQL_C_GUID:
case SQL_C_WCHAR:
case SQL_ARD_TYPE:
case SQL_C_DOUBLE:

Turn on ODBC tracing and see what is being passed into the call to 
SQLBindCol It may be a type I haven't seen.

--

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

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

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