SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length)

#41

Hi Paulius,

We'll attempt to reproduce your setup in house.

I was wondering why you were using ASA 9.0.1 rather than 9.0.2. Could
you upgrade to 9.0.2, apply the latest EBF, and try this again? If you
get a crash again, could you gzip the resulting core file and e-mail it
to me?

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Hello,

More info:

[odbc.ini]

[dsn_test]
ServerName = server_name
DatabaseName = mydb
UserId = dba
Password = sql
CommLinks = tcpip(host=192.168.1.37;port=2638)
Driver = AdaptiveServer9

[odbcinst.ini]

[AdaptiveServer9]
Description = Aprasas
Driver = /opt/sybase/SYBSsa9/lib/libdbodbc9.so
Setup = /opt/sybase/SYBSsa9/lib/libdbodbc9.so
FileUsage = 1
CPTimeout =
CPReuse =

Paulius Jonikas

#42

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

#43

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

#44

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

#45

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

#46

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

#47

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

#48

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

#49

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

#50

In regards to the issue with unixODBC's isql and SA 10/11, a fix will be
included in 10.0.1.3820 and 11.0.0.1553 (or any later build number).

Note that the issue applies *only* to the isql utility and stems from
isql calling SQLConnect and passing a NULL pointer for the UID/PWD while
specifying their length as SQL_NTS. Our driver would throw an error
(HY090) when this happened. isql started doing this in 2.2.11.

Applications using unixODBC as a driver manager won't be doing this, and
I was able to use unixODBC in the role of a driver manager to load the
SA ODBC driver and connect to an SA database. If you're still having
difficulties with this, we'll investigate further.

Thanks,

Ray

paulius (AT) digitalwork (DOT) lt wrote:

Quote:

Thanks for your reply Ray,

I used standard CentOS 4.5 unixODBC package 2.2.11. I have compiled
2.2.14 from souces, but I don`t know if the constant was
SQL_WCHART_CONVERT defined. Where i can check this?

Now I have tried to use Sybase ASA 9.0.1 odbc driver to connect ASA
10.0.1 network server (I have tried connect to ASA 10 with ASA 9 ODBC
driver on Windows - everything worked correctly). But on linux (CentOS
4.5/CentOS 5.2) i had a problem - everything works correctly using
ISQL. I can connect to DB and make some queries. But when I try to use
unixODBC with PHP 5.1.6-20 and httpd-2.2.3-11 on CentOS 5.2 I get an
error into httpd error log - SEGMENTATION FAULT. My PHP script:
$odbc_link = odbc_connect('dsn_test', 'dba', 'sql');

I have set these variables in httpd.conf:

SetEnv ODBCINI=/etc/odbc.ini
SetEnv ODBCSYSINI=/etc

Sybase ASA 9 variables from file /opt/sybase/SYBSsa9/bin/asa_config.sh
are set in file /etc/profile

Paulius

On 8 Gruo, 22:28, Ray Ruvinskiy <first.l... (AT) sybase (DOT) com> wrote:
Hi Paulius,

Did you compile unixODBC yourself? Do you know if SQL_WCHART_CONVERT was
defined in your build?

Ray

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length)

sybase.public.sqlanywhere.linux sybase.public.sqlanywhere.linux

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-10-2008 , 07:33 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM

Re: SQL anywhere 10 ODBC problem ([S1090][unixODBC][Sybase][ODBCDriver]Invalid string or buffer length) - 12-22-2008 , 07:39 AM