Monday, February 20, 2012

MSDE Error on attempting to create new Access 2000 project

Hi folks
I've just installed MSDE on my Win 2k machine and have attempted to
create a new Access 2000 project. When I do (and using a number of
different Login ID/Password combinations), I get this:
Connection failed:
SQLState: '01000'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile()).
Connection failed:
SQLState: '08001'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver]Client unable to establish
connection
can anyone tell me what this means and what I should do. Any help much
appreciated.
thanks
Laurence
Laurence,
See: http://support.microsoft.com/default...b;en-us;233312
It looks like you do not have named pipes installed with your MSDE, but you
are using it from your client.
Russell Fields
"Laurence" <laurencetruman@.yahoo.com> wrote in message
news:c8e229b3.0406090533.5ecefd75@.posting.google.c om...
> Hi folks
> I've just installed MSDE on my Win 2k machine and have attempted to
> create a new Access 2000 project. When I do (and using a number of
> different Login ID/Password combinations), I get this:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 123
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
> (CreateFile()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 123
> [Microsoft][ODBC SQL Server Driver]Client unable to establish
> connection
> can anyone tell me what this means and what I should do. Any help much
> appreciated.
> thanks
> Laurence
|||Laurence,
Actually, you might find this more helpful (since my first post was to an
old version of MSDE)
ACC2002: "Configuring SQL Server 2000 Desktop Engine" White Paper Available
in Download Center
http://support.microsoft.com/default...b;en-us;301413
Russell Fields
"Laurence" <laurencetruman@.yahoo.com> wrote in message
news:c8e229b3.0406090533.5ecefd75@.posting.google.c om...
> Hi folks
> I've just installed MSDE on my Win 2k machine and have attempted to
> create a new Access 2000 project. When I do (and using a number of
> different Login ID/Password combinations), I get this:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 123
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
> (CreateFile()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 123
> [Microsoft][ODBC SQL Server Driver]Client unable to establish
> connection
> can anyone tell me what this means and what I should do. Any help much
> appreciated.
> thanks
> Laurence

No comments:

Post a Comment