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 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]...
I have a question. Is it possible to use VB to check wireless connection on a router? I was looking at my WIFI router and I am able to see my LAN connections and wireless clients. Then it hit me that if a router is able to do that can I write an application to do the same without entering the router administration. If possible the i would like to check the wireless connections and identify rougue connections or wireless clients not in my list of approval.( either hard coded or a xml file)
View 1 RepliesI have a Visual Studio 2008-SQL Server 2005 app that will be throwing alot at it. It's my testbed learning app. I'm also a student of this craft(43 years young) like another poster posted on another thread. I come from a PICK/BASIC jBase background. Anyway as-is my app has a connection to the database that is opened on form load. I close the connection on form close. It's a one form app currently. Is this wrong? It seems that maybe I should not have a connection opened possibly all day. I'm looking into incorporating Datasets, dataAdapters into my next phase of evolution. I looked at the material and it's tough. For me anyway. But I will get into it. I will fetch the data into a dataset so that I can keep the connection open only for a little while. I was turned on to this "keep the connection just as long as you need it" idea from someth
View 3 RepliesI am in the situation on preventing connection leaks. and one of the possible solutions is to make sure that all opened connections are closed after transaction. That means closing the sqldatareader too.
I am confused on the part of closing the sqldatareader. if the method that will be read by sqldatareader encounters error, it is not successfully initialize. If this happens, i will encounter an error once i close the sqldatareader. does it mean the most proper way of closing sqldatareader is like this?
[Code]...
show me the connectionString of Vb.net 2008 to Microsoft Sql server 2005?
View 1 RepliesI have just installed VB.NET 2003 and I am trying to manage some databases using SQL Server 2005 Express.When I try accessing the database via the data connection tab, I get the following message.
Quote: You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released before the version of SQL Server to which you are connected. For this reason, you might encounter problems.
Please check with Microsoft to see if there is a service pack that you should apply to Visual Studio or Office in order to get support for the version of SQL Server to which you are connected.You can continue but any new object types might not be enumerated, and it will not be possible to save any objects or database diagrams that you create using the Visual Database Tools.I can not add tables or manage data fields. Does anyone know how to get the patch referred to in the message above? I can not find it via google or this forum.
The current project that I'm working on is mainly employing a database back-end, and I have a few questions regarding database connections in .Net, before I actually convert.
For VB6, I connect to my databases using ADODB connections and recordsets in code only, and not by binding controls. I perform my queries using SQL statements..For differentations in the type of database, such as connecting to a MySql, a MsSql, or an access database, it was mainly the connection string that had to be changed.. and ofcourse installing the drivers.
Now for VB.Net, I believe this can be done using the System.Data assembly. While looking into it, I've seen that it has a lot of members, such as System.Data.Odbc, System.Data.OleDb, System.Data.SqlClient.
My question is, what is the main difference between those namespaces (just briefly)? I would like to generally understand the main differences before I start with anything. I have also heard about LINQ. It looked very alien to me in the MSDN library. (PS: what's the deal with Ado.Net?)
For years now I have been using access as my database. But with the SQL server Express version around I have been wondering if it is not better to use this instead of access. Note: I only develop applications for small businesses and a limited set of users. So what do you guys prefer and recommend?
View 2 RepliesI'm currently using SQL Server 2005 and I've created a business intelligence solution that has a "Package1" copying a table from a database to my local database. I tried executing this package/solution from my .Net IDE and it worked.
Later, I tried creating a job that will execute the package at the intervals of 1 hour per day using SQL Server Agent but when I get to the part where I select the type of job (under the "Job step property", I can't find the job type of "SQL Server Integration Services Package". I've been following this: http://www.mssqltips.com/tip.asp?tip=1180 tutorial but I can't execute my job probably because I'm using an incorrect job type.
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 am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 RepliesI 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 RepliesI 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.
I am still working on a POS application in VB.Net 2003. What I need to do is check the state of the cash drawer. I want to make sure the drawer is closed before a cashier is allowed to move on to the next sale. The cash drawer I am using is a MMF ECD200 (not sure if this will make a difference). Here is the code I am using to open the drawer:
[Code]...
I need to know if a form2 is already open when a button1 on form1 is clicked. I found the following code which fails when I open form2 then close form2. When I click button1 on form1 nothing happens. Is there a way to reset form2 to nothing or is this just wrong?
Sub isFormOpen()
If xmlTest Is Nothing Then
xmlTest.Show()
OpenXML(filename)
End If
End Subdavidbell
I am trying to save "Closed" when i click on check box [code]Conversion from string "TRUE" to type 'Double' is not valid.
View 10 RepliesI have create a simple app in vb.net that receive data from a bluetooth device ( data are simple strings like "90123.9mm"). Is there a way to check if the device has closed the connection ?
[Code]...
Every 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]...
How do you check if all instances of forms (or simply all forms of an application) has already been closed?
View 10 RepliesI 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 a small databse program. Form1 uses the Private Sub OpenToolstripmenu to Openfiledialog box and creates a connection and adapters. I need a second form that will access the same connections and adpaters what is the best /correct way to do this? Also other sub functions on form1
View 8 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 created a server-client application using the asynchronous socket. I found the problem when closing a socket on the server, applications so closed. The procedure that I do to close the socket server is:
Terminate the listening thread. Close the client socket is still connected to the server. Close the server socket.
How to prevent the application is closed, when I close the server socket?
Protected Friend Sub CloseServerSocket(ByVal IPAddress As IPAddress, ByVal socketPort As Integer)
' Terminate the listening thread.
[Code].....
I searched, I found another post, but didn't quite understand the answer... Here is what I am working with.I know the connection is good it does update it by 10 then give me the error...
I am using Visual Basic 6
Code:
Private Sub Form_Load()
Dim sql As String
sql = "select * from Stats ORDER BY Hours"
With ADO
[Code]...