I am attempting to connect my MS Access 2013 front end to a SQL Server 2012 backend using the code below.

I am getting the error message “Optional feature not implemented” from the ODBC driver.  I am using the SQL Server driver but I also have access to ODBC Driver 11 and ODBC driver 17 for SQL server, but I still get the same error message regardless of which of these three drivers are used.  What am I doing wrong?

Dim cnn As New ADODB.Connection
Dim cmd As New ADODB.Command

Dim connString As String
Dim prmEmployeeID As New ADODB.Parameter
Dim prmYearBeginDate As New ADODB.Parameter

connString = “DSN=FullOnAccounting;Driver={SQL Server};Server=AMFMSSQL;Database=Full_Up_Accounting;TrustedConnection=Yes;”
cnn.Open (connString)   <–Error occurs here

​I am attempting to connect my MS Access 2013 front end to a SQL Server 2012 backend using the code below.I am getting the error message “Optional feature not implemented” from the ODBC driver.  I am using the SQL Server driver but I also have access to ODBC Driver 11 and ODBC driver 17 for SQL server, but I still get the same error message regardless of which of these three drivers are used.  What am I doing wrong? Dim cnn As New ADODB.ConnectionDim cmd As New ADODB.CommandDim connString As StringDim prmEmployeeID As New ADODB.ParameterDim prmYearBeginDate As New ADODB.ParameterconnString = “DSN=FullOnAccounting;Driver={SQL Server};Server=AMFMSSQL;Database=Full_Up_Accounting;TrustedConnection=Yes;”cnn.Open (connString)   <–Error occurs here    Read More

​