I searched on google for these terms : "How to see all open connections in vb.net" and it should be for a server im running and it would be like to see witch users are connected (ip) and then if i type in the console -disconnect ip then the user will be disconnected from the server but is this technical posibble ?
View 4 RepliesUsing VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
[Code]...
Can anyone provide a script to close all open sessions in a Terminal Server?
Aldo.Everything is possible, impossible just takes longer
I have a server which has around 300+ users on it. Though the problem is that its coded in VB6, and if somebody has a bad ping, everybody has a bad ping. I need a tunneling server which will tunnel the incoming and outgoing connections and make there ping appear to be 0 in the server. Client to Server, Server to Client.
View 1 RepliesI'm trying to find where this code might be leaving old connections open, and I found this code that might be the cullprit. It is in a function. I'm wondering if this connection would close, if an exception occured from within the USING statement?
[Code]...
I am currently working on an asp.net web page with a GridView displaying a table from a database.This GridView has 4 DropDownLists that will be used to filter the data shown on the GridView. When the page loads 4 Sub routines are run, each one connecting to the database with a select statement to fill the DropDownList with relevant filter headings.
Initially, I had one connection with a loop that populated all of the drop downs but these contained duplicates. I then split the filling of each DDL so that the select statements could contain DISTINCT. I would like (and am sure there is a way here) to be able to populate all of the DDLs with data from one connection.
Code for one connection:
Protected Sub FillDepDDL()
Dim conn As New SqlConnection()
conn.ConnectionString =
[code]....
The other 3 column names: FirstName > DDLFN, LastName > DDLLN, Wage > DDLWag.This is only a test DB and the princibles learned here will be applied to a larger live project.
I'm pretty new to VB.NET and connecting to SQL Server.What is considered best practice when building an app that needs to connect frequently to a SQL Server DB to fetch, write, delete and update records?Should a connection be opened at app startup (a connection at start is opened to validate the user) and left open for subsequent transactions or should a connection be opened, closed and disposed of each time a read/write to the DB is required?
View 3 RepliesI have a java class that is used to for ssl connections to a web server. I have got some of it converted however there are serveral java libraries that i have been unable to figure out how to call or reference in vb.net. First off i'm not even sure if it's possible to reference them
[Code]...
I have a .net window application created and I wanted to see if it's at all possible to place various file dependencies off the web server. e.g. is it possible to have the connection to the database be off a web server?
I also would like to see if it's possible to place one of the .dlls off the web and have code that points to it to load.
In our VB 2008 we are making a lot of connections to sql server 2005 databases. Is there a possibillity to check with a program or a tool of 2005, all connections are closed?
View 3 RepliesEvery time I execute my application and the app try to access the database I received an error message telling me that the user cannot login into the database. This is because the VS Server Explorer have the connection opened. What I need is that every time I debug (F5) my app the Server Explorer close the connection with the database so I do not have to stop the execution and manually close the connection. Is this is possible? Is there any way I can setup the debug or the Server Explorer to do this?
[Code]...
I am developing project on cyber cafe using vb .net 2005 and winsock i don't know how to accept connections from multiple clients to a server having winsock control
View 2 Repliesa small question: what is the difference between sync and async connections in a tcp/ip client/server application?
View 1 RepliesI have been developing an async socket connection server and client program. I have been testing it, and noticed that if I connect to the server from my client and then disconnect. Upon reconnecting I am on a different port(local IP still). This is fine, however when I go to send a message, and the server trys to update all the clients, it eventually hits clients that do not exist anymore. I get the SocketException 10054, and upon connecting/disconnecting enough, it no longer works at all. My question is how do I clear out these no longer useful sockets from the server? I am doing currentsocket.Shutdown(SocketShutDown.Both); and then a currentsocket.Close(); after that. When a user disconnects.
[Code]...
I have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
[Code]...
I am a newbie and am trying to open a table in SQL Server 2008 table from Visual Basic using ADO and its throwing up a weird fatal error. The error message is:'A fatal error has occurred and debugging needs to be terminated. For more details, see the Microsoft Help and Support web site. HRESULT = 0x80131c08. ErrorCode: 0x0' The code I am running at the time is:
[Code]....
just want to know how how to open wamp server in vb.net.I have the code below..[code]the problem is that when i try wamp server, it is not working.
View 1 RepliesI'm new to visual basic, and need to make a simple program to create new folders on my server. is to connect my excisting SQL server database to this program. Should it be connected using macros, or using the data source-menu? My excisting SQL server has this placement on the server:
[Code]...
I have a button that opens a selected file depending on the file extension (doc, docx, or pdf)... the problem is when I have a pdf file is that the file is displayed in the browser, and when I hit the back button I come back to the original page - but the buttons won't then work...
View 1 RepliesI have a field in a SQL Server 2005 DB of type 'image' that contains documents, mostly pdfs. When I view the field in the database, it looks as though the data is stored as a hex string. I have extensively googled and came up with the VB.net function below to convert the field to an actual file, but it only outputs a file containing the string of hex characters rather than the file that the field is supposed to represent.
This is a sample of the fields' data (I have truncated it for privacy purposes):
[Code]....
And is it possible to open the file straight from a query in SQL server?
is there a way to tell if the record is currently open (for editing) by another useregclerk 1 gets recordset for a person. pessimisic lock, client cursor.
View 1 RepliesI need to download an mp3 file on a linkbutton click event, but i want to force the save or open dialog. I have tried the following code:
Response.End()
When i run this i get nothing, What am i doing wrong? is there any other way to do this?
I have form in which I can change the name of stations in my database (SQL Server: in table Stations).To choose which station I want to edit I've used a combobox.What I want to happen now is that when I update a station, my ComboBox with stations immediatly gets updated with the edited station.
View 1 RepliesIs it possible to store excel, word, pdf, .rar .zip files to a column in a table of a SQL Server 2005 DB.And also open the fie with excel, word, acrobat reader, etc????My other sollution would be to store the file on a location on a server and only sory the filename and location in my db and then open them with "Process.Start("filename")".My main problem with solution 2 is this:Lets say I install the programm on a pc called "manager". When I use the savefiledialog and I am on the manager pc the string C:/myfiles/test.xls will be stored
View 1 RepliesI'm using a "wsHttpBinding" with a reliable session. I'd like to keep the client-server connection endless open. Therefore I need to set the ReceiveTimeout to "infinite". Has the "ReceiveTimeout" an other purpose (e.g. client crash detection; detecting a hanging request; etc) or can I set it to "infinite" without problems?
View 1 RepliesI am looking for some (preferable vb.net) code to use in an asp.net application that will allow me/my users to setup calendars (that I store in SQL server db).
I am looking for something that will make it easy to schedule recurring appts (i.e. every monday, every other week on thursday at 9AM, every month,1st and 3rd tuesday, every year etc) with as many possible scenarios as possible.
I can automate most of the easy ones via a few screens, but inevitably my users come up with scenarios that require me to code and execute some custom scripts in SQL to make the entries, and I'd really like to offload this to the users.
I'm populating a listview with a list of databases on a selected SQL instance, then retrieving a value from each database (It's internal product version, column doesn't always exist) I'm calling the below function to populate the second column of the listview:
[Code]...
I'm trying to understand how to handle db connections in a multi-theaded windows program.It I have this simple class:
public class MyClass
private myConn as new sqlconnection
private MyThreadPool(5) as Thread
[code]....
I searched araound and having some difficulties in implementing one scenario with SQL Server 2000 and sybase.I have two SQL servers on different locations naming ServerA (MSSQL Server) and ServerB (Sybase server).I have a table called SALARY.Whenever I insert one record to customer SALARY in ServerA, I also will insert it into ServerB.If should any of them failed, both of them should be rolled back.I am using Asp .Net with VB for the programming.I do not have the right to change / add table in Server B. The only thing allowed in Server B is insert/delete/update record.I looked around and find a method to use TransactionScope but I am not quite sure it is the right way to do.url...
View 1 RepliesI am developing an Application that uses TCP To listen for connections, and then when a message is sent to the server and then it alerts the IP that is running the server. (Lets say the server is on a iPhone, and some how the iPhone gets a text message, which alerts a tcp server running in the background via a .jar, it would send the owner of the iPhone a message on the computer telling it it has a text. This is just an example though, but I think it gets the general idea across. I've been trying to do this, and I can connect to a TCP Server (using 127.0.0.1:8888 for testing purposes, will move to a solid IP and Port later). I can start the server (its still buggy and under development) but i don't know how to connect to the server via an application, and when a certain message is received to alert the IP Running the server.
My Server Code is:
Dim serverSocket As New TcpListener(8888)
Dim clientSocket As TcpClient
Dim infiniteCounter As Integer
Dim counter As Integer
serverSocket.Start()
[Code] .....
Now I know that to connect you'd do something like
Code:
Dim clientSocket As New System.Net.Sockets.TcpClient()
Dim serverStream As NetworkStream
clientSocket.Connect("127.0.0.1", 8888)
serverStream = clientSocket.GetStream()
And I know I would have to use some sort of Byte() method to send/receive messages, but I am at a loss on how to set it all up.