Discussion Locked

To Capture Data from Serial Port

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

With Visual Basic 6.0 as Front End
Microsoft SQL ver 7.0 as Back End
Operating System Windows NT ver 4.0
I would like to capture data from the machine connected to the serial/parallel port of my PC using the above mentioned softwares.

6 replies

by lo

Hi - Not sure what you mean by "I would like to capture data from the machine connected to the serial/parallel port of my PC using the above mentioned softwares."

Capture (in computer terms), normally "means to get outside an applicaton". A screen capture application, makes a copy of a Windows screen or other item on the monitor, a network sniffer/monitor "captures" data on the network (usually, connects and receives and saves all traffic on the network), a serial port or parallel port capture usually involves a Y cable (or other connection). This works similar to what happens with the network sniffer. Neither send data, the just catch all of the data in either direction and write to some storage device.

I am not sure what data you would see on a serial / parallel port with your configuration. Unless you have printers or modems (or other devices) connected to the port, there would be no data to capture. If you want to connect to the serial/parallel ports to obtain data being created on the front end / backend, you will need to create an application that obtains that data (sits in the middle of an application or is a front end to it). If this is what you are looking to do, you probably should use a netowrk connecton to transfer the data, may not sufficient band width on a serial or parallel port for that volume.

Might add a short architecture of what is where and at what point you want to put in the capture process.

by lo

As an example:

An application FE deals with user and sends data to the BE, at the point just before the BE call, a routine, writes the data that will be sent to the BE to a disk file (or otherwise makes available to another application, network, serial port, etc.).
Somewhere in the same application, at the point where the FE receives the response from the BE a similar routine catches whatever the BE sends to the FE and does similar saving/sending.

With appropriate time stamps and such,this would give a history/log (when sorted on time or if a transaction number were added, etc.)
FE sent to BE at
BE sent to FE at
The two routines 'capture' all data to and from the FE/BE.

You could same/similarif the connection between FE/BE is a network with a network sniffer (or other software/hardware) and a filter to only look at packets from / to the FE PC IP.

Hope I got that right, hate editing in this tiny 40-50 char by 8-10 line windows.

by seagull data services

If you're trying to capture input (barcodes, swipe cards,...) for input into your database, the MSCOMM control may help. Search for "MSCOMM Control" on you MSDN CDs.

This discussion is closed to new replies.