I have a large relational C-Tree Database (which is accessable via C-tree ODBC drivers) and located on a Win NT 4 Box. I need to extract some inofrmation (On demand only) from this large C-Tree database and use it to update existing data and add new records to an MySQL database which is located on a RedHat7.3 Box.

Please Help!

    hmm... you never told that either you want to use webservers or want to use direct netword connections at tcp/ip or other level... anyway... if I had this problem, I would have...

    • installed PHP enabled web servers on NT and linux machines... when data was required from NT, call the respective PHP script which should get it using PHP's ODBC connectivity. You can connect to ODBC source using PHP easily. Need an example? Ask me... I have got some good stuff... and about data transfering... hmm... I would have used XML.

    • Second is... I should have written little network based application server (in java) which on demand can connect to ODBC and get data and send it to client... easy thing... XML again here 🙂

    Problem? Ask me... I really liked the problem 🙂

    Good day
    fadee

    Originally posted by Tracer
    I have a large relational C-Tree Database (which is accessable via C-tree ODBC drivers) and located on a Win NT 4 Box. I need to extract some inofrmation (On demand only) from this large C-Tree database and use it to update existing data and add new records to an MySQL database which is located on a RedHat7.3 Box.

    Please Help!

      I can now query the C-Tree database and have the results returned via ODBC.....(Forgive me I have nerver worked with the PHP ODBC functions)...

      I can display results with the odbc_fetch_row or odbc_fetch_all functions, but how would I place the ODBC results into an array (with MYSQL you can mysql_fetch_array) so I can pass ODBC data into the mysql database?

      More specifically, if I query a client database via odbc and return all the "SMITHS". How is the user to select the correct "SMITH", then have some (not all) of the SMITH records id (which can be easily identified via a primary key) passed through to another php file?

      I think I may have gone brain dead today....

      FYI...Faircom is preparing to release linux compat API's and ODBC drivers within the next two months.

      Please Help.

        Write a Reply...