ODBC SQL Server driver

I've just had a look at the list of ODBC data sources on 2 Win 10 machines with Access 2010:

a) a tablet which doesn't have SQL Server
b) a workstation which also has SSMS 2014

The tablet has a list of basic drivers for Access/SQL Server/Excel/Oracle/Paradox/Text which is what Pat was referring to.
These are installed with Access (or perhaps by Windows as Galxiom suggests)

The workstation has all the above items plus three more for SQL Server (highlighted).

attachment.php


As I've never added any of these manually, these must have been added when SSMS was installed (as I originally suggested back in post #8)

The following shows the SQL Server items from my list of services

attachment.php


Looking again at my example connection string from post #8 may indicate I'm only using the basic SQL Server driver.
Whatever the reason, all my apps with SQL Server BE files always work 'out of the box' with no additional configuration on each workstation

As a side note, can anyone tell me what 'Treiber' stands for in the list of ODBC sources
 

Attachments

  • ODBC drivers.PNG
    ODBC drivers.PNG
    30.4 KB · Views: 164
  • SQL Server Services.PNG
    SQL Server Services.PNG
    26.3 KB · Views: 171
Last edited:

Users who are viewing this thread

Back
Top Bottom