none
SQLSERVER COMPACT and EXCEL 365 VBA & RRS feed

  • Question

  • Hello budies,

    My first time dealing with SQL Server Compact and Excel 365 VBA.

    I referenced to:
    Microsoft ActiveX Data Objects 6.1 Library.
    Microsoft ADO Ext.6.0 for DDL and Security

    I connected to the DB using:


    MyPath = ActiveWorkbook.Path
             MyDB = "\DBSINFOAD.sdf"
             StrConn = "PROVIDER=Microsoft.SQLSERVER.CE.OLEDB.3.5;SSCE:Database Password=*******;Data Source=" & MyPath & MyDB
    The app is doing great in the desktop I used to coded it, same computer that has SQL Server Management Studio installed.

    The problem is when I try to used the app in another computer, I receive an error saying "Provider cannot be found..."

    The app is going to be used in many labtops that have not SQL Server installed.

    The question is: Does an Sql Server Compact Database requires The Management Studio Installed in order to be used for an app?

    Thursday, January 16, 2020 2:16 AM

All replies