Effective 2014-06-18 Freecode is no longer being updated (content may be stale).

Freecode Logo

Projects / dbtcp

dbtcp

dbtcp is a package of libraries which provides applications on Linux access to ODBC datasources on remote machines running Windows. It allows a Linux application to access data held on a Windows machine (such as MS SQL Server on NT), and includes a command line client, a DBD, and a PHP driver.

Tags  Database

Licenses  GPL

Operating Systems   Windows POSIX Linux

Implementation  C Delphi

Website   --------->  http://www.fastflow.it/dbftp/

Download  --------->  dbtcp-latest.tar  dated 2 oct 2004

    All releases

Recent releases

    0.1.18

     14 Jul 2004 19:49

Release Notes: Some fixes have been applied to the makefile (from the Debian package). A bug in error message handling has been fixed. The PHP client can now be built with phpize.

Recent comments

04 Oct 2002 05:59 jlennon

runs fine - at least on the unix side

DBTCP

What is it ?

DBTCP is a proxy server for ODBC connection.

Allow to make a query from a linux machine to a database in a Windows machine trough ODBC.

Allow to connect all ODBC compliant databases from a Linux server from shell scripts, perl via DBD and PHP.

DBTCP is released under GPL.

Why a proxy for odbc connections ?

The main reason for using dbtcp is the lack of support for a few odbc databases under Linux and the fact that you can use multiple dbtcp clients on a pay-per-odbc-connection database management system.

Where I can get it ?

Source for the client part ( tested only on linux ) and binary windows server. ( Latest version 0.1.18 - 14 Jul 2004 ) dbtcp

We use DBFTP for dumping databases from Windows ( MDB ) to a Linux machine running mysql, also we use the same client library to create dynamic html pages on linux based on data avalaible only on Windows machine.

Can I run dbtcp as a NT service ?

Yes, you can run dbtcp as a service using firedaemon.

Data dumping from Windows to MySQL

To dump data from a remote DSN to mysql you can do something like this:

echo "SELECT * FROM mytable" | dbtcp DSN=mydsn myserver > /export/data.sql

echo "LOAD DATA INFILE '/export/data.sql' INTO TABLE mytable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\''" | mysql mydatabase

Changes

Forum

Downloads  ------------>  Not operational   (grayed)

dbtcp 0.1.17-4.2ubuntu1 (i386 binary) in ubuntu breezy

    Breezy (5.10) i386 dbtcp 0.1.17-4.2ubuntu1

Miscellaneous command-line DBTCP utils

 DBTCP is a proxy server for ODBC connections, which allows you to make

 a connection from a UNIX machine to a Windows ODBC source, among other

 things. You can connect via standard command-line utils (provided in

 this package), a Perl DBD module (in the libdbd-dbftp-perl package), or

 via PHP bindings (in the php4-dbtcp package).

 .

 This package does not provide the binary-only Windows server. The server

 is available from http://www.fastflow.it/dbtcp.

Details

Package version:

    0.1.17-4.2ubuntu1

Source:

    dbtcp 0.1.17-4.2ubuntu1 source package in Ubuntu

Status:

    Obsolete      <============

Component:

    universe

Priority:

    Optional

Downloadable files

i386 build of dbtcp 0.1.17-4.2ubuntu1 in ubuntu breezy RELEASE produced these files:

    dbtcp_0.1.17-4.2ubuntu1_i386.deb (13.9 KiB)

Package relationships

Depends on:

    libc6 (>= 2.3.4-1)

    libncurses5 (>= 5.4-5)

    libreadline4 (>= 4.3-1)