how to run SQL in an EXE

[Avni]

I have a VI in which i have used SQL.If I want to make an EXE of this VI and run on a different PC where there is no SQL toolkit, what are the steps to be follwed during the making of the EXE.

WHat I have done id buld the  EXE with the Database and and then installed the exe in the other PC. Also i have cinfigured the database in ODBC in the other PC. but the database is not getting activated.

Can you tell me the steps to do this.

I am using LabVIEW 7.1 and SQL Toolkit. and developed my database in ACCESS.

Please help me as soon as possible

With regards

Avni

[Aitortxo]

Hi, Avni:

Well, my answer will not be complete, I'm sorry.

When you build an EXE you are linking all VIs you are using in a program. You don't have any problems when all VIs are ones you have done entirely.

But when you use VIs from 'Add-On's or modules, for example, Database Connectivity AddOn, then that linking can be explicit so you don't have any problems, or not.

In the case of Database Connectivity AddOn, you need to build the EXE with some configuration. And this is the incomplete step. I'm writing from home, so I don't have LabView installed and I don't know the exact name of the file.

[Aitortxo]

Sorry, I pressed TAB, and then SPACE... so the reply was published.

Ok, I don't know the name, but I can tell you that it is in National Instruments directory
-> VI.LIB
-> ADDONS
-> DATABASE CONNECTIVITY

There is a [...].BLD file.

When building the EXE file, load that BLD, so the needed files will be added to your EXE, and then add your main VI to VI listing.

This should work for you as did for me.

Hope it helps,

Aitortxo.