Solved

Can't connect to SQL 2000

Posted on 2004-04-22
6
527 Views
Last Modified: 2012-05-04
This is strange....

I have a VB standard app that connects to SQL 2000 via the DED.  I have the app and SQL 2000 both installed on Window XP Pro.  Now this app has always connected to SQL until.... I connected to the internet via my slow dialup.  If I'm connected with my dialup I can not connect to SQL.

I get the following error: Run-time error -2147220992(80040200) [DBNetLiB][ConnectOpen(Connet()).] SQL Server does not exist or access denied.

And if I disconnect from my dialup then everything is O.K.

My problem with this is that the client expects to use this app and be connected to the internet.

Can Anyone Help with this strange problem?
0
Comment
Question by:tellis16
6 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 400 total points
ID: 10895424
You need to set your workstation to use TCP/IP with SQL Server.  Use the SQL Server Client Network Utility.

Also, please maintain these very old open questions:
1 11/11/2003 500 Configure user-to-user Apache connection  Open Apache
2 11/11/2003 500 Configure user-to-user Apache connection  Open Apache

Thanks.
0
 
LVL 3

Expert Comment

by:rinksno1
ID: 10896194
go to the server network utility and enable the tcp/ip..
0
 

Author Comment

by:tellis16
ID: 10897046
acperkins,

ah... thanks.   What I did was go into Server Network Utilities and removed 'Named Pipes' and this fixed the problem.
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:tellis16
ID: 10897049
acperkins,

How can I maintain the old Apache questions?
0
 
LVL 5

Expert Comment

by:amit1978
ID: 10897064
plz check the TCP/IP property of network utility ....... i also have the same problem and solved by this


amit jain
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 10899511
>>How can I maintain the old Apache questions?<<
Here are your options:
Accept an Expert's Comment as the Answer http://www.experts-exchange.com/help.jsp#hi68
Accept Comments from more than one Expert (a Split) http://www.experts-exchange.com/help.jsp#hi69
Request a refund because you answered your own question (Refund/PAQ) http://www.experts-exchange.com/help.jsp#hi70
Request a refund because no one answered your question (Delete) http://www.experts-exchange.com/help.jsp#hi71
Abandon your question and leave the mess for someone else to clean up http://www.experts-exchange.com/help.jsp#hi78
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Write data from SQL to CSV file - position 1 58
Problem to skip loop 6 56
Copy a row 12 61
Error with a code discussed on this page 5 12
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now