Home All Groups Group Topic Archive Search About

ADO.NET 2.0 & MSDE & Win98

Author
20 Feb 2006 9:08 AM
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,

Author
20 Feb 2006 4:53 PM
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.
__________________________________

Show quote
"Mircea Pleteriu" <mpleteriu@newsgroup.nospam> wrote in message
news:%23HX8z0fNGHA.3360@TK2MSFTNGP15.phx.gbl...
> 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,
>
>
Author
21 Feb 2006 2:25 AM
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."
Author
21 Feb 2006 3:24 PM
Mircea Pleteriu
I'm back.

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

Show quote
"Mircea Pleteriu" <mpleteriu@newsgroup.nospam> wrote in message
news:#HX8z0fNGHA.3360@TK2MSFTNGP15.phx.gbl...
> 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,
>
>
Author
21 Feb 2006 4:19 PM
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.
__________________________________

Show quote
"Mircea Pleteriu" <mpleteriu@newsgroup.nospam> wrote in message
news:%23CtbarvNGHA.3728@tk2msftngp13.phx.gbl...
> I'm back.
>
> The problem was fixed by reinstalling the MSDE with
> DISABLENETWORKPROTOCOLS
> = 0.
> Don't know why.
>
> "Mircea Pleteriu" <mpleteriu@newsgroup.nospam> wrote in message
> news:#HX8z0fNGHA.3360@TK2MSFTNGP15.phx.gbl...
>> 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,
>>
>>
>
>
Author
22 Feb 2006 8:25 AM
Mircea Pleteriu
Does SQL Server Express run just fine on Windows 98?

Show quote
"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
news:#646XKwNGHA.1716@TK2MSFTNGP10.phx.gbl...
> 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" <mpleteriu@newsgroup.nospam> wrote in message
> news:%23CtbarvNGHA.3728@tk2msftngp13.phx.gbl...
> > I'm back.
> >
> > The problem was fixed by reinstalling the MSDE with
> > DISABLENETWORKPROTOCOLS
> > = 0.
> > Don't know why.
> >
> > "Mircea Pleteriu" <mpleteriu@newsgroup.nospam> wrote in message
> > news:#HX8z0fNGHA.3360@TK2MSFTNGP15.phx.gbl...
> >> 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,
> >>
> >>
> >
> >
>
>
Author
22 Feb 2006 5:45 PM
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.
__________________________________

Show quote
"Mircea Pleteriu" <mpleteriu@newsgroup.nospam> wrote in message
news:OGOvAm4NGHA.3408@TK2MSFTNGP14.phx.gbl...
> Does SQL Server Express run just fine on Windows 98?
>
> "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
> news:#646XKwNGHA.1716@TK2MSFTNGP10.phx.gbl...
>> 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" <mpleteriu@newsgroup.nospam> wrote in message
>> news:%23CtbarvNGHA.3728@tk2msftngp13.phx.gbl...
>> > I'm back.
>> >
>> > The problem was fixed by reinstalling the MSDE with
>> > DISABLENETWORKPROTOCOLS
>> > = 0.
>> > Don't know why.
>> >
>> > "Mircea Pleteriu" <mpleteriu@newsgroup.nospam> wrote in message
>> > news:#HX8z0fNGHA.3360@TK2MSFTNGP15.phx.gbl...
>> >> 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,
>> >>
>> >>
>> >
>> >
>>
>>
>
>

AddThis Social Bookmark Button