Re: Config parameter to start DB on Sybase ASA personal server

2014-08-28 9:28 GMT+02:00 Falk Morgenroth <[email protected]>:

> DB: Sybase ASA 10 (Adaptive Server Anywhere) on Windows 7
> Client: Debian Wheezy, freetds, php (odbc_connect() )
> ODBC:   unixodbc
>
> I can connect to the database by using unixodbc / freetds driver as long
> it is running. (started by a ERP windows client app) I get all data I need
> with php - everything is working fine.
>
> Unfortunately I can not connect to the database when it was stopped by the
> client app. (on close of the app)
>
> The Sybase personal server (EngineName) is still running and is waiting to
> receive DatabaseName and DatabaseFilePath to start the DB again.
> - Sybase ASA is configured for AUTOSTART.
> - Firewall does not block
> - Tests with a windows machine, ODBC and Sybase driver work - its possible
> to start the DB by using the ODBC only
>
> I figured out that I need to submit following parameter (which are
> available in Windows ODBC confiuration) when connecting:
> EngineName=MyPersonalDBServer     --> Name of the personal server (Sybase
> calls it personal)
> DatabaseName=MyDatabase                --> Name of the database to start
> DatabaseFile=D:\mydatabasefile.db    --> Windows Path where database file
> is located on the hosting machine
>
> Unfortunately I can not find a solution to do this by unixodb / freetds. I
> tried to add above parameter to odbc.ini but freetds.log shows that it does
> not know / use these parameter
>
>
Cfr http://www.freetds.org/userguide/odbcconnattr.htm


>
> odbc.ini
> ----------------
>
> [mydatabase]
> Description    = FreeTDS Driver
> Driver        = FreeTDS
> Servername    = mydatabase
> UID        = user
> PWD        = password
> Port        = 2638
>
>
> freetds.config
> ----------------
> [mydatabase]
>     host = svrname
>     port = 2638
>     tds version = 5.0
>     ASA database = mydatabase
>     connect timeout = 10
>
> --->    I would like to add somehow
> ;EngineName=MyPersonalDBServer
> ;DatabaseFile=D:\mydatabase.db
>
> Do you have any idea / suggestion?
>
>
A network dump from the Windows machine which start the db would be really
helpful. I don't know the protocol Sybase use to communicate file/engine to
the server.


> Thanks for having a look into.
> Falk
>

Regards,
  Frediano