I am running a client/server application. I use a textbox to let the user type in the IP address and port. I try to connect to the server, using 127.0.0.1 and there is no problem. After that I tried using 192.168.2.102 (NAT ip address of this computer), and it fails. Any idea why? the code I am using is: (this the the part that connects...
Is there some hack to create a wrapper for java.sql.Connection which works with JDBC 3 and 4 (Sun added a couple of methods and new types to the interface for JDBC 4) without resorting to something which patches the source at compile time? My use case is that I need to generate a library which works with Java 5 and 6 and I'd really like...
If I can ping my DB server, is my SQL Server connection guaranteed to work? I am using a default connection string in my code. My program runs fine locally but overseas sites are having issues and I am wondering if SQL might be using a TCP or UDP port that is still blocked. Here is the connection string "Data Source=xxxx.xxxx.com; Initi...
Currently we are restoring MySQL connections in a $_SESSION in order to save round trip time to set up connection to MySQL, but the problem is that the number of connections exceed the limit quickly, so what's your guys' solution? Do you create a new connection each time,and close that connection after using,or like me,restore it? ...
Hi, I was wondering (and used Google with no clear result) if there is any way to connect to a MySQL database with PHP using a hashed password. Say I have the following: Password (plain): 'foobar' Password (sha1): '8843d7f92416211de9ebb963ff4ce28125932878' Now I would like to connect to MySQL like this (using the mysql_* function as ...
I have a Drupal site on a shared web host, and it's getting a lot of connection errors. It's the first time I have seen so many connection timeout errors on a server. I'm thinking it's something in the configuration settings. Non-drupal parts of the site are not giving as many connection errors. Since this hosting provider doesn't give...
Hello, I would like to know how to explicitly set a timeout for the Ruby DBI ODBC driver, when connecting to SQL Server. I would like long running queries to simply timeout and cancel themselves, saving further server resources and Rails processes. This was happening while we were using the ADO based Ruby driver, but now that we've sw...
We are having repeated failures of our Application running on Jbos 4.05, mysql 5.083. Server works great for about 6 hours using no more then 10 connections to the mysql. Then suddenly get errors like:b. Looks like server attempts to open more connections, mysql connection peak at about 150 and then the server just hangs and looks like a...
I'm having an issue connecting to some PC on the network via WMI, psexec, even Computer Management. I would like to know what is prevening prevent a remote connect. Say I have 10 pcs on a network, i can remote to 7 and not the other 3 on the same subnet. I have looked at Personal Firewalls, Windows Firewall, account on adminstrators gro...
Hi, In my app I have connections with a web service and I would like to create a loading view to show each time the connection starts until it returns a response. Where is the best place to put this view in my application and what is the best way to implement it? Thanks, Fermin ...
Hello, I would like to ask you how can i implement the next: I have a tabBar where each tab make one different connection to one web service, and should show a different data. I would like to save this data "somewhere" and from it place load the different tabs. Where i should save this received data? Thank you, Best regards ...
I have a machine running a java app talking to a mysql instance running on the same instance. the app uses jdbc4 drivers from mysql. I keep getting com.mysql.jdbc.exceptions.jdbc4.CommunicationsException at random times. Here is the whole message. Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.ex...
I have an Ldap client and server running . The client creates Ldap connection and waits for 120 seconds. During this time , I will kill the ldap server and again restart it . When the Ldap client wakes up from sleep 120, it will still think the connection to LDAP server is valid and sends the query to server. Because Server does not kn...
I am having to work in classic ASP for a small job. I am trying to get the site running on my computer to test. I am running Windows 7 and IIS 7. I get an error when running from local host and on checking the logs I get the error: 80004005 | Could_not_find_file_'c:\inetpub\wwwroot\sc\website\data\si.mdb' My code is like so dim objCon...
Hi i want to know how to enable remote server connection in sql server 2000. I have sql server 2000 installed in a system with windows server 2003 os. i want to create a dsn connection to the database through remote. I have created a dsn locally in the server it is working. but how to create dsn from the remote system and make it work. ...
my application shows this error asm CPSqliteConnectionStatementForSQL 0x30897lb3:10 and it stopped at this breakpoint in debugger 0x308971cb <+0024> mov 0x8(%edi),%eax does someone know about it? ...
I have several nodes acting as both servers and clients using Java's TCP sockets, i.e., Socket and ServerSocket. Each node uses persistent connections to communicate with 4 to 10 neighbors. However, sometimes a node (node1) may throw the following exception when trying to connect to another node (node2): java.net.ConnectException: Conne...
Hey everyone, I am using MySQL 5.0 for a site that is hosted by GoDaddy (linux). I was doing some testing on my web app, and suddenly I noticed that the pages were refreshing really slowly. Finally, after a long wait, I got to a page that said something along the lines of "MySQL Error, Too many connections...", and it pointed to my co...
I've got a WPF application that uses LINQ to SQL DataContexts. The first call to the database would be from the ObjectDataProvider in the XAML of the main form: <ObjectDataProvider x:Key="WaitingPatientDS" ObjectType="{x:Type local:clsPatients}"> <ObjectDataProvider.ConstructorParameters> <sys:Boolean>True</sys:Boolean> ...
Hi folks, I'm trying to implement persistent database connection pool with django. One of the options is to use built in psycopg2.pool code which provide different types of pools (PersistentConnectionPool, ThreadedConnectionPool etc ), but there is no psycopg2 documentation on that topic. So, do anyone done any work in this direction ...