Get name of SQLserver 2000 with VB.net 2003
-
Hi! Counld you help me please? I want to get the name of SQLServer 2000 and put it into a combobox, SQLServer may be on my computor and may be on Server in my network (my computor is a workstation but it has SQLServer 2000 too). How can I do that, I until use vb.net 2003 Thanks a lot.
-
Hi! Counld you help me please? I want to get the name of SQLServer 2000 and put it into a combobox, SQLServer may be on my computor and may be on Server in my network (my computor is a workstation but it has SQLServer 2000 too). How can I do that, I until use vb.net 2003 Thanks a lot.
plz i need it badly too
-
Hi! Counld you help me please? I want to get the name of SQLServer 2000 and put it into a combobox, SQLServer may be on my computor and may be on Server in my network (my computor is a workstation but it has SQLServer 2000 too). How can I do that, I until use vb.net 2003 Thanks a lot.
You may need to use SQLDMO http://www.csharphelp.com/archives2/archive342.html[^]
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
-
plz i need it badly too
Refer the original thread: http://www.codeproject.com/script/comments/forums.asp?forumid=1646&select=1831430&fr=51&df=100#xx1831430xx[^]
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
-
You may need to use SQLDMO http://www.csharphelp.com/archives2/archive342.html[^]
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
i use vb.net 2003 and not c #
-
You may need to use SQLDMO http://www.csharphelp.com/archives2/archive342.html[^]
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
Hi! I had refer that URL, but until get error message I had reference SQLDMO and declare: private SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); SQLDMO.NameList sqlServers=null; this is my code: private void Form1_Load(object sender, System.EventArgs e) { try { sqlServers = sqlApp.ListAvailableSQLServers(); for(int i=0;i 0) this.cboServers.SelectedIndex = 0; else this.cboServers.Text = ""; } catch(Exception err) { MessageBox.Show(err.ToString(),"Error"); } } and i get an error: System.InvalidCastException:QueryInterface for interface SQLDMO.NameList faild at SQLDMO.ApplicationClass.ListAvailableSQLServer() at .... Cuold you help me, please.