I'm very new to database operations, so bear with me.
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.
Is there a better driver with which to communicate with a sdf file?
View Complete Post