Connect to a remote sql server with sql toolkit

[stefan.school@hccnet.nl]

Hi, (Sorry if this post isn't in the right directory, I coudn't find a right one)

I'm using Labview 6.1 and SQL connectivity toolit. I'm trying to make a connection between my linux-server (nect to me on the lan) and my other computer. I'm a newbie with labview so can anyone tell what I have to do to make the connection. I can't find the answer in the toolkit manual.
Thnx for your help,
Stefan

[Liz F]

Hello Stefan,

I would recommend searching the example code database to get you started. It sounds like you might need a combination of database connectivity and networking capabilities. On the database side, I found an example application at this site:
http://sine.ni.com/apps/we/niepd_web_display.display_epd4?p_guid=B45EACE3EA5B56A4E034080020E74861&p_node=DZ52093&p_source=External

This example shows the framework behind general database actions with SQL.

You would then need to work with moving the data between the two computers on the network. This could either be a shared drive, or you could send the data via some sort of TCP/IP communication. The examples that ship with LabVIEW about Datasocket are great places to start for this. Just go to Help >> Fi
nd Examples, and type "datasocket" on the "search" tab.

I hope this helps!

Liz Fausak

[stefan.school@hccnet.nl]

Hi Liz, thanks for your help.
The vi you gave is realy easy to use, so thanks for that. Now I only have 1 problem left (I hope...), I have to fill in th DSN Name. I found somewhere that you have to set that in Windows (I'm using XP Pro) in the ODBC, a kind of link to the database. I tryed to set up this stuff, but I it's not working. I get the message (in the ODBC) that I'm not verified to the sql server. I'm sitting next to my server and I'm sure I have all rights to it! (build the server by my own)

My English is not so good so am I right that if I'm using that datasocket that I don't have to use that 'link' in the ODBC?

Thnx,
Stefan

[JMV]

Hi,
I am not an expert but I am working on an application which connects to a DB in SQLServer.

We connect to the DB by creating a Data Link udl file and then use this reference for any task on the DB.

You can find the udl data link creation on the Tools Menu of LabVIEW.

Hope it helps.
Regards.

Juan.