Forum Discussion
ODBC/SQL Server Connection Error
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=AMF\MSSQL;Database=Full_Up_Accounting;TrustedConnection=Yes;"
cnn.Open (connString) <--Error occurs here
- https://www.connectionstrings.com/sql-server-2012/
Standard Security
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;
- https://www.connectionstrings.com/sql-server-2012/
Standard Security
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;- Thank you for you response. I discovered that I was mistaken and the error message that I am seeing is not at all related to my connection, it comes from further down in my code when I attempt to call a SQL Server stored procedure. I will mark this issue as closed and open a new thread if I am not able to resolve it,
