Labview connection to SQL compact

[manost]

Dear friends,

I am developing an application using LV touch panel module in order to run in a Windows CE 5.0 controller.

On the same controller I have SQL server compact 3.5 and I was planning to use it in order to store the necessary data. The problem is that I cannot find a way to connect to it from labview and run the queries I need.

Please advise.

[Matthew_Kelton]

There are some example sample strings here.

Google provided several other resources by searching for "sql compact connection string".

[manost]

Thanks for the reply.

How am I going to use those strings in Labview?

My previous experience in SQL is in WinXP OS using the DB connectivity toolkit. I was building an ODBC and connecting to Data Base through that. In WinCE though and SQL compact, I think ODBC is not supported.

[Matthew_Kelton]

The DB Tools Open Connection VI is a polymorphic VI which can take a string as an input.  You just use the connection string as the input.  You don't have to setup anything in ODBC to have this work.

Message Edited by Matthew Kelton on 07-23-2009 09:12 AM