Skip to Content.
Sympa Menu

freetds - Re: [freetds] Connecting to Sybase ASA - Embedded Database

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Connecting to Sybase ASA - Embedded Database
  • Date: Fri, 7 Dec 2007 14:12:05 -0500

Sharan Rao wrote:
>
> http://tinyurl.com/25xwc2
>
> I was wondering how to achieve this using dblib, as it provides no
> option for setting the "DBF" param as specified in the link. Is it
> possible by adding some entry into the freetds.conf file ?

It is either possible now or possible never. (!)

"An embedded database, designed for use by a single application, runs
on
the same computer as the application...."

Is there an actual server running, listening on a a TCP port?

This sounds like it might be more like SQLite, where the database engine
is a shared object, linked into the application's process space, accessed
by function calls.

"When an application uses an embedded database, the personal server is
generally not running when the application connects. In this case, you can
start the database using the connection string, and by specifying the
database file in the DatabaseFile (DBF) parameter of the connection
string."

As noted in the User Guide, for ASA the freetds.conf [servername] string
has to match the database name. In the above example, it would have to be
called [demo].

If there's a real honest-to-goodness server running, something like this
should do:

[demo]
host = localhost
port = # you tell me
tds version = 5.0

and TDSDUMP should show you connecting, or why not.

If the log shows the connection is refused, there's no process listening
to that port. If the connection is created and you get an error about the
database not existing, then maybe some twiddling with freetds.conf will
help.

If you use use Sybase's tools to connect to the server, and use tcpdump(8)
to capture the login packet, it might be possible to modify FreeTDS to use
the DBF notation. But the short way home is to have the server declare
the database such that the client need not know its location on the disk.

HTH.

--jkl






Archive powered by MHonArc 2.6.24.

Top of Page