Communicate with Ethernet Device

I have an ethernet device that I need to communicate with in either vba (access 2003) or visual basic 2008 or visual C++ 2008.  I am most familiar with vba, then vb2008, the visual c++ 2008.

I need to open a communication channel with the device, need to send commands to the device, and need to read results from the device.

What are the commands I need to handle this communication?  Is it best to use win api or other?  I really have limited knowledge on socket type programming.  I have only communicated to ethernet devices in character based Unix C using AF_INET structures (about 5 years ago).  I handle serial communications using WIn API.

Any help would be greatly appreciated.  I am a novice on this subject.
compuzak1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, within Access VBA, you would need to use API calls for sure.

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
You might find something here that would help you:

http://www.mvps.org/access/api/index.html

All of this works from inside Access VBA.

mx
0
Gustav BrockCIOCommented:
If you insist on using VBA, you would probably need the WinSock control to get the work done. An example of using this for a syslog sender and receiver is found here:

  http://www.devx.com/vb/Article/42242

You should be able to adopt it for your specific use.

That said (or written), I would use Visual Studio (.Net) for this task if at all possible.

/gustav
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

compuzak1Author Commented:
Cactus, do you have any examples that I can use as a basis in visual studio?  

I will use Visual Studio per your recommendation.  I have a short deadline and need to get up to speed as fast as possible.  What resources would you recommend for getting started in Visual Studio.  I have a lot of programming design/development experience, just none in Visual Studio.
0
Gustav BrockCIOCommented:
Yes, here is a very basic example but even though perhaps close to what you need:

http://www.c-sharpcorner.com/uploadfile/sthangaraju/tcpclientserverst11182005014316am/tcpclientserverst.aspx

However, I've only used the SMTP service (which works great) so I cannot supplement with practical details.

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
compuzak1Author Commented:
That looks like what I need.

Do you have any advice on where to find documentation that will jump start me with Visual Studio?  Need to create program, make an exe, the basic stuff.  I am sure I can figure it out, but if you have a good guide on "getting started with Visual Studio" it might save me some time.
0
Gustav BrockCIOCommented:
There is _much_ stuff for the finding ...

This is the official starter kit:

http://www.microsoft.com/express/Resources/

Also, I enjoyed the free stuff from this source:

http://www.learnvisualstudio.net

/gustav
0
compuzak1Author Commented:
This example was excellent and did everything I needed for my simple communication.  

The training references below are also a big help.

Thanks for saving me a bunch of time.
0
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.