SMO Not Disconnecting From SQL?

Jun 5, 2010

I'm populating a listview with a list of databases for the selected instance.

What ever I do I cannot get SMO to disconnect from my SQL2008 instance...

server.ConnectionContext.IsOpen returns false but server.ConnectionContext.InUse returns true?

Here's my code:

Public Sub UpdateServerList()
LVDatabases.Items.Clear()
Dim serverName As String = SQLServerName + "" + Instance

[Code]....

View 2 Replies


ADVERTISEMENT

IDE :: Disconnecting From Source Safe?

Feb 27, 2009

I am using VS2005, using VB.Net?I just created a local copy of a project on my drive. The original copy is being worked on by another developer.I deleted the .vspscc & .scc files?However, everytime I make a change, I get the message that the file is locked, and exclusively checkout by another developer. How can I make changes to the project, that I have copied to my drive. I need to disconnect it from VSS.

View 2 Replies

TCP Server/Client - Disconnecting Sockets?

Aug 18, 2011

TCP Server/Client - Disconnecting Sockets

View 3 Replies

VS 2008 - Disconnecting From Chat Server

Mar 31, 2009

I've been attempting to create a Chat client/server for a while and I found some good tutorials for Visual Basic Express 2008. But I would like my client to be able to disconnect and have the server acknowledge the fact (and send the same message that it does when someone connects) that a client disconnected.
[Code]

View 2 Replies

VS 2010 Disconnecting Network Connection And Reconnecting?

May 12, 2011

I have a USB 3G dongle from Orange which is like a dialup connection, rather than a wireless connection.

Is there anyway in vb.net to control this connection? So disconnect is and recconnect it etc?The reason for this is automatically getting a new ip address without manually disconnecting in network connections.

View 6 Replies

MSAccess Attached With The Connection String - Add A Field To The Database Without Disconnecting It?

Oct 19, 2010

I have already connected my database and have completed multiple forms and reports.Just discovered that I missed adding ONE field in an Access table.Since it is attached how can I add a field to the database without disconnecting it? If I do disconnect it and reconnect will I have to redesign all my forms and reports?

View 1 Replies

"disconnecting" From A SQL Database?

Mar 18, 2010

Greetings. I have an application where the user can open a form and view data from a SQL2005 database. I'm developing with VB2005 Express Edition. The form has a list box with its DataSource = bsJobData. I have 3 icons below my form:dsJobInfo with its DataSetName = JobInfoDataSet. JobInfoDataSet is something I can see on my Data Sources tab.

[Code]...

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved