Wrox Home  
Search P2P Archive for: Go

  Return to Index  

ado_dotnet thread: SQL Server 2000 and Windows 98


Message #1 by "Kevin Ayers" <kevin@f...> on Wed, 19 Feb 2003 11:16:44 -0500
Does anybody know of any issues regarding Windows 98 and SQL Server 2000?
Our company installs the MSDE version of it on a installation and then runs
some scripts to attach our database and setup the security for it.  We also
have a script to blank out the database with a 'clean' database in some
certain cases.  Everything works fine on any Windows 2k/NT4/XP machine and
works fine on some/most Windows 98 machines, but some of the Windows 98
machines don't work properly.  Using osql seems to stop the database in
service manager, but SQL server is still running and from then on the
database is in a weird state.  Please Help because its really screwing up
some of our customers.

Thanks,
Kevin

Message #2 by "Kevin Ayers" <kevin@f...> on Wed, 19 Feb 2003 12:56:16 -0500
OK, I've found the problem(s).  The first being that if you run the 'start
/wait scm -Action 1 -Service mssqlsewrver' command when sql server is still
running it disturbs the state somehow.  The second thing that was happening
was a batch parameter problem --> in win2000 batch files %~1 gives you the
first parameter with any " removed from the beginning and ending while win98
doesn't support that (couldn't find documentation anywhere telleing me this,
but experimentation seemed to prove it)

Kevin

----- Original Message -----
From: "Kevin Ayers" <kevin@f...>
To: "ADO.NET" <ado_dotnet@p...>
Sent: Wednesday, February 19, 2003 11:16 AM
Subject: [ado_dotnet] SQL Server 2000 and Windows 98


> Does anybody know of any issues regarding Windows 98 and SQL Server 2000?
> Our company installs the MSDE version of it on a installation and then
runs
> some scripts to attach our database and setup the security for it.  We
also
> have a script to blank out the database with a 'clean' database in some
> certain cases.  Everything works fine on any Windows 2k/NT4/XP machine and
> works fine on some/most Windows 98 machines, but some of the Windows 98
> machines don't work properly.  Using osql seems to stop the database in
> service manager, but SQL server is still running and from then on the
> database is in a weird state.  Please Help because its really screwing up
> some of our customers.
>
> Thanks,
> Kevin
>
>
> ===
> Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using ADO.NET
in your applications. The book covers DataSets and Typed DataSets, accessing
data using DataReaders and DataAdaptors, the close relationship between
ADO.NET and XML, how and where to use ADO.NET in your enterprise
applications, and how to use Web Services and ADO.NET to easily pass data
between applications.
> http://www.wrox.com/books/1861007604.htm


  Return to Index