Remote SQL Server

[Rajmohan]

Hi ,i want to make remote sql database that means i have two PC.one PC have just get the data from sensor, and another PC is used for Database,like  PC(1) send the Data to PC(2) Sql server .i did same pc itself.but i dont have idea to make connect remote ms access sql

pls tell me how to do?

[Yamaeda]

If you're connecting to Access it's only an open file over network, if you're using SQL server it's rather easy if you have access to Database Toolkit. Then you'll need to setup a .udl file with connection information to the server, and use that file in Connect to database. From there you'll have to use your Select and Insert vi's as needed.

/Y