Re:

[Chaz]

Thank you

Chaz Byrne

[Doug C]

Is there anyway that I can use the DataSocket Read/Write functions in LabVIEW 6i to write to and get information from a access 97 database ? If so could you please help me and if there is a location where I can get a sample program of this please say so.Hello Chaz,
What you will have to do is have a VI write to the DataSocket connection, then have the VI that is reading from the DataSocket connetion take in the data and use it in a variable.
I put together an example that does that and writes it to a spread sheet VI. With this you should be able to take it further into Access. Good luck,
Doug

[Chaz]

Is there anyway that I can use the DataSocket Read/Write functions in LabVIEW 6i to write to and get information from a access 97 database ? If so could you please help me and if there is a location where I can get a sample program of this please say so.Doug C thanks for he answer but you lost me... I do not see how your program is comunicating through the data socket ? It doesn't seem to do anything with the data socket ? Any further help would be great, thank you.

[Doug C]

Is there anyway that I can use the DataSocket Read/Write functions in LabVIEW 6i to write to and get information from a access 97 database ? If so could you please help me and if there is a location where I can get a sample program of this please say so.Hello Chaz,
I do not think that there is anyway to do direct Access calls through data socket. So, the work around was to trasfer the data via data socket, then put it into an array then you can work with that array. Since I have not worked with Access I just put it into a spreedsheet, but you could take that array and put it into access. So, in other words, you will have to do your Access calls and datasocket calls seperately. Thanks,

Doug

[Alberto]

Is there anyway that I can use the DataSocket Read/Write functions in LabVIEW 6i to write to and get information from a access 97 database ? If so could you please help me and if there is a location where I can get a sample program of this please say so.Why datasocket?
You can use ActiveX property and invoke methods of Access.
This solution, though not simple, gives you full "access to Access".

[Chaz]

Is there anyway that I can use the DataSocket Read/Write functions in LabVIEW 6i to write to and get information from a access 97 database ? If so could you please help me and if there is a location where I can get a sample program of this please say so.ActiveX ? Is there anyway that you can setup a sample program for me to see the functions and how they are used ? Also do I need anything else SQL... ? I don't really know all that much about MSAccess 97, so any help would be great. I am trying to get around buying the SQL kit for LabView, seeing as the company will not pay the $700 for it. I am also semi-know Oracle 8i, so I know some SQL code but not exactly how I would apply it to ActiveX/MSAccess. Any help would be great, thank you. If you can help it migh be easier if I had your e-mail address for this type of question. Thank you again.

[parimala]

Is there anyway that I can use the DataSocket Read/Write functions in LabVIEW 6i to write to and get information from a access 97 database ? If so could you please help me and if there is a location where I can get a sample program of this please say so.Hi chaz
If u r having database connectivity toolset atleast u can transact with Access.I'm doing updation insertion using that only.
In functions palatte database vis are there.