ODBC in 1.4.x, any chance it's broken?

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

ODBC in 1.4.x, any chance it's broken?

Alex Massover

I’m trying to setup LCR via ODBC with MSSQL. It’s working for me with 1.3.2, but not with 1.4.4.

 

I get in syslog:

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_get_columns: no columns returned from the query

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_convert_result: getting column names failed

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_store_result: failed to convert result

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_do_query: error while storing result

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_table_version: error in db_query

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_check_table_version: querying version for table gw

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:lcr:mod_init: error during table version check.

 

In ODBC trace:

[ODBC][19160][SQLDriverConnect.c][1487]

                Exit:[SQL_SUCCESS]

                        Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length = 43 (SQL_NTS)]]

[ODBC][19160][SQLAllocHandle.c][510]

                Entry:

                        Handle Type = 3

                        Input Handle = 0xd7e7308

[ODBC][19160][SQLAllocHandle.c][872]

                Exit:[SQL_SUCCESS]

                        Output Handle = 0xd7dfc68

[ODBC][19160][SQLExecDirect.c][233]

                Entry:

                        Statement = 0xd7dfc68

                        SQL = [][length = 55]               ß Should be a query here?

[ODBC][19160][SQLExecDirect.c][496]

                Exit:[SQL_SUCCESS]

[ODBC][19160][SQLNumResultCols.c][149]

                Entry:

                        Statement = 0xd7dfc68

                        Column Count = 0xbfcf6d6a

[ODBC][19160][SQLNumResultCols.c][234]

                Exit:[SQL_SUCCESS]

                        Count = 0xbfcf6d6a -> 0

[ODBC][19160][SQLFreeHandle.c][203]

                Entry:

                        Handle Type = 1

                        Input Handle = 0xd4c2400

[ODBC][19160][SQLFreeHandle.c][217]Error: HY010

 

Here’s ODBC trace from working 1.3.2:

 

[ODBC][3376][SQLDriverConnect.c][1487]

                Exit:[SQL_SUCCESS]

                        Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length = 43 (SQL_NTS)]]

[ODBC][3376][SQLAllocHandle.c][510]

                Entry:

                        Handle Type = 3

                        Input Handle = 0xd1d20c0

[ODBC][3376][SQLAllocHandle.c][872]

                Exit:[SQL_SUCCESS]

                        Output Handle = 0xd1d5ec8

[ODBC][3376][SQLExecDirect.c][233]

                Entry:

                        Statement = 0xd1d5ec8

                        SQL = [select table_version from version where table_name='gw'][length = 55 (SQL_NTS)]

 

 

isql also works:

 

SQL> select table_version from version where table_name='gw';

+--------------+

| table_version|

+--------------+

| 7            |

+--------------+

 

Any chance that ODBC is broken in 1.4.x?

 

 

--

Best Regards,

Alex Massover



This mail was sent via Mail-SeCure System.


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: ODBC in 1.4.x, any chance it's broken?

Alex Massover

Indeed db_unixodbc is broken in 1.4.x, I uploaded a patch.

 

https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2691928&group_id=232389

 

 

--

Best Regards,

Alex Massover

VoIP R&D TL

Jajah Inc.


From: [hidden email] [mailto:[hidden email]] On Behalf Of Alex Massover
Sent: Wednesday, March 18, 2009 2:54 PM
To: [hidden email]
Subject: [OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?

 

I’m trying to setup LCR via ODBC with MSSQL. It’s working for me with 1.3.2, but not with 1.4.4.

 

I get in syslog:

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_get_columns: no columns returned from the query

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_convert_result: getting column names failed

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:db_unixodbc:db_unixodbc_store_result: failed to convert result

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_do_query: error while storing result

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_table_version: error in db_query

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:core:db_check_table_version: querying version for table gw

Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]: ERROR:lcr:mod_init: error during table version check.

 

In ODBC trace:

[ODBC][19160][SQLDriverConnect.c][1487]

                Exit:[SQL_SUCCESS]

                        Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length = 43 (SQL_NTS)]]

[ODBC][19160][SQLAllocHandle.c][510]

                Entry:

                        Handle Type = 3

                        Input Handle = 0xd7e7308

[ODBC][19160][SQLAllocHandle.c][872]

                Exit:[SQL_SUCCESS]

                        Output Handle = 0xd7dfc68

[ODBC][19160][SQLExecDirect.c][233]

                Entry:

                        Statement = 0xd7dfc68

                        SQL = [][length = 55]               ß Should be a query here?

[ODBC][19160][SQLExecDirect.c][496]

                Exit:[SQL_SUCCESS]

[ODBC][19160][SQLNumResultCols.c][149]

                Entry:

                        Statement = 0xd7dfc68

                        Column Count = 0xbfcf6d6a

[ODBC][19160][SQLNumResultCols.c][234]

                Exit:[SQL_SUCCESS]

                        Count = 0xbfcf6d6a -> 0

[ODBC][19160][SQLFreeHandle.c][203]

                Entry:

                        Handle Type = 1

                        Input Handle = 0xd4c2400

[ODBC][19160][SQLFreeHandle.c][217]Error: HY010

 

Here’s ODBC trace from working 1.3.2:

 

[ODBC][3376][SQLDriverConnect.c][1487]

                Exit:[SQL_SUCCESS]

                        Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length = 43 (SQL_NTS)]]

[ODBC][3376][SQLAllocHandle.c][510]

                Entry:

                        Handle Type = 3

                        Input Handle = 0xd1d20c0

[ODBC][3376][SQLAllocHandle.c][872]

                Exit:[SQL_SUCCESS]

                        Output Handle = 0xd1d5ec8

[ODBC][3376][SQLExecDirect.c][233]

                Entry:

                        Statement = 0xd1d5ec8

                        SQL = [select table_version from version where table_name='gw'][length = 55 (SQL_NTS)]

 

 

isql also works:

 

SQL> select table_version from version where table_name='gw';

+--------------+

| table_version|

+--------------+

| 7            |

+--------------+

 

Any chance that ODBC is broken in 1.4.x?

 

 

--

Best Regards,

Alex Massover



This mail was sent via Mail-SeCure System.



This mail was received via Mail-SeCure System.



This mail was sent via Mail-SeCure System.


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: ODBC in 1.4.x, any chance it's broken?

Bogdan-Andrei Iancu
Hi Alex,

Thanks - already applied the patch.

So we still have to sort out the datatype stuff (with char for priority
in lcr table).

Regards,
Bogdan

Alex Massover wrote:

>
> Indeed db_unixodbc is broken in 1.4.x, I uploaded a patch.
>
> https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2691928&group_id=232389 
> <https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2691928&group_id=232389>
>
> --
>
> Best Regards,
>
> Alex Massover
>
> VoIP R&D TL
>
> Jajah Inc.
>
> ------------------------------------------------------------------------
>
> *From:* [hidden email]
> [mailto:[hidden email]] *On Behalf Of *Alex Massover
> *Sent:* Wednesday, March 18, 2009 2:54 PM
> *To:* [hidden email]
> *Subject:* [OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?
>
> I’m trying to setup LCR via ODBC with MSSQL. It’s working for me with
> 1.3.2, but not with 1.4.4.
>
> I get in syslog:
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:db_unixodbc:db_unixodbc_get_columns: no columns returned from
> the query
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:db_unixodbc:db_unixodbc_convert_result: getting column names failed
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:db_unixodbc:db_unixodbc_store_result: failed to convert result
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:core:db_do_query: error while storing result
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:core:db_table_version: error in db_query
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:core:db_check_table_version: querying version for table gw
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:lcr:mod_init: error during table version check.
>
> In ODBC trace:
>
> [ODBC][19160][SQLDriverConnect.c][1487]
>
> Exit:[SQL_SUCCESS]
>
> Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length =
> 43 (SQL_NTS)]]
>
> [ODBC][19160][SQLAllocHandle.c][510]
>
> Entry:
>
> Handle Type = 3
>
> Input Handle = 0xd7e7308
>
> [ODBC][19160][SQLAllocHandle.c][872]
>
> Exit:[SQL_SUCCESS]
>
> Output Handle = 0xd7dfc68
>
> [ODBC][19160][SQLExecDirect.c][233]
>
> Entry:
>
> Statement = 0xd7dfc68
>
> SQL = [][length = 55] ß Should be a query here?
>
> [ODBC][19160][SQLExecDirect.c][496]
>
> Exit:[SQL_SUCCESS]
>
> [ODBC][19160][SQLNumResultCols.c][149]
>
> Entry:
>
> Statement = 0xd7dfc68
>
> Column Count = 0xbfcf6d6a
>
> [ODBC][19160][SQLNumResultCols.c][234]
>
> Exit:[SQL_SUCCESS]
>
> Count = 0xbfcf6d6a -> 0
>
> [ODBC][19160][SQLFreeHandle.c][203]
>
> Entry:
>
> Handle Type = 1
>
> Input Handle = 0xd4c2400
>
> [ODBC][19160][SQLFreeHandle.c][217]Error: HY010
>
> Here’s ODBC trace from working 1.3.2:
>
> [ODBC][3376][SQLDriverConnect.c][1487]
>
> Exit:[SQL_SUCCESS]
>
> Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length =
> 43 (SQL_NTS)]]
>
> [ODBC][3376][SQLAllocHandle.c][510]
>
> Entry:
>
> Handle Type = 3
>
> Input Handle = 0xd1d20c0
>
> [ODBC][3376][SQLAllocHandle.c][872]
>
> Exit:[SQL_SUCCESS]
>
> Output Handle = 0xd1d5ec8
>
> [ODBC][3376][SQLExecDirect.c][233]
>
> Entry:
>
> Statement = 0xd1d5ec8
>
> SQL = [select table_version from version where table_name='gw'][length
> = 55 (SQL_NTS)]
>
> isql also works:
>
> SQL> select table_version from version where table_name='gw';
>
> +--------------+
>
> | table_version|
>
> +--------------+
>
> | 7 |
>
> +--------------+
>
> Any chance that ODBC is broken in 1.4.x?
>
> --
>
> Best Regards,
>
> Alex Massover
>
>
>
> This mail was sent via Mail-SeCure System.
>
>
>
> This mail was received via Mail-SeCure System.
>
>
>
> This mail was sent via Mail-SeCure System.
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: ODBC in 1.4.x, any chance it's broken?

Alex Massover
Hi!

Is it on purpose char? In every DB creation script it's some type of int. The data is numeric. Probably in the module code the variable is also int.
I just don't see a reason why is it char in the doc. Is there such thing like 'unsigned char'? I'm familiar with 'unsigned int'.

I'm not DBA, but 'char' looks very strange to me and makes troubles at least with MSSQL and ODBC.

--
Best Regards,
Alex Massover

-----Original Message-----
From: Bogdan-Andrei Iancu [mailto:[hidden email]]
Sent: Wednesday, March 18, 2009 5:22 PM
To: Alex Massover
Cc: [hidden email]
Subject: Re: [OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?

Hi Alex,

Thanks - already applied the patch.

So we still have to sort out the datatype stuff (with char for priority
in lcr table).

Regards,
Bogdan

Alex Massover wrote:

>
> Indeed db_unixodbc is broken in 1.4.x, I uploaded a patch.
>
> https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2691928&group_id=232389
> <https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2691928&group_id=232389>
>
> --
>
> Best Regards,
>
> Alex Massover
>
> VoIP R&D TL
>
> Jajah Inc.
>
> ------------------------------------------------------------------------
>
> *From:* [hidden email]
> [mailto:[hidden email]] *On Behalf Of *Alex Massover
> *Sent:* Wednesday, March 18, 2009 2:54 PM
> *To:* [hidden email]
> *Subject:* [OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?
>
> I'm trying to setup LCR via ODBC with MSSQL. It's working for me with
> 1.3.2, but not with 1.4.4.
>
> I get in syslog:
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:db_unixodbc:db_unixodbc_get_columns: no columns returned from
> the query
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:db_unixodbc:db_unixodbc_convert_result: getting column names failed
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:db_unixodbc:db_unixodbc_store_result: failed to convert result
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:core:db_do_query: error while storing result
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:core:db_table_version: error in db_query
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:core:db_check_table_version: querying version for table gw
>
> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
> ERROR:lcr:mod_init: error during table version check.
>
> In ODBC trace:
>
> [ODBC][19160][SQLDriverConnect.c][1487]
>
> Exit:[SQL_SUCCESS]
>
> Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length =
> 43 (SQL_NTS)]]
>
> [ODBC][19160][SQLAllocHandle.c][510]
>
> Entry:
>
> Handle Type = 3
>
> Input Handle = 0xd7e7308
>
> [ODBC][19160][SQLAllocHandle.c][872]
>
> Exit:[SQL_SUCCESS]
>
> Output Handle = 0xd7dfc68
>
> [ODBC][19160][SQLExecDirect.c][233]
>
> Entry:
>
> Statement = 0xd7dfc68
>
> SQL = [][length = 55] ß Should be a query here?
>
> [ODBC][19160][SQLExecDirect.c][496]
>
> Exit:[SQL_SUCCESS]
>
> [ODBC][19160][SQLNumResultCols.c][149]
>
> Entry:
>
> Statement = 0xd7dfc68
>
> Column Count = 0xbfcf6d6a
>
> [ODBC][19160][SQLNumResultCols.c][234]
>
> Exit:[SQL_SUCCESS]
>
> Count = 0xbfcf6d6a -> 0
>
> [ODBC][19160][SQLFreeHandle.c][203]
>
> Entry:
>
> Handle Type = 1
>
> Input Handle = 0xd4c2400
>
> [ODBC][19160][SQLFreeHandle.c][217]Error: HY010
>
> Here's ODBC trace from working 1.3.2:
>
> [ODBC][3376][SQLDriverConnect.c][1487]
>
> Exit:[SQL_SUCCESS]
>
> Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length =
> 43 (SQL_NTS)]]
>
> [ODBC][3376][SQLAllocHandle.c][510]
>
> Entry:
>
> Handle Type = 3
>
> Input Handle = 0xd1d20c0
>
> [ODBC][3376][SQLAllocHandle.c][872]
>
> Exit:[SQL_SUCCESS]
>
> Output Handle = 0xd1d5ec8
>
> [ODBC][3376][SQLExecDirect.c][233]
>
> Entry:
>
> Statement = 0xd1d5ec8
>
> SQL = [select table_version from version where table_name='gw'][length
> = 55 (SQL_NTS)]
>
> isql also works:
>
> SQL> select table_version from version where table_name='gw';
>
> +--------------+
>
> | table_version|
>
> +--------------+
>
> | 7 |
>
> +--------------+
>
> Any chance that ODBC is broken in 1.4.x?
>
> --
>
> Best Regards,
>
> Alex Massover
>
>
>
> This mail was sent via Mail-SeCure System.
>
>
>
> This mail was received via Mail-SeCure System.
>
>
>
> This mail was sent via Mail-SeCure System.
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>




This mail was received via Mail-SeCure System.





This mail was sent via Mail-SeCure System.



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: ODBC in 1.4.x, any chance it's broken?

Bogdan-Andrei Iancu
Hi Alex,

I agree with what you are saying - as we are playing some multiple
database type, we should try to make sure that it fits to all of them. I
will change the char to int.

Regards,
Bogdan

Alex Massover wrote:

> Hi!
>
> Is it on purpose char? In every DB creation script it's some type of int. The data is numeric. Probably in the module code the variable is also int.
> I just don't see a reason why is it char in the doc. Is there such thing like 'unsigned char'? I'm familiar with 'unsigned int'.
>
> I'm not DBA, but 'char' looks very strange to me and makes troubles at least with MSSQL and ODBC.
>
> --
> Best Regards,
> Alex Massover
>
> -----Original Message-----
> From: Bogdan-Andrei Iancu [mailto:[hidden email]]
> Sent: Wednesday, March 18, 2009 5:22 PM
> To: Alex Massover
> Cc: [hidden email]
> Subject: Re: [OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?
>
> Hi Alex,
>
> Thanks - already applied the patch.
>
> So we still have to sort out the datatype stuff (with char for priority
> in lcr table).
>
> Regards,
> Bogdan
>
> Alex Massover wrote:
>  
>> Indeed db_unixodbc is broken in 1.4.x, I uploaded a patch.
>>
>> https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2691928&group_id=232389
>> <https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2691928&group_id=232389>
>>
>> --
>>
>> Best Regards,
>>
>> Alex Massover
>>
>> VoIP R&D TL
>>
>> Jajah Inc.
>>
>> ------------------------------------------------------------------------
>>
>> *From:* [hidden email]
>> [mailto:[hidden email]] *On Behalf Of *Alex Massover
>> *Sent:* Wednesday, March 18, 2009 2:54 PM
>> *To:* [hidden email]
>> *Subject:* [OpenSIPS-Users] ODBC in 1.4.x, any chance it's broken?
>>
>> I'm trying to setup LCR via ODBC with MSSQL. It's working for me with
>> 1.3.2, but not with 1.4.4.
>>
>> I get in syslog:
>>
>> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
>> ERROR:db_unixodbc:db_unixodbc_get_columns: no columns returned from
>> the query
>>
>> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
>> ERROR:db_unixodbc:db_unixodbc_convert_result: getting column names failed
>>
>> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
>> ERROR:db_unixodbc:db_unixodbc_store_result: failed to convert result
>>
>> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
>> ERROR:core:db_do_query: error while storing result
>>
>> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
>> ERROR:core:db_table_version: error in db_query
>>
>> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
>> ERROR:core:db_check_table_version: querying version for table gw
>>
>> Mar 18 12:35:56 ser-gameon-stg /usr/sbin/opensips[19160]:
>> ERROR:lcr:mod_init: error during table version check.
>>
>> In ODBC trace:
>>
>> [ODBC][19160][SQLDriverConnect.c][1487]
>>
>> Exit:[SQL_SUCCESS]
>>
>> Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length =
>> 43 (SQL_NTS)]]
>>
>> [ODBC][19160][SQLAllocHandle.c][510]
>>
>> Entry:
>>
>> Handle Type = 3
>>
>> Input Handle = 0xd7e7308
>>
>> [ODBC][19160][SQLAllocHandle.c][872]
>>
>> Exit:[SQL_SUCCESS]
>>
>> Output Handle = 0xd7dfc68
>>
>> [ODBC][19160][SQLExecDirect.c][233]
>>
>> Entry:
>>
>> Statement = 0xd7dfc68
>>
>> SQL = [][length = 55] ß Should be a query here?
>>
>> [ODBC][19160][SQLExecDirect.c][496]
>>
>> Exit:[SQL_SUCCESS]
>>
>> [ODBC][19160][SQLNumResultCols.c][149]
>>
>> Entry:
>>
>> Statement = 0xd7dfc68
>>
>> Column Count = 0xbfcf6d6a
>>
>> [ODBC][19160][SQLNumResultCols.c][234]
>>
>> Exit:[SQL_SUCCESS]
>>
>> Count = 0xbfcf6d6a -> 0
>>
>> [ODBC][19160][SQLFreeHandle.c][203]
>>
>> Entry:
>>
>> Handle Type = 1
>>
>> Input Handle = 0xd4c2400
>>
>> [ODBC][19160][SQLFreeHandle.c][217]Error: HY010
>>
>> Here's ODBC trace from working 1.3.2:
>>
>> [ODBC][3376][SQLDriverConnect.c][1487]
>>
>> Exit:[SQL_SUCCESS]
>>
>> Connection Out [[DSN=cdr_history;UID=lcr_read;PWD=*********;][length =
>> 43 (SQL_NTS)]]
>>
>> [ODBC][3376][SQLAllocHandle.c][510]
>>
>> Entry:
>>
>> Handle Type = 3
>>
>> Input Handle = 0xd1d20c0
>>
>> [ODBC][3376][SQLAllocHandle.c][872]
>>
>> Exit:[SQL_SUCCESS]
>>
>> Output Handle = 0xd1d5ec8
>>
>> [ODBC][3376][SQLExecDirect.c][233]
>>
>> Entry:
>>
>> Statement = 0xd1d5ec8
>>
>> SQL = [select table_version from version where table_name='gw'][length
>> = 55 (SQL_NTS)]
>>
>> isql also works:
>>
>> SQL> select table_version from version where table_name='gw';
>>
>> +--------------+
>>
>> | table_version|
>>
>> +--------------+
>>
>> | 7 |
>>
>> +--------------+
>>
>> Any chance that ODBC is broken in 1.4.x?
>>
>> --
>>
>> Best Regards,
>>
>> Alex Massover
>>
>>
>>
>> This mail was sent via Mail-SeCure System.
>>
>>
>>
>> This mail was received via Mail-SeCure System.
>>
>>
>>
>> This mail was sent via Mail-SeCure System.
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>    
>
>
>
>
> This mail was received via Mail-SeCure System.
>
>
>
>
>
> This mail was sent via Mail-SeCure System.
>
>
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users