Follow the below steps to enable Named Pipe setting: The ODBC connection may fail if this protocol is disabled. “Named Pipe” is a protocol used to establish connection between network users and Microsoft SQL Server. Check the login credentials and then click Next.Ĭheck if the error 3151 is resolved. The Create a New Data Source to SQL Server window is displayed.In the Create New Data Source window, select SQL Server and then click Next.In the Select Data Source dialog box, click on the Machine Data Source option and then click New.In the Get External Data – ODBC Database window, select “ Link to the data source by creating a linked table.”.

Go to the File option, click External Data, and then click ODBC Database.You can confirm the Login ID and Password set at the time of ODBC connection creation. The Access database 3151 error can occur if you are using incorrect ODBC credentials. The first thing to do is to check the ODBC credentials. Methods to Fix Access Database 3151 Error – ODBC Connection Failedīelow are some methods you can try to resolve the error 3151 – ODBC connection failed in MS Access. Data source name is not defined to pass the connection information directly to the ODBC Driver Manager.Windows Firewall is not allowing the connection.Named pipe settings in Windows are disabled.ODBC driver for SQL Server is not properly installed.Causes of Access Database 3151 Error – ODBC Connection Failedįollowing are some possible reasons that can trigger the ODBC connection failed error in MS Access: Let’s take a look at the possible causes of this error and the solutions to resolve it. However, there are various other reasons that may cause this error. This error may also occur after performing some changes in the SQL Server and in linked tables in the database. Open Database Connectivity (ODBC) is a protocol that is used to connect a Microsoft Access database to an external data source, such as Microsoft SQL Server. The Access Database Error 3151 – ODBC connection failed usually occurs when using a connection string (ODBC) in a VBA code. Methods to Fix Access Database 3151 Error – ODBC Connection Failed.Causes of Access Database 3151 Error – ODBC Connection Failed.

How do you open a zip file on iphone