.net Application SQL Connection Bottleneck?
Jun 23, 2011
I have a vb.net application that uses a SQL connection to connect to a SQL Server 2008 R2 database. Periodically, users will complain that certain functions in the appliction run slow. This morning a user called while the performance issue was happening. I stepped through the vb code and found it slowed down calling a stored procedure that returned only 1 row. When I executed the stored procedure from SQL Server Management Studio, it returned the row instantly, as expected, but as I stepped through the vb code, it took about 5 seconds for the data adapter to fill the dataset. This performance issue continued in the vb application, but never occurred when executing the procedure from management studio. After 30 minutes or so of me searching for clues, the vb app performance returned to normal and the dataset was filled instantly. What could cause this sort of performance issue that affects the vb app going to the sql server but not going directly to management studio?
View 6 Replies
ADVERTISEMENT
Jan 27, 2012
SQL connection - I planned to create one sql connection object inside my own singleton class (say connectionmanager with Reference counting for 'SQL connection object' which is a member of the class) and open/close the connection whenever needed. As I like to give high importance for performance. And my application is a desktop based application accessing a remote database server (SQL server 2008), and will use only one connection string, 50 concurrent desktop users may access db server. Please advice.
As like many articles say if the answer is "Connection pooling is taken care by ado.net" - Does that mean that scope of connection pool is entire life of Application instance? Or is it in the scope of SQLConnection object?
View 2 Replies
May 2, 2012
I used to work only with asp.net websites before. I know that in ASP.NET website, the connection string is found in the web.config file. My problem is now I have started working with VB.NET applications which needed to be interfaced to a database. How is a connection string created and where should I put it?
[Code]....
View 4 Replies
Dec 5, 2009
When I try to make a connection to a db from a service application I get that "Name Application is not declared"
con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "
emoteit.accdb;Persist Security Info=False;"
Is this part of Windows.form only?
View 1 Replies
Mar 17, 2009
what would be the best way to manage a connection to a database in asp.net.My application is built using an N-Tier architecture.The DAL consists of static classes with methods such as
Public Shared Sub Delete( _
ByVal connection As MyConnectionClass, _
ByVal contact_id As Integer, _
ByVal contact_timestamp As Date _
[code]....
The point to note here, is that I pass the connection to the DAL from the BLL.Should I create the connections in the MasterPage, store it in an object, then pass it to my business objects as I create them (the thing I'm trying to avoid)Should I create a connection using a static class and calling a method like CreateConnection on it, from the constructor of my business objects (Something I'd like, but I don't want to have a connection per object, I'd like it to be shared for all instances of my objects, but since asp.net is multi-threaded, a static class doesn't make sense to store connections) the solution should also work well in a Windows Forms environment (So no connection storing in session, and retrieving it with a static method in a class, for the current context)?
View 1 Replies
May 1, 2009
is there a way I can proxify my application's connection to the internet??
I want it to be able to select a random proxy from a list of proxy IP address in a text file.
View 1 Replies
Dec 3, 2009
I'm having a problem with some users, my vb tools always check at the splash screen a response from a server with a simple:
Dim MyResult as string = oWebclient.DownloadString("www.mydomain.com/page.php")
This actually works for most users but in some clients the firewalls I think they block this call or bypass or something like that, I found that after telling the user to turn off the firewall everything works ok, now I have some users that according to them they don't have a firewall or they already disable and still they have the problem.
You can see from the image the error message they receive, so my question is do you know any kind of free tool that I can send to the user to maybe log what program or whatever is blocking the program to connect?
View 6 Replies
Jan 14, 2010
I'm trying to give my users the option to move their database to a different location, currently the datasource is set as an (Application Connection String) in the Project Settings, I know that when the scope is set to "Application" it cannot be modified but I'd like to know if there's a way for me to edit the location through code of my database in the application settings without crashing the program, can this be done? The purpose is to give whoever uses my application the freedom to choose where the database should be.
View 3 Replies
May 4, 2009
is there a way I can proxify my application's connection to the internet??I came accross System.Net.WebProxy. Here is what I have with it so far:
Dim pr As New System.Net.WebProxy(proxy)Can I set the value of proxy to equal something like 127.0.1.2:80 or do I need to split it into the address and port?Also how do I force my application to connect to the internet through that proxy? Because this is ithe part that is really baffeling me.
View 4 Replies
Dec 1, 2011
I am developing an .net Winforms application and I need to secure the connection to the sql server 2008 database. I plan to create a webservice as a middle tier that will handle the authentication and that will provide data manipulation. Is there a better way to go with? Does .net have components or tools for that? What is the best technique?
View 2 Replies
Mar 26, 2010
<Visual Studio 2008(VB.Net) + SQL server 2005>
I have an application for HR and I am trying to give feedback to users on login window wheather it is connected network and database.
View 16 Replies
Feb 15, 2012
I've been Searching the Net for hours now, and i can't really seem to find anything clear and straight to the point.
I need to create a Server/Client application using VB.net 2008, it's actually my first time to have a database on another computer. So I first searched the internet for the things i need to make this software.
[code]...
View 5 Replies
May 19, 2011
I made a desktop application and I Have a server on the internet and I need to make a connection between them
Can some one advise me about this problem?
View 3 Replies
May 5, 2012
I want to create a client-server application, it means I just need 1 database on the server.I have a computer and a laptop. I set my laptop's IP to 192.168.1.1 and my computer's IP to 192.168.1.2.Now I place the database on my computer, the database name is db_transportasi.Problem is, how to connect my computer's database from my laptopSpecification :I'm using this string below for my connection :Data Source=ARVID-THEODORUSSQLEXPRESS;Initial Catalog=DB_TRANSPORTASI;Integrated Security=TrueI already setup my SQL Configuration Manager, enabled the TCP/IP, switch to the IP Addresses tab and set the IPAII Port Properties to 2301I turned off my firewall so I don't have to set any exceptionQuestion
View 4 Replies
Jul 16, 2011
I am trying to understand how a connection string obtains its value in a vb.net 2008 application. By stepping through code,I found that a connection string obtained its value from the following line of code:
RemotingConfiguration.Configure("Useall.Desktop.exe.config", false);
By doing a search on the .net application, I found the Useall.Desktop.exe.config file in the bin/debug folder of the application.Thus I am wondering if the connection string information is initally obtained from the Useall.Desktop.exe.config file or would it obtain its inital values from an app.debug.config file?Would you explain the .net remoting and configuration manager interdependency to me? If they are separate items?
View 6 Replies
Jul 9, 2009
Is there a way that we can use that Add data source wizard that is in vs to our own apps?
View 2 Replies
Jun 8, 2012
I am developing an application on VB.NET 2010, I am planning to make an online activation system, the idea behind is that Whenever someone installs my application, the application presents user an activation form, user will be entering product key, name and email address, and then system will establish a connection to a database which contains all the keys on WEB. So how should I make an efficient program to get rid of that.
View 2 Replies
Apr 22, 2010
3 years ago I developed a vb.net application that connect to sql express 2005 data base.The application worked fine.e replaced our computers, so we installed the application again. (The same exe file, the same sql server and so on).Now, only when loading few forms I receive the following message: n error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Note that when we log in to the application, a connection is needed. The user verifying is working fine; it means that the connection is working properly.
View 1 Replies
Nov 21, 2009
I'm starting using a project for smart device in windows CE 5. I'm using visual basic of v. studio 2008.I need to create a dynamic connection between a PDA (codebar lector) and an server with ORACLE 9i. The PDA connected via WIFI. But in my vb project I don't find OLEDB or ODBC elements.
View 2 Replies
Jun 18, 2012
how to hard code my database connect to my application . Example, i want to connect to my application using[code...]
View 3 Replies
Jul 16, 2011
I am trying to understand how a connection string obtains its value in a VB.net 2008 application. By stepping through code,I found that a connection string obtained its value from the following line of code:
RemotingConfiguration.Configure("Useall.Desktop.exe.config", false)
By doing a search on the .net application, I found the Useall.Desktop.exe.config file in the bin/debug folder of the application. Thus I am wondering if the connection string information is initally obtained from the Useall.Desktop.exe.config file or would it obtain its inital values from an app.debug.config file?
View 2 Replies
Nov 11, 2010
I am using VB 2008 & MS Access 2007 Databases for my Windows Forms Applications.The Problem is my Connection strings have been disappeared from DataSource Configuration Wizards & now i am unable to edit any Connection String in DataSet Designer.I had tried to create a Macro in MS Access Data File but didn't know how to create & so desided not to save any & just quit from Access and came back to Visual studio. Since then only this prob. has started. Earlier to this everything was just fine.I have tried to uninstall MS Office as well as Visual Studio then Re-installed Visual Studio but the problem is still there.
1] Error while trying to Reconfigure Data Adapter in Dataset
2] Disappeared options & Empty Connection Combo Box
3] Add Connection DialogBox with no DataSource property line in the Grid control
View 2 Replies
Jun 11, 2012
I have a VB.NET application that used LINQ To SQL. Right now, I am using a single server and it is working properly. My problem right now is that my application will be used in another branch and with another server. I have to make the application able to change the connection string according to their server IP
View 1 Replies
Sep 18, 2009
I am doing a project on window application but the problem is that I want to connect the connection of database to the SQL Server database. Does anyone knows the connection strings of the connection.
View 10 Replies
Dec 22, 2011
Should I open a connection to MySQL at the load of my application and close it when you exit or should I open and close the connection only when I need to run queries?
View 1 Replies
Dec 27, 2011
I am building a database application using MYSQL as the backend. The MYSQL instance will be installed remotely on a share host. I have access to SSL certificates. I'm obviously not looking for any code but, conceptually, how do I go about securing the connection using SSL between my application and the remote MYSQL database?
View 2 Replies
Jan 20, 2012
I have set the connection string of my dataset(typed) asData Source=MyHomeServerSQLEXPRESS;Initial Catalog=dbTestSharing;Integrated Security=TrueThis is going to be a client side application. I need to change the machinename in the connection string so it could connect with server.
View 1 Replies
Sep 16, 2009
i was using a pocketpc phone and i want to have a program it with a database.i am not familiar w/ the database of vs 2k8 because it was using a dataset i i dnt know how to connect the database of that...
View 2 Replies
Jun 7, 2012
I have an application that I made in VB.NET. I put it in the server on my office and every other user access it via network connection. I only mapped the drive onto their computer and then I cope the shortcut to the application. can I close all the application that is running with a single code? I sometime need to close all the application first before I can do anything with the application (for example, modifying the report etc.). My current method is still the manual one, which is calling everyone to close their application or running all over the place closing the application myself.
View 1 Replies
Sep 20, 2010
I'm using vs2010 and can't get this to work. The same code has worked in earlier versions. What has changed?
config file:
<appSettings>
<add key="ConnectionString" value="Data Source=MikeLaptop;Initial Catalog=AdventureWorksDW2008R2;Integrated Security=True"/>
</appSettings>
Code:
Dim strProvider As String = ConfigurationManager.AppSettings("ConnectionString")
strProvider is always = nothing
How to do this now?
View 6 Replies
