Showing posts with label folksive. Show all posts
Showing posts with label folksive. Show all posts

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