SQL Anywhere Mobile - odbc problem on linux

Author

odbc problem on linux

michael

2005-10-27, 8:21 am

hi,
we are trying to connect a mobilink 8.02 server to ase 15 on redhat es3.

the log ends with
I. 10/17 11:31:00. <Main>: Pass last download timestamp first.
I. 10/17 11:31:00. <Main>: Example scripts will not be automatically
generated for unknown versions.
I. 10/17 11:31:00. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 10/17 11:31:00. <Main>: Stream specifier 1: tcpip
E. 10/17 11:31:10. <Main>: Error: ODBC: [unixODBC][Sybase][ODBC
Driver]Client unable to establish a connection (ODBC State = 08001,
Native error code = 30012)
I. 10/17 11:31:10. <Main>: Synchronization Server finished

odbc.ini:
[ODBC Drivers]
Adaptive Server Enterprise=Installed

[ODBC Data Sources]
ASE=Adaptive Server Enterprise

[ASE]
rem Driver=/var/opt/sybase/asa8/drivers/lib/wqase17.so
Driver=/var/opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
Description= Adaptive Server Enterprise
Database=mv
Server=MVIZ
Port=5000
LogonID=sa
Password=

starting script:
cd /var/opt/sybase/asa8/bin
.. asa_config.sh
cd
ODBCINI=$HOME/.odbc.ini
export ODBCINI
LD_LIBRARY_PATH=$SYB
ASE/$SYBASE_OCS/lib:/usr/ lib:$LD_LIBRARY_PATH

export LD_LIBRARY_PATH
dbmlsrv8 -c dsn=ASE4 -ud -dl -v+ -o dbmlsrv.log

thank's in advance
Michael Landeck

Toni

2005-10-27, 8:21 am

Hi Michael,

I run into the same problem before. Let try to add the asa
driver in the path and see if it works.

/asa9/drivers/lib.

hope that help
Toni

> hi,
> we are trying to connect a mobilink 8.02 server to ase 15
> on redhat es3.
>
> the log ends with
> I. 10/17 11:31:00. <Main>: Pass last download timestamp
> first. I. 10/17 11:31:00. <Main>: Example scripts will not
> be automatically generated for unknown versions.
> I. 10/17 11:31:00. <Main>: Local file for remote
> synchronization logs: 'dbmlsrv.mle'
> I. 10/17 11:31:00. <Main>: Stream specifier 1: tcpip
> E. 10/17 11:31:10. <Main>: Error: ODBC:
> [unixODBC][Sybase][ODBC Driver]Client unable to establish
> a connection (ODBC State = 08001, Native error code =
> 30012) I. 10/17 11:31:10. <Main>: Synchronization Server
> finished
>
> odbc.ini:
> [ODBC Drivers]
> Adaptive Server Enterprise=Installed

>
> [ODBC Data Sources]
> ASE=Adaptive Server Enterprise
>
> [ASE]
> rem Driver=/var/opt/sybase/asa8/drivers/lib/wqase17.so
> Driver=/var/opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
> Description= Adaptive Server Enterprise
> Database=mv
> Server=MVIZ
> Port=5000
> LogonID=sa
> Password=
>
>
> starting script:
> cd /var/opt/sybase/asa8/bin
> . asa_config.sh
> cd
> ODBCINI=$HOME/.odbc.ini
> export ODBCINI
> LD_LIBRARY_PATH=$SYB
ASE/$SYBASE_OCS/lib:/usr/lib:$LD_LIBRA
> RY_PATH export LD_LIBRARY_PATH
> dbmlsrv8 -c dsn=ASE4 -ud -dl -v+ -o dbmlsrv.log
>
>
> thank's in advance
> Michael Landeck
>

michael

2005-10-27, 8:21 am

Hi Toni,
thank's a lot, but that doesn't help
now the server connects and disconnects at once:

I. 10/18 15:05:04. <Main>: Synchronization Server started
I. 10/18 15:05:04. <Main>: Option 1: -c
I. 10/18 15:05:04. <Main>: Option 2: ****************
I. 10/18 15:05:04. <Main>: Option 3: -v+
I. 10/18 15:05:04. <Main>: Verbose logging: show row values
I. 10/18 15:05:04. <Main>: Verbose logging: show script names when invoked
I. 10/18 15:05:04. <Main>: Verbose logging: show script contents when
invoked
I. 10/18 15:05:04. <Main>: Verbose logging: show schema for each table
I. 10/18 15:05:04. <Main>: Verbose logging: show an error when the first
read of a synchronization fails
I. 10/18 15:05:04. <Main>: Verbose logging: show translated SQL for prepared
statements
I. 10/18 15:05:04. <Main>: Verbose logging: show rowcount values
I. 10/18 15:05:04. <Main>: Individual database connections will be closed
after synchronization errors.
I. 10/18 15:05:04. <Main>: BLOB cache size: 524288
I. 10/18 15:05:04. <Main>: Maximum number of BLOB bytes to compare:
4294967295
I. 10/18 15:05:04. <Main>: Maximum number of database connections: 6
I. 10/18 15:05:04. <Main>: Maximum number of deadlock retries: 10
I. 10/18 15:05:04. <Main>: Timeout for inactive database connections: 60
minutes
I. 10/18 15:05:04. <Main>: Maximum delay between retries after deadlock: 30
seconds
I. 10/18 15:05:04. <Main>: Rowset size: 10
I. 10/18 15:05:04. <Main>: Upload cache size: 524288 bytes
I. 10/18 15:05:04. <Main>: Download cache size: 524288 bytes
I. 10/18 15:05:04. <Main>: Number of worker threads: 5
I. 10/18 15:05:04. <Main>: Maximum number of threads uploading concurrently:
5
I. 10/18 15:05:04. <Main>: Unknown users will be rejected (when there is no
authenticate_user script).
I. 10/18 15:05:04. <Main>: Pass last download timestamp first.
I. 10/18 15:05:04. <Main>: Example scripts will not be automatically
generated for unknown versions.
I. 10/18 15:05:04. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 10/18 15:05:04. <Main>: Stream specifier 1: tcpip
I. 10/18 15:05:04. <Main>: ODBC DBMS Name: SQL Server
I. 10/18 15:05:04. <Main>: ODBC DBMS Version: 15.0.0
I. 10/18 15:05:04. <Main>: ODBC DBMS Driver Version: 15.0.0.50
I. 10/18 15:05:04. <Main>: Warning: [10051] Unrecognized ODBC driver
'Adaptive Server Enterprise (ANSI)'. The functionality and quality of ODBC
drivers varies greatly. This driver may lack functionality required for
successful synchronizations. Use at your own risk.
I. 10/18 15:05:04. <Main>: ODBC Version supported by the driver: 3.51
I. 10/18 15:05:04. <Main>: Collation sequence of the consolidated database
is ' '
I. 10/18 15:05:05. <Main>: Warning: [10002] If needed, ODBC cursors will be
used, via the Microsoft ODBC Cursor Library, to simulate SQLSETPOS for
inserts, updates, and deletes
I. 10/18 15:05:05. <Main>: ODBC isolation set to: Read Committed
I. 10/18 15:05:05. <Main>: Connected
I. 10/18 15:05:06. <Main>: Disconnected
I. 10/18 15:05:06. <Main>: Synchronization Server finished

<Toni> schrieb im Newsbeitrag news:4353a686.50db.1681692777@sybase.com...[color=darkred]
> Hi Michael,
>
> I run into the same problem before. Let try to add the asa
> driver in the path and see if it works.
>
> /asa9/drivers/lib.
>
> hope that help
> Toni
>

Greg Fenton

2005-10-27, 8:21 am

michael wrote:
> E. 10/17 11:31:10. <Main>: Error: ODBC: [unixODBC][Sybase][ODBC
> Driver]Client unable to establish a connection (ODBC State = 08001,
> Native error code = 30012)

This might be an issue with unixODBC. Why not use the driver manager
that ships with SQLAnywhere? This is the manager located in
$ASANY8/drivers/lib/libodbc.so.

> [ASE]
> rem Driver=/var/opt/sybase/asa8/drivers/lib/wqase17.so
> Driver=/var/opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so

What is the exact version of the driver that you are using?
Note that the only supported drivers for ASE communication for ASA 8.0.2
are listed at:

http://www.ianywhere.com/developer/...r /> e_Server_1

I suspect you are running into issues because ASE 15 was released within
the past couple of months whereas ASA/ML 8.0.2 were released more than
two years ago (if memory serves...)

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links