ADO.NET 2.0 & MSDE & Win98

[Mircea Pleteriu]

Hi all,

I've implemented a .NET Windows Forms application with VS 2005 and .NET
Framework 2.0 which must be deployed on Windows 98 platform. The MSDE will
be installed on Win98 as the SQL Server to which the app will connect.

On the Win98 platform I've installed .NET Framework redistributable package
and the MSDE and then I've set up the database (which my app will use) by
running a script with the OSQL tool.

All fina by now.

But surprize... even if the db can be access and browsed with the osql
tool... the .net app cannot connect to the database. It throws the following
exception message:

System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the server. When connection 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: 4- -
Could not open a connection to SQL Server).

Do you have any idea where the problem could be?

I mention that my app runs successfuly on Windows XP/2000 with MSDE
installed.

Mircea,

 

[William \(Bill\) Vaughn]

See my blog for a connection checklist. If that does not help come back
here...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Kevin Yu [MSFT]]

Very good checklist from Bill. Please also check if you have the latest
MDAC installed. Download from the following link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=78cac895-efc2-4f8e-
a9e0-3a1afbd5922e&DisplayLang=en

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Mircea Pleteriu]

I'm back.

The problem was fixed by reinstalling the MSDE with DISABLENETWORKPROTOCOLS
= 0.
Don't know why.

 

[William \(Bill\) Vaughn]

SQL Server Express and MSDE are shipped with the network protocols disabled.
This prevents them from being attacked by those who know the default port
assignments. At this point in time you should be using SQL Server Express,
not MSDE. It's also free and has a far richer toolset and functionality. And
no, if you're using ADO.NET 2.0, you don't need the MDAC stack.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Mircea Pleteriu]

Does SQL Server Express run just fine on Windows 98?

 

[William \(Bill\) Vaughn]

Ah, no. If you have to support Win98 you're stuck with MSDE.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=139877&SiteID=1


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________