Tuesday, March 27, 2012

General Network Error

Hello,
A User currently having a problem with an Access 2000 application that uses
Linked tables to connect to an SQL 2005 database. The user receives the
following message:
Connection failed:
SQLState: ‘01000’
SQL Server Error: 11004
[Microsoft ][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionOpen(gethostbyname()()).
Connection failed:
SQLState: ‘08001’
SQL Server Error: 11
[Microsoft ][ODBC SQL Server Driver][TCP/IP Sockets] General net
work error.
Check your network documentation.
The application was working for the user but it stopped working after a help
desk person had done some things to her machine to get another application
working. Anybody have an idea on what may have changed to cause this to
happen?
The Users workstation is Windows 2000 SP4. I can also ping and telnet to the
SQL server from that machine.It can be caused by different things but I've seen MDAC
versions be the cause of such problems before. Make sure the
PC has the latest MDAC version. You can download MDAC
versions and also download component checker to check the
MDAC version from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
You would also want to check the event logs on the PC for
any network related issues.
-Sue
On Wed, 26 Jul 2006 08:46:02 -0700, Bill Klein
<BillKlein@.discussions.microsoft.com> wrote:

>Hello,
>A User currently having a problem with an Access 2000 application that uses
>Linked tables to connect to an SQL 2005 database. The user receives the
>following message:
>Connection failed:
>SQLState: 01000
>SQL Server Error: 11004
>[Microsoft ][ODBC SQL Server Driver][TCP/IP Sockets]
>ConnectionOpen(gethostbyname()()).
>Connection failed:
>SQLState: 08001
>SQL Server Error: 11
>[Microsoft ][ODBC SQL Server Driver][TCP/IP Sockets] General ne
twork error.
>Check your network documentation.
>The application was working for the user but it stopped working after a hel
p
>desk person had done some things to her machine to get another application
>working. Anybody have an idea on what may have changed to cause this to
>happen?
>The Users workstation is Windows 2000 SP4. I can also ping and telnet to th
e
>SQL server from that machine.|||Thanks Sue, the computer had version 2.53 i've upgraded it to 2.8 sp1 and
everything seems to work fine now.
"Sue Hoegemeier" wrote:

> It can be caused by different things but I've seen MDAC
> versions be the cause of such problems before. Make sure the
> PC has the latest MDAC version. You can download MDAC
> versions and also download component checker to check the
> MDAC version from:
> http://msdn.microsoft.com/data/ref/mdac/downloads/
> You would also want to check the event logs on the PC for
> any network related issues.
> -Sue
> On Wed, 26 Jul 2006 08:46:02 -0700, Bill Klein
> <BillKlein@.discussions.microsoft.com> wrote:
>
>sql

No comments:

Post a Comment