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
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
Aug 18, 2011
TCP Server/Client - Disconnecting Sockets
View 3 Replies
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
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
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
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