Can i use this driver to connect with sal compact edition
RealTimeTech opened this issue · 3 comments
RealTimeTech commented
- Is it possible to read data from sql ce with node js.
- Sql ce db file format .sdf
- for that Microsoft .net environment is mandatory?
Please help me out and thanks in advance :)
RealTimeTech commented
Sorry not sal that is SQL compact edition.
meet-bhagdev commented
@David-Engel can help answer questions
David-Engel commented
- Unfortunately, no. SQL CE only supports connections using ADO.NET or OLEDB. The Microsoft Driver for Node.js for SQL Server relies on the Microsoft ODBC Driver for SQL Server which cannot connect to SQL CE.
2 & 3. .sdf is simply the file format of a SQL CE database. It should not require .NET. However, if you choose to use ADO.NET, that does require .NET. If you choose OLEDB, that is generally used with C++ applications.
David