| Groups | Blog | Home |
sql server (microsoft) : SQLDMO Question
I have a .NET application hitting SQL Server 2000 SP3a on the local machine, using Windows Authentication. This app uses SQLDMO to obtain a list of servers. Al l works fine on desktop machine. I move the app to a laptop (same configuration), but the app finds no Servers. Any ideas on what could be the culprit? Thanks Michael
Hmm, no answers, but I have a similar problem. I was trying to install the
VB.net commerce starter kit, but it said it could not locate any instances of SQL server or MSDE on my machine. This is strange since I have used SQL server 2000 lots, and never had this sort of problem. Reinstalled SQL server several times, did a repair on MS developer studio, finally uninstalled VS 2003 and reinstalled. The commerce kit still can't find SQL server and also, VS 2003 Server Explorer can't find SQL server. But I have apps that run with no problem agaist sql server in VS! Whay can't server explorer find it? [quoted text, click to view] "Michael Jackson" <michaeldjackson@cox.net> wrote in message news:CQ9Fe.96555$oK.51377@okepread02... > Hi all, > > I have a .NET application hitting SQL Server 2000 SP3a on the local > machine, using Windows Authentication. > > This app uses SQLDMO to obtain a list of servers. Al l works fine on desktop > machine. > > I move the app to a laptop (same configuration), but the app finds no > Servers. > > Any ideas on what could be the culprit? > > Thanks > Michael > > > > >
I started this whole testing process because our main application uses
SQLDMO extensively. This app runs great on my desktop development machine and also on our main server, but when trying to install on multiple customer machines, SQLDMO fails to find servers. I wrote an API version of the function to get SQL Servers. It finds SQL Servers on my development machine, but find NO SQL Servers on my laptop. We will test this API app on other machines and will keep this thread up to date. Michael Jackson [quoted text, click to view] "Patrick Sullivan" <psully@eatel.net> wrote in message news:A9qdnY-3jZbe3XjfRVn-rA@eatel.net... > Hmm, no answers, but I have a similar problem. I was trying to install the > VB.net commerce starter kit, but it said it could not locate any instances > of SQL server or MSDE on my machine. This is strange since I have used SQL > server 2000 lots, and never had this sort of problem. Reinstalled SQL > server > several times, did a repair on MS developer studio, finally uninstalled VS > 2003 and reinstalled. The commerce kit still can't find SQL server and > also, > VS 2003 Server Explorer can't find SQL server. But I have apps that run > with > no problem agaist sql server in VS! Whay can't server explorer find it? > > > "Michael Jackson" <michaeldjackson@cox.net> wrote in message > news:CQ9Fe.96555$oK.51377@okepread02... >> Hi all, >> >> I have a .NET application hitting SQL Server 2000 SP3a on the local >> machine, using Windows Authentication. >> >> This app uses SQLDMO to obtain a list of servers. Al l works fine on > desktop >> machine. >> >> I move the app to a laptop (same configuration), but the app finds no >> Servers. >> >> Any ideas on what could be the culprit? >> >> Thanks >> Michael >> >> >> >> >> > >
Did you use an msi install or did I read you just copied the image files to
the laptop? I read somewhere today (trying to find an answer for my problem) that copying image files will not work for SQL server stuff, which is not surprising. You may need to install prerequisites like ADO etc. But an MSDE or full SQL server install should do that. The only stuff I ever had problems with before were log ons and Crystal reports crap. SQL server works, and most apps work on my machine, but I cannot handle not using server explorer, now this IS my development machine, I hate when it gets screwed up! good luck! [quoted text, click to view] "Michael Jackson" <michaeldjackson@cox.net> wrote in message news:nIdFe.96560$oK.20643@okepread02... > I started this whole testing process because our main application uses > SQLDMO extensively. This app runs great on my desktop development machine > and also on our main server, but when trying to install on multiple customer > machines, SQLDMO fails to find servers. > > I wrote an API version of the function to get SQL Servers. It finds SQL > Servers on my development machine, but find NO SQL Servers on my laptop. We > will test this API app on other machines and will keep this thread up to > date. > > Michael Jackson > > > "Patrick Sullivan" <psully@eatel.net> wrote in message > news:A9qdnY-3jZbe3XjfRVn-rA@eatel.net... > > Hmm, no answers, but I have a similar problem. I was trying to install the > > VB.net commerce starter kit, but it said it could not locate any instances > > of SQL server or MSDE on my machine. This is strange since I have used SQL > > server 2000 lots, and never had this sort of problem. Reinstalled SQL > > server > > several times, did a repair on MS developer studio, finally uninstalled VS > > 2003 and reinstalled. The commerce kit still can't find SQL server and > > also, > > VS 2003 Server Explorer can't find SQL server. But I have apps that run > > with > > no problem agaist sql server in VS! Whay can't server explorer find it? > > > > > > "Michael Jackson" <michaeldjackson@cox.net> wrote in message > > news:CQ9Fe.96555$oK.51377@okepread02... > >> Hi all, > >> > >> I have a .NET application hitting SQL Server 2000 SP3a on the local > >> machine, using Windows Authentication. > >> > >> This app uses SQLDMO to obtain a list of servers. Al l works fine on > > desktop > >> machine. > >> > >> I move the app to a laptop (same configuration), but the app finds no > >> Servers. > >> > >> Any ideas on what could be the culprit? > >> > >> Thanks > >> Michael > >> > >> > >> > >> > >> > > > > > >
The laptop already had SQL Server installed, along with VS Studio 2003.
Oddly, our app ran some time ago on the laptop just fine. At some point, I had to reinstall SQL Server 2000 and SP3. The application was on the laptop in the form of the entire solution, since I developed on both at that time. I have not put the app (or solution) back on the laptop; I've only tested with the SQLDMO tests. Michael [quoted text, click to view] "Patrick Sullivan" <psully@eatel.net> wrote in message news:9ZKdnSCULIPCBnjfRVn-rg@eatel.net... > Did you use an msi install or did I read you just copied the image files > to > the laptop? I read somewhere today (trying to find an answer for my > problem) > that copying image files will not work for SQL server stuff, which is not > surprising. You may need to install prerequisites like ADO etc. But an > MSDE > or full SQL server install should do that. The only stuff I ever had > problems with before were log ons and Crystal reports crap. SQL server > works, and most apps work on my machine, but I cannot handle not using > server explorer, now this IS my development machine, I hate when it gets > screwed up! > good luck! > > > "Michael Jackson" <michaeldjackson@cox.net> wrote in message > news:nIdFe.96560$oK.20643@okepread02... >> I started this whole testing process because our main application uses >> SQLDMO extensively. This app runs great on my desktop development machine >> and also on our main server, but when trying to install on multiple > customer >> machines, SQLDMO fails to find servers. >> >> I wrote an API version of the function to get SQL Servers. It finds SQL >> Servers on my development machine, but find NO SQL Servers on my laptop. > We >> will test this API app on other machines and will keep this thread up to >> date. >> >> Michael Jackson >> >> >> "Patrick Sullivan" <psully@eatel.net> wrote in message >> news:A9qdnY-3jZbe3XjfRVn-rA@eatel.net... >> > Hmm, no answers, but I have a similar problem. I was trying to install > the >> > VB.net commerce starter kit, but it said it could not locate any > instances >> > of SQL server or MSDE on my machine. This is strange since I have used > SQL >> > server 2000 lots, and never had this sort of problem. Reinstalled SQL >> > server >> > several times, did a repair on MS developer studio, finally uninstalled > VS >> > 2003 and reinstalled. The commerce kit still can't find SQL server and >> > also, >> > VS 2003 Server Explorer can't find SQL server. But I have apps that run >> > with >> > no problem agaist sql server in VS! Whay can't server explorer find it? >> > >> > >> > "Michael Jackson" <michaeldjackson@cox.net> wrote in message >> > news:CQ9Fe.96555$oK.51377@okepread02... >> >> Hi all, >> >> >> >> I have a .NET application hitting SQL Server 2000 SP3a on the local >> >> machine, using Windows Authentication. >> >> >> >> This app uses SQLDMO to obtain a list of servers. Al l works fine on >> > desktop >> >> machine. >> >> >> >> I move the app to a laptop (same configuration), but the app finds no >> >> Servers. >> >> >> >> Any ideas on what could be the culprit? >> >> >> >> Thanks >> >> Michael >> >> >> >> >> >> >> >> >> >> >> > >> > >> >> > >
I spent a lot of time at MSDN last night. Downloaded portquery and learned
about odbcping, which is not installed in setup anymore, so I installed that. ODBCPing finds "SQL Server 2000 Enterprise" easily. I am not sure about how portqry works yet, or what all the messages mean. Regardless, it should be using shared memory. Also downloaded and installed service pack 4. No difference. Here's the page I was looking at mostly last nite, How to troubleshoot connectivity issues in SQL Server 2000 http://support.microsoft.com/default.aspx?scid=kb;en-us;827422
Hi Michael,
I found my problem, local security policy! Somehow mine got screwed up. I had installed and uninstalled Oracle 10g a few weeks ago, sometime after that is when my problems began. Start, Administrative Tools, Local security Policy. Check yours out. [quoted text, click to view] "Michael Jackson" <michaeldjackson@cox.net> wrote in message news:CQ9Fe.96555$oK.51377@okepread02... > Hi all, > > I have a .NET application hitting SQL Server 2000 SP3a on the local > machine, using Windows Authentication. > > This app uses SQLDMO to obtain a list of servers. Al l works fine on desktop > machine. > > I move the app to a laptop (same configuration), but the app finds no > Servers. > > Any ideas on what could be the culprit? > > Thanks > Michael > > > > >
Don't see what you're looking for? Try a search.
|
March 2003
April 2003
May 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |