Re: ADO.NET 2.0 & MSDE & Win98

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.
__________________________________

"Mircea Pleteriu" <mpleteriu@xxxxxxxxxxxxxxxx> wrote in message
news:%23HX8z0fNGHA.3360@xxxxxxxxxxxxxxxxxxxxxxx
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,




.

Relevant Pages

  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)
  • Re: SQLserver connect ????
    ... running SQL Server and all 3 of them have an MSDE database on them. ... sqlserver database, ... all devices can connect to its sql server and msde ... Also uninstalled NAV, rebooted, and still no connection ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SQLserver connect ????
    ... > running SQL Server and all 3 of them have an MSDE database on them. ... > connection to the sqlserver database, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: General Network Error
    ... connection, but you are not properly prepared to reopen a connection when ... retrieves data from a Sql Server 2000 instance, manipulates that data, ... The app works fine on the emulator during development. ... "General Network error. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Administering MSDE with Enterprise Manager
    ... MSDE Manager SQL Tools ... The dialog "Register SQL Server Messages" returns the error: ... > Any idea how to make this Server connection trusted? ... >>> created during MSDE's install. ...
    (microsoft.public.sqlserver.connect)