Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6250

Integrate DBTCP client for CONNECT storage engine

    Details

      Description

      There is a tool very very useful that allows for a Linux client to access ODBC data were a client is available only for Windows: DBCTP (http://www.fastflow.it/dbtcp/).

      From its webpage:

      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.
      

      As a suggestion only it would be a major feature for the CONNECT SE to directly connect to DBTCP server pooling data from more heterogeneous systems.

      Best regards,
      António Fernandes

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            serg Sergei Golubchik added a comment -

            Olivier Bertrand, does this say anything to you? Is that a useful feature to have?

            Show
            serg Sergei Golubchik added a comment - Olivier Bertrand , does this say anything to you? Is that a useful feature to have?
            Hide
            bertrandop Olivier Bertrand added a comment -

            This is some of what I found on the web about DBCTP:
            On http://freecode.com/projects/dbtc

            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
            

            On http://www.fastflow.it/dbtcp/

            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)
            

            On https://launchpad.net/ubuntu/breezy/i386/dbtcp/0.1.17-4.2ubuntu1

            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)
            

            Seems pretty old and obsolete, perhaps not supported anymore.

            Show
            bertrandop Olivier Bertrand added a comment - This is some of what I found on the web about DBCTP: On http://freecode.com/projects/dbtc 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 On http://www.fastflow.it/dbtcp/ 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) On https://launchpad.net/ubuntu/breezy/i386/dbtcp/0.1.17-4.2ubuntu1 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) Seems pretty old and obsolete, perhaps not supported anymore.

              People

              • Assignee:
                Unassigned
                Reporter:
                ampf Antonio Fernandes
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: