My local newspaper's website recently rolled out a "DataMine" section of their website that has lots of great information I want to tap in to, but the results of a search are not too friendly to an inexperienced programmer myself. Does anyone out there have any experience with Caspio? Do you know if there are APIs I can hit? Does anyo...
If you sign up for the RIM developer alliance program, you have the special BIS-B connection type available to your Blackberry applications. Is this connection type more available, stable, and reliable than the other methods? We're connecting to web APIs, if that makes any difference. Getting the other methods (Direct TCP through APN ...
I've done extensive research on this topic and intensive discussions with my co-workers. The general consensus seems to be, that a database connection should be opend when needed and closed immediately. Any caching/pooling of connections should be done by the database driver or some other layer, but not by the application itself. But ...
What is connection() in the following code? Code which I do understand completely if($user->connection($email,$password)){ } Let's assume connection() is pseudo-code. Is the pg_prepare and pg_execute` enough to create the connection? The line caused me to omit the use of its main code in generating a login system. Subsequently, ...
I've set both Timeout and ReadWriteTimeout of HttpWebRequest, and still GetRequestStream does not time out when trying to connect to a non-existent server. I've run into similar problems in the past when the DNS resolution was struck, but this time the server in question is running on my own machine (localhost) so this not relevant. The...
I am trying to use some variables in a creation script for database setups. I am not exactly sure how to use them. Please explain how to properly format my code. Below is the code I try, and the error I get: SET @username = 'xxxx'; -- store number goes here SET @password = 'xxxxxx'; -- store password goes here CREATE TABLE IF NOT EXIST...
Hello, I would like to know how to do the next: I have one app that make some connections to receive datas (this datas are show in the screen) I would like to know wich code i can use to wait each connection, I mean, the time between the connection start and this finish i would like to show in the screen one spin (Loading...). I have ...
I'm writing new DB connection code, and thought I'd try proxool as the connection pool implementer. Normally, a programmer would ensure that every DriverManager.getConnection(...) is followed by a connection.close(). But when using Proxool, is the close needed? I'm confused because: a. The proxool documentation here (http://proxoo...
i m calling function "address = CFDataCreate(NULL, (uint8 *)&frameAddr, sizeof(frameAddr));" it runs fine 245 times but it cannot work after that gdb does not give any error can anyone helps me???? ...
Hi folks, I have a python application that opens a database connection that can hang online for an hours, but sometimes the database server reboots and while python still have the connection it won't work with OperationalError exception. So I'm looking for any reliable method to "ping" the database and know that connection is alive. I'...
I've got a small Windows network with 3 machines. One of them has SQL 2005 installed. As of last week, the other two machines have had no problems connecting to the SQL instance. Today, one machine - running Vista, if that matters - all of a sudden cannot connect. I get the generic message saying "A network-related or instance-specific ...
Hi. I have C# application and I'm using MySQL database. Everything seems to be fine except one thing. Our computer network is little bit unstable. When I'm trying to execute query and the computer simultaneously loses connection to the mysql server (I'm simulating this situation by unplugging the network cable from computer which is mys...
Hi, Can anybody help me how to create a socket connection using objective c which should remains always open. Also i need to send data to the server in particular time intervals. I followed the following article to create a socket connection. Stream Programming guide for cocoa Using this i created a socket connection and send the data s...
Hi, I'm trying to do a remote call to remote object running as part of a application installed in Websphere. The end solution will be RPG to local java cilent to call remote service that calls the webservice. This mainly so we have one set of code to call the webservice and doing the xml parsing, plus the iSeries doesn't have direct ac...
I use EntityFramework in a project to connect to a Mysql database. The provider is Devart Dot.connect. This application needs to connect to a database using connexion parameters given by the user at runtime. This includes of course the Mysql Database name. I used the EntityConnectionStringBuiler and EntityConnection classes to build-up...
I am facing an issue while executing queries.I use the same resultSet and statement for excecuting all the queries.Now I face an intermittent SQlException saying that connection is already closed.Now we have to either have separate resultSet for each query or have lock like structure.Can anyone tell which is better.I think introducing lo...
I am calling a WCF Web Service locally (or remotely) that is working fine with small amounts of data (about 25 lines of < 1K of data ea). But when the data gets larger (about 300 lines) the web service fails. Below is the Exception, Inner Exception, and Stack Trace from the Inner Exception. The service also seems to be taking unusually...
Hi, i have the next code: NSURL *url = [NSURL URLWithString:@"http:...."]; NSMutableURLRequest *theRequest = [NSMutableURLRequest requestWithURL:url]; NSString *msgLength = [NSString stringWithFormat:@"%d", [""soapMessage"" length]]; [theRequest addValue: @"text/xml; charset=utf-8" forHTTPHeaderField:@"Content-Type"]; [theRequest addVa...
I am using a class DBConnection which has a static method createConnection.I create a connection object like Connection con=DBConnection.createConnection(); I don't forget to close it along with statements and resultsets. Now how different is it having the same DBConnection having a normal method createConnection and create a new Con...
I downloaded MySql Connector/NET, and set it as a reference in my project. I added the using MySql.Data.MySqlClient; to my code. Now I tried initializing a connection like this: MySqlConnection test = new MySqlConnection(Utilities.GenerateMySqlConnectionString("localhost", "test", "root", "")); However I cannot use this object later....