|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ADO.NET 2.0 & MSDE & Win98I'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, See my blog for a connection checklist. If that does not help come back
here... -- Show quote____________________________________ 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:%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, > > 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." 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, > > 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. -- Show quote____________________________________ 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, >> >> > > 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, > >> > >> > > > > > > Ah, no. If you have to support Win98 you're stuck with MSDE.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=139877&SiteID=1 -- Show quote____________________________________ 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: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, >> >> >> >> >> > >> > >> >> > > |
|||||||||||||||||||||||