Hi!

On Thu, 2004-03-25 at 19:15, msthom01 wrote:
> My name is Matthew Thomas I am currently a student at Syracuse University 
> working on a senior design project that utilizes your database at the back 
> end. I have data streaming from an RS232 port(COM port on a computer) and I 
> want that information to be able to directly written onto the database. We are 
> looking for c/java/assembly sample code that connects to a COM port and takes 
> that data and stores in onto mysql database. We are using the database on a 
> windows operation system. How do you create a database using the APIs provided 
> on your website? Thanks for the help.

There is no simple-direct way. The MySQL c api will let you do
operations on the db server (inser, select, upgrade, delete) and get
info about the db server (show column in, show tables, etc). It is not
designed to do such things you need. 

On the other hand, you can perfectly write a set of functions to connect
your i/o streams coming from the rs port and input it to the server
using the mysql c api, but _YOU_ have to write the logic. We are
building something similar but we are using java for such purpose and
linux is our os; weird isn't it? =) 

We are using the rxtx.org java classes to conect to the serial port,
then a set of simple clases to create strings out of the i/o streams
coming from the port, then jdbc to insert or update data in our beloved
mysql server.

Best Regards
-- 

 |...........................................................|
 |____  _____ ____   _    |Victor Medina M                   |
 |\ \ \| ____|  _ \ / \   |Linux - Java - MySQL              |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]                  |
 |/_/_/|_____|_| /_/   \_\|Tel: +58-241-8507325 - ext. 325   |
 |                        |Cel: +58-412-8859934              |
 |                        |geek by nature - linux by choice  |
 |...........................................................|


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to