473,326 Members | 2,148 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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
Nov 13 '05 #1
2 1627
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" <la************@yahoo.com> wrote in message
news:c8**************************@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

Nov 13 '05 #2
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" <la************@yahoo.com> wrote in message
news:c8**************************@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

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
3
by: Stephen Bishop | last post by:
Hi everyone, In using the SQL Server Database Wizard in Access 2000 to create a new access project, I get two consecutive error messages and then the wizard shuts down. The first, which apprears...
10
by: noname | last post by:
MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install...
3
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing...
1
by: smahler | last post by:
Hi all, Here is my situation. I have an application that uses SQL 2000. The client has a program that uses MSDE. The client MUST have the MSDE version of the Database. What I have done is to...
1
by: farqua | last post by:
I've finally got MSDE 2000 sp3a to install on my PC by turning on the "Server" service. Duh! Unfortunately, I can't get it to connect to the server when I try to upsize a tables in an mdb...
6
by: AlanS | last post by:
I have used Visual Studio for about 8 months. I have developed some ASP solutions. I had to get on with some other things and have not worked with ASP.NET for a couple months. In the meantime, I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.