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

Asked By Jeremy V Martinez 10 points N/A Posted on - 07/27/2013

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 Changing Server Name

Error number: 3151

Description: ODBC–connection to '{SQL Native Client

11.0}OL-WIN7PRO23SQLEXPRESS' failed.

• Status: Open
• Question Views: 703
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Newman Gust 0 points N/A #176105

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

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).

About Newman Gust

Questions
0

Answers
13

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 09/02/2013
• Question Category: Database