odbc

[jspaarg]

Is it possible to load odbc drivers onto a PXI chassis so that it can access an SQL database over the network?

Thanks

[Kevin_H]

Hi Jspaarg,

Thank you for contacting National Instruments.  Can I ask what operating system you are running on the PXI controller?  If you are running Windows, you should have no problem putting that driver on there.  If you are using another operating system, I will see what I can find for you.

Regards,

Kevin H

[jspaarg]

Thanks for the reply, sorry I didn't get back immediately.

I don't know what OS is running.  The only info that I can find is in a log file on the PXI which reads

####
#Date: Sat, Sep 9, 2006 9:59:42 AM
#OSName: PharLap
#OSVers: 12.0
#AppName: PH_EXEC
#Version: 8.2
#AppKind: AppLib

LVRT.DLL load address: 0x002FC000


I am only familiar with installing odbc on PCs using ControlPanel->AdmistrativeTools->DataSources.

Assuming that this OS supports them, how do I install them?

Is there a document somewhere that explains this?

Thanks for the help.

[Kevin_H]

Hi Jspaarg,

I am not sure if there is an easy way to implement a SQL connection.  I did find a couple of discussion forums with some ideas on how to accomplish this, and it may be worth taking a look at.

Has anyone written directly to a database from LabVIEW Real-time?

SQL capable RT system

Take a look at those, and see if they help you out at all.

Regards,

Kevin H

[jspaarg]

Thanks

Base on those two threads, I make the assumption that SQL access is not possible using PharLap (or any LabView RT).

It seems that what I need to do will be establish some high level network communication protocol between a PC running an app and the PXI.

The PXI can collect data and write to its own memory, the PC needs to access the PXI and retrieve the file and set a semaphore indicating that the data has been read.

Do you know if there already exists some code to perform this?

I will write my own if necessary.

Thanks again.

[Kevin_H]

Hey Jspaarg,

I did some searching, and it looks like I could not come up with any examples of how to do this.  If you do create a working solution, please do post it here so future developers will have access to it!

Good luck!

Regards,

Kevin H