Dear all; i want to check my server connection to know if its available or not to inform the user.. so how to send a pkg or msg to the server (it's not SQL server; it's a server contains some serviecs) ... thnx in adcvance .. ...
We have a client/server application that consists of multiple EXEs. The data access layer is on the same physical tier as the client in a library shared by our EXE modules. ODBC and OleDB connection pools are managed per-process; are there techniques for sharing DB connections across processes (other than moving the data access layer to ...
I seem to have an app on my Dev server that has lots of open connections (they should be there, but some bad data layer was used to open them, that forgot to close them). I just want them closed so I can keep other apps running on the server. How can I force all the connections to close? ...
I am looking to optimize a process that runs continually and makes frequent calls (> 1 per second on average) to an external API via a simple REST style HTTP post. One thing I've noticed is that currently, the HttpUrlConnection is created and closed for every API call, as per the following structure (non essential code and error handlin...
Steps: - Installed Mysql Server 2005 - Downloaded Mysql++, built both debug and release version. - Ran install.hta and selected a directory - Added library/include directory in MSVC++ 2008 - Included mysql++.h in my application - Moved .dll files (libMYSQL.dll and mysqlpp.dll and mysqlpp_d.dll) to Debug folder. Relevant code: #include...
I'm using an AMP server (Apache 1.3, MySQL 5.0, PHP 5.1.5) which I have found to only allow 1 connection/request per browser at one time. The easiest way to reporduce this is to request a large download which is passed through PHP and try to access another page at the same time. You will end up waiting for the first request (the file dow...
I have a Windows Forms application. When the user imports a license for my application I'd like to "phone home" (hit an aspx page on the web) and register the license information. The problem is that the user may not have an internet connection working at that moment. I'd like to test this first. What's the best way to detect if the use...
What is the recommended method for escaping variables before inserting them into the database in Java? As I understand, I can use PreparedStatement.setString() to escape the data, but PreparedStatement seems somewhat impractical if I don't plan to run the same query ever again.. Is there a better way to do it without preparing every que...
I am attempting to manage an ajax connection by calling a button onclick method on a separate web part in order to force the partial postback on the consumer. Web part A (Provider) invokes the method on Web Part B (Consumer) Web Part A Type t = myButton.GetType(); object[] p = new object[1]; p[0] = EventArgs....
I have client and server programs which now communicate via TCP. I'm trying out using POSIX message queues instead (in cases where the client and server are on the same machine, of course). My hope is that it will improve performance (specifically via reduced latency). I've worked out most of it, but am not sure about one thing: how t...
In developing a relatively simple web service, that takes the data provided by a post and records it in a database table, we're getting this error: Exception caught: The remote server returned an error: (500) Internal Server Er or. Stack trace: at System.Net.HttpWebRequest.GetResponse() on some servers, but no others. The ones that ...
For some reason every 3-5 days our web app loses the ability to open a connection to the db with the following error, the strange thing is that all we have to do is reboot the container (it is a VPS) and it is restored to normal functionality. Then a few days later or so it happens again. Has anyone ever had such a problem? I have notice...
I'm attempting to install a MYSQL driven .net application to a Windows XP sp2 machine. The development machine is the same OS. The application and all connectivity work fine on my machine (the developers mantra), but I receive the following error on the installation machine when attempting to connect to the database. As a side note, I ...
Hello, I'm changing our application from "one set of code & one database" to "one set of code to multiple databases (one database per customer)". The original code is VS2005 ASP.NET(VB) & lots of XSD's in a separate DLL. The web.config's ConnectionString would override the one stored in the DLL at runtime. Now I need to change the Con...
Hello, I am deploying a Windows Application that uses SQL Server 2005. The program will use SQL Authentication. My question is, how do you handle the connection string when you don't know what the username/password will be? Do you load this from an encrypted file? Or are there provisions for handling this already? ...
Hi, i have a web server with my web site and i try stress it but i 'don't be able. I think that the problem is limitated number of concurrent connection in xp(Pro). I wrote a simple client in C# for stress: ... for (int i = 0; i < _numThread; i++) { Thread t = new Thread(CallGetHttp); t.Start(); } ... private void CallGetHttp()...
I am using the current code in attempt to access a msSQL 2005 db: <?php $myServer = "[server]"; $myUser = "[username]"; $myPass = "[password]"; $myDB = "[db]"; //connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $s...
Is there a Firefox plugin available that will simulate various connection speeds (especially when testing from http://localhost)? I know there are standalone applications to do it, but I'd rather have a plugin. Thanks Edit: Thanks to @UselessAdmin - FirefoxThrottle has now been updated to work on localhost! ...
I have a method that uses a connection (e.g. a method that downloads a page). I have to execute this method multiple times (e.g. download 1000 pages). Doing it the synchronous and sequential way takes a long time. I have limited resources ( 8 max threads and/or 50 max simultaneous connections ) I want to use all resources to accelerate ...
I have create a getDBConnection method in my Java application. This returns a connection object, and hence I haven't closed this connection in this method itself. Now, I am invoking this method from various methods in my application at regular intervals, and closing them inside a try - finally block. I thought this should free up the c...