How to add a User DSN for a SQL Server Compact Edition Database File

[ewjammer]

I have a SQL Server Compact Edition Database file (filename.sdf).
I can connect to this database file (filename.sdf) using MS SQL Server 2008 with server type set to SQL Server Compact Edition. I can select data and do queries.
But in order to connect to the database file from National Instruments LabWindows CVI, I have to create a User DSN under my ODBC Data Source Administrator.
None of the samples represents a *.sdf file.
I clicked on Add and get a window called Create New Data Source.
I am asked to Select a driver for which you want to set up a data source.
I tried the SQL Server option, but that did not seem to work.
The database connectivity test always fails.
What's the correct driver to connect to a sdf file?

[Snowman 6008]

Ewjammer,

I've never done this, and if anyone has please feel free to post. After looking into this, I've found a few form posts on MSDN saying that the SQL Server Compact Edition Database uses an OLE DB provider rather than an ODBC. Here is an example How to: Create a Database by Using OLE DB (Programmatically) are you just starting out and looking to use SQL Server Compact Edition , or do you already have an existing database application that you need to work with?