[freetds] FreeBSD (unixODBC) to QNX Sybase
James K. Lowden
jklowden at freetds.org
Thu Jun 15 06:03:57 EDT 2006
Kamil Parkanyi wrote:
> >http://lists.ibiblio.org/pipermail/freetds/2006q2/020045.html
> >http://www.ianywhere.com/developer/technotes/sqlany5_isql.html
...
> >If you have a gadget apparently called "SQL Anywhere Open Server", it
> >seems you can use that as a gateway between the 5.0.5 server and
> >TDS-based clients.
>
> My aim is not to add between Unix<->Qnx something like MS Win as a
> bridge. It seems this old Sybase version can talk only with Win partner
> :-(
Well, you're using very old technology. Can you not use a more recent
version of ASA, or even another RDBMS? (If I were to write a TDS gateway
(such as you propose below) it would be for Postgres.)
> Do you think that this idea could work? :
>
> FreeTDS (tcp) <-> QNX my daemon (tcp) -conversion between tcp and udp
> (localhost) side(udp) <-> Sybase server(udp)
Yes. Your daemon would be a gateway. It would play the role of "SQL
Anywhere Open Server".
You might want to begin by looking in the src/server directory. That
server might be a good starting point for you.
It is not a project for the faint of heart, however. Although a good bit
of TDS 4.2 is implemented in our server, connecting it to your UDP backend
would be a challenge. Let us know how it goes.
Regards,
--jkl
More information about the FreeTDS
mailing list