Getting error when try to stored procedure in SQL Server Test database

Asked By 10 points N/A Posted on -
qa-featured

Hello,

I am trying to execute a stored procedure using some code in SQL Server 2005 from Access 2003 where the ‘DSN’ name is not included by the connection string.

The server code was working fine a few weeks ago but now I am getting the following error message when I try to execute the stored procedure in SQL Server Test database.

Please help me to resolve this issue. Any help would be appreciated.

Thanks in advance.

Error number: 3151 Description: ODBC--connection to '{SQL Native Client 11.0} OL-WIN7PRO23SQLEXPRESS' failed.

Error Changing Server Name

Error number: 3151

Description: ODBC–connection to '{SQL Native Client

11.0}OL-WIN7PRO23SQLEXPRESS' failed.

SHARE
Answered By 0 points N/A #176105

Getting error when try to stored procedure in SQL Server Test database

qa-featured

The error number: 3151 usually comes up if your server is not able to handle remote connections.

Or perhaps, TCP/IP is disabled. However, the error may also come up randomly.

One work around is to put the result set of your report’s base query into an empty temp table at the database and run the report directly off the temp table.

You can also try increasing the ODBC timeout of the query from 60 seconds to 180 seconds (3 min).

Login/Register to Answer

Related Questions