MSDE 1.0 --> MSDE 2000 DB Connection Failure

Just recently updated to MSDE 2000 using the SP3 Desktop upgrade. Now when this software runs it cannot connect to the Database.
I believe the problem to come in a line wrote as so:
BSTR bstrOpen = gServerName.AllocSysString();
although I'm not 100%.
Just wondering if anyone might had the same problem with MSDE 2000 and what they did to fix it. Thanks!
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Hi,
One of the things that's different about MSDE2000 is that by default, tcp is
not enabled. You might need to re-enable it. You can do this by running
svrnetcn.exe.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%234NbSXufEHA.2984@.tk2msftngp13.phx.gbl...
> Just recently updated to MSDE 2000 using the SP3 Desktop upgrade. Now
when this software runs it cannot connect to the Database.
> I believe the problem to come in a line wrote as so:
> BSTR bstrOpen = gServerName.AllocSysString();
> although I'm not 100%.
> Just wondering if anyone might had the same problem with MSDE 2000 and
what they did to fix it. Thanks!
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

MSDE - Insuring that process is up & running

I'm developing a C# application that runs against MSDE. How can I
programatically check whether MSDE is running and, if not, start it up
and set it to "auto-start"?
Thanks in advance!
hi,
"FinallyInSeattle" <lori.pearsall7@.gte.net> ha scritto nel messaggio
news:c987b316.0406241719.46bc434b@.posting.google.c om...
> I'm developing a C# application that runs against MSDE. How can I
> programatically check whether MSDE is running and, if not, start it up
> and set it to "auto-start"?
> Thanks in advance!
as regard then service running test, you coul'd use SQL-DMO object model...
when connecting, you can specify the .Start method instead of .Connect
metodh , and trap the resulting error , if any...
err -2147023840 indicates the instance is already running...
or trying connecti via Ado.Net, setting the connection timeout to a low
value, and, on error, sending a NET START command...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea!!
"Andrea Montanari" wrote:

> hi,
> "FinallyInSeattle" <lori.pearsall7@.gte.net> ha scritto nel messaggio
> news:c987b316.0406241719.46bc434b@.posting.google.c om...
> as regard then service running test, you coul'd use SQL-DMO object model...
> when connecting, you can specify the .Start method instead of .Connect
> metodh , and trap the resulting error , if any...
> err -2147023840 indicates the instance is already running...
> or trying connecti via Ado.Net, setting the connection timeout to a low
> value, and, on error, sending a NET START command...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>