Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / New Users / December 2005

Tip: Looking for answers? Try searching our database.

Sudden error on connection, conflict sql 2000-2005? desperated!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pieter - 02 Dec 2005 17:50 GMT
Hi,

I have some nasty error when deploying my application (VB.NET 20002) on the
users-computers. I'm using an SQL 2000 database.

The problem I guess is the fact that I had a local SQL 2000 and a local SQL
2005. I used to develop on a network SQL 2000 (the same which the users are
connecting too), and everything works fine. But now I am not in the office
for 2 weeks, so I have to develop on my local SQL 2000 instance. I send them
the exectuable, and this is what they get:

"An error has occurred while establishing a connection to the server.  When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server)"

I only gave them a new exectuable, the App.Config didn't change.

anybody gets any idea? I'm getting kind of desperated. I desinstalled SQL
2000 AND SQL 2005, and re-installed only SQL 2000. But I still get the
error.

Anybody any idea, any hints?

Thanks a lot in advance!

Pieter
Alan Pretre - 02 Dec 2005 18:10 GMT
> "An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the fact
> that under the default settings SQL Server does not allow remote
> connections. (provider: Named Pipes Provider, error: 40 - Could not open a
> connection to SQL Server)"

> anybody gets any idea? I'm getting kind of desperated. I desinstalled SQL
> 2000 AND SQL 2005, and re-installed only SQL 2000. But I still get the
> error.

Yes, we have seen this at our office.  I believe you have to go into SQL
2005 config and enable TCP/IP connections.  This gets turned off for some
reason in the upgrade.

-- Alan
Pieter - 02 Dec 2005 18:22 GMT
But I'm not using SQL 2005 at all! The users are connecting to a SQL 2000
database! :-S
And everything worked fine before, it just this week that it broke down...

> Yes, we have seen this at our office.  I believe you have to go into SQL
> 2005 config and enable TCP/IP connections.  This gets turned off for some
> reason in the upgrade.
>
> -- Alan
Alan Pretre - 02 Dec 2005 18:34 GMT
> But I'm not using SQL 2005 at all! The users are connecting to a SQL 2000
> database! :-S
> And everything worked fine before, it just this week that it broke down...

Try checking the settings anyway.  This sounds like the error we saw here.
In SQL 2000, go into SQL Server Client Network Utility and see if TCP/IP and
Named Pipes are enabled.

-- Alan
Pieter - 03 Dec 2005 09:07 GMT
Ok, I found the problem: The connectionstring was just not right: it was
poiting to my local SQL Server, which they can not access there offcourse
:-)
Although I don't get it yet how this could happen:
I'm using the Settings.settings of VB.NET to define a Connectionstring
(Scope = application). But it seems that this value is hardcoded somewhere
in the application? I had a App.Config in which it had the right value, but
that value isn't used?

I'm really getting confused now :-S It seems that I must take a better look
to the Settings.settings, because it doesn't react as I expected :-)

thanks anyways,

Pieter

>> But I'm not using SQL 2005 at all! The users are connecting to a SQL 2000
>> database! :-S
[quoted text clipped - 6 lines]
>
> -- Alan

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.