Skip to Content.
Sympa Menu

freetds - Re: [freetds] Config parameter to start DB on Sybase ASA personal server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Config parameter to start DB on Sybase ASA personal server
  • Date: Thu, 28 Aug 2014 11:44:09 +0200

2014-08-28 9:28 GMT+02:00 Falk Morgenroth <frot AT gmx.de>:

> 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




Archive powered by MHonArc 2.6.24.

Top of Page