Sql database connectivity

[Fuzzy Me]

Hi !

 How can i access a Sql database using LV?

Condition-

1) There are 7 PC and 7 same(Identical) Sql data base.

2) These 7 PCs are in LAN

3) There is one more PC 8th from which i hav to access Sql database of all 7 PCs

4) These all 8 PC are in LAN.

5) I hav only IP address of these all PCs

Is there any facility to read file just by knowing is path and IP address of Computer ?

[Fox_Mccloud]

Hello

There is a SQL-toolkit called LABsql that is free.

You can find it here: http://jeffreytravis.com/lost/labsql.html

And your conditions seems to be ok. All your pc:s are on the same network and you have the ip:s.

The last question is kind of blurry. Could you explain what you mean by: "Is there any facility to read file just by knowing is path and IP address of Computer ?" again please.

Hope the link gets you set up.

Cheers

//Beckman

[Fuzzy Me]

Dear  Sir,

I known there is  Labview tool kit for database . I used it . I can access database using that tool kit.

But u doesn't concentrat on the point that i hav too access database which has same copy on all 7 Pc.

i.e same Connection information too.

And the last que is like If u given ip address of comp (Remote) and u known the file path i.e.d:\LV\Data\test.txt on that

then how will u read that file from another comp,

Thanking u sir,

[Fox_Mccloud]

Hello again.

Good that you have tried the LabSql and got it working.

Now you only have to use it on the seven different IP-numbers you have. Since the database looks the same on all computers it should be a easy task. I doubt they all have the same IP. If they have I guess they are behind a router. And then you just have to do some funky portforwarding to get it working. 🙂

In sudo code:

connect database1
extract data from database1
disconnect
connect database2
extract data from database2
disconnect
...
...
connect database7
extract data from database7
disconnect


For the last question you should probably use a ftp-server on the computer which has the file you want to transfer. And then use a ftp-client to transfer the file.
If you use windows on both the computers you could probably share the directory where the file is and then "add network device" in explorer on your client computer. Then you will get a networkdrive which is connected to the directory with the file. Then you can use the networkdrive like g:\LV\Data\test.txt on your client computer. Works with labview straight off.

Cheers

//Beckman

Message Edited by Fox_Mccloud on 01-22-2007 09:28 AM

[waldemar.hersacher]

If you want to access a file on another computer you need to create a share on the remote machine. If the machine has the name MachineA and the share is LV_Data for the folder d:\LV\Data, then you can use the Open/Create/Replace File function of LV using the file name \\MachineA\LV_Data\test.txt to open the file and read it.