January 8, 2009 at 12:20 am
Hi
I'm working on an C# aplication and I need to connect to my local server, or to other servers in my network.
If I remove the network cable, the SQLDMO i'm using detects as server : (local), but I cannot connect to my local server(to (local)).
I tried this on another computer and the connection was posible...I think I have to configure something on the server....or...is a conflict between sql server 2005 and SQLDMO ..or..you know better....
Please help me
I must finish this by 10 ian
January 8, 2009 at 12:33 am
Do you have a "Default Instance" of SQL server on your machine? Because "(local)" and "." works only for default instance. If you have a named instance then you have to use the name of the instance as the name of the server.
-Vikas Bindra
-Vikas Bindra
January 8, 2009 at 12:42 am
Yes.I have a named instance.but it only shows me the name of the instance when I have the network cable, when I'm in the network.When it is removed the only server it shows is the (local).
On the other computer when I wasn't connected it showed other databases than the ones when I was connected on the named instance.I hope this helps.
I think that is a posibility to detect on local only the sql server 2000 or something like this.I have to do some more testing,but I don't have acces to both computers, and don't have to much time 🙁
hope this info is usefull
January 8, 2009 at 12:50 am
Use your local Node\Instance name, even if it doesn't show it to you.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 8, 2009 at 1:19 am
Yes! Try local Node\Instance name or .\Instance name
-Vikas Bindra
-Vikas Bindra
January 8, 2009 at 1:28 am
I asked the owner of the second computer to try the aplication again and to look at the databases it returns. the (local) databases are stored in MSSQL\Data, and the ones returned by the named instance are stored in MSSQL.1\Data , MSSQL.2\Data and MSSQL.3\Data.
I can't make the test with the replacement now , but after I will do it you will receive my feed-back.It seems the best solution so far...because I'm not understanding how SQLDMO works.
Thanks for the responses and I'm waiting for other opinions
January 8, 2009 at 1:37 am
and another question....is there an important difference between SQLDMO 8.0 and SQLDMO 8.5, especialy on the sql server detection and manipulation...?
The documentation is poor...so I ask you....
I've searched on the internet but didn't find an answer...
Thank you again
January 8, 2009 at 6:41 am
Afraid that I do not know.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply