ODBC to XML tool

This project builds a tool that connects to a database using ODBC, and gets a list of the tables in the connected database. For every table, it will extract all of the data in the table, and write it into an XML file. Each table will be stored in a separate file, which will have the name of the table, and extension .xls.

The command-line tool, called Dump2XML, takes 2 parameters: the connection string, and the directory where to write the XML files, like so:

Dump2XML "DSN=myDSN;Uid=me;Pwd=me;" C:Export

All datetime fields must be written in proper XML format (i.e. in 2006-12-31T00:00:00 or 2006-12-31T00:00:00+0100 notation). Characters that are not allowed in XML format must be converted to their HTML equivalent (for instance, "<" becomes "<"), to ensure that the resulting XML is easily parsed by other software. Each file will be a well structured XML document, with a root element.

The tool will also write a file [url removed, login to view], which will contain a list of all the columns of all the tables the result of the first step of getting the list of tables).

The tool will further write a file [url removed, login to view], which writes a log that keeps a record of when the extract of a table was started, and when it was completed. If errors occured, the log will reflect those as well. Sample files of [url removed, login to view] and [url removed, login to view] can be provided.

The tool will work with older ODBC connectors, and therefor use of .NET is not allowed. The code must be written in C++, and use Win32 calls.

For your training and instruction, you can find excellent, well structured and well working C++ code in the application QTODBC ([url removed, login to view]), for which the source code can be found at [url removed, login to view] Please note that the classes MAY NOT be copied into the source code provided, because this would be a copyright violation. You are required to write your own code, but having working sample code may help you to understand the issues and their solutions better.

The developer for this project will work autonomously. Project oversight will consist only of testing the result against a number of ODBC connections, and inspecting whether copyrights were violated in the code.

Correction: command line should have been:

Dump2XML "DSN=myDSN;Uid=me;Pwd=me;" C:Export

Taidot: C-ohjelmointi, tietojenkäsittely, Windows Desktop

Näytä lisää: xml developer tools, work at home software developer, where to find xml files, where to find software testing, where can i find format, string find c, software testing training, software testing tool, please help me write an application, only ny, gets source code, find net software developer, find net developer, find a windows application developer, att com, qtodbc review, xml &, root solutions, work at home net developer, work at home directory

Tietoa työnantajasta:
( 7 arvostelua ) Brugge, Belgium

Projektin tunnus: #124053

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


we can do it

$300 USD 10 päivässä
(11 arvostelua)

We are well experienced in C++ with ODBC and XML,Please let's do this right row.

$250 USD 5 päivässä
(3 arvostelua)

please check PM

$300 USD 10 päivässä
(1 arvostelu)

I can finish it on time.

$300 USD 5 päivässä
(0 arvostelua)

I am a well experienced VC++, MFC programmer worked in CMM5, CMMI5 standardized software company and led indvidual modules. I am much confident about finishing this project with 99.99% of accuracy. Please let me start Lisää

$300 USD 7 päivässä
(0 arvostelua)

I can do it for you.

$200 USD 10 päivässä
(0 arvostelua)