NHibernate config connection string info
What's the best way to store connection string info? I'd rather not just store the db password in NHib.config file. ...
connection
What is the Recommended Ping and URL Connection Timeouts?
I am currently doing some network programming and had a couple questions concerning timeouts. Is there a recommended timeout in doing a ping? Also, is there a recommended timeout in doing a URL connection? Edit: In my case, with the ping, I am just trying to see if a device is connected to the network. With the URL connection, I am tr...
How to make a remote connection to a MySQL Database Server?
Hello: I am trying to connect to a MySQL database server (remote), but I can't. I am using an user with grant privileges (not root user). The error message is the following: Can't obtain database list from the server. Access denied for user 'myuser'@'mypcname' (using password: YES) "myuser" is an user I created with grant access. This...
The connection was reset
"The connection to the server was reset while the page was loading." Hi, I am trying to load a php page on apache , but none of the static content gets loaded. Using firebug I captured the static url and tried it separately, when I received "The connection was reset" message. The site works other computers mac, windows, linux but no o...
cant add a alertview to my webview
How can i add a uialert view giving a connection error when the iphone don't have a internet connections. All tutorials online does not work o a tab bar application!!! ...
php mysql database users connection handling
What is the best way to handle mysql database users connection in PHP? I have a web server running a PHP application on MySQL. I have created a database user for the application: dbuser1 with limited access - only for query, insert and update tables. No alter table. Now the question is, should i use the same dbuser1 widely in my script...
Django ORM leaves opened connections
I'm using django ORM with Postgres. After any operations with models (e.g. simple select) in postgres appears new opened connection in IDLE state. I've tried all possible transaction manipulations, I've tried calling connection.close() manually. All useless. And sooner or later, I'm recieveing "FATAL: connection limit exceeded for...
Oracle ALTER DATABASE OPEN
Hi everyone, Im having some trouble with an oracle database. Every time i try to connect, i get this message. ORA-01033: ORACLE initialization or shutdown in progress I searched the web, and found that the solution is to execute an alter database open command, but what I dont understand is where should i execute if, since I ca...
using BOSH/similar technique for existing application/system
We've an existing system which connects to the the back end via http (apache/ssl) and polls the server for new messages, needless to say we have scalability issues. I'm researching on removing this polling and have come across BOSH/XMPP but I'm not sure how we should take the BOSH technique (using long lived http connection). I've seen...
Java socketserver: How to handle many incoming connections?
I am writing a simple multithreaded socketserver and I am wondering how best to handle incoming connections: create a new thread for each new connection. The number of concurrent threads would be limited and waiting connections limited by specifying a backlog add all incoming connections into a queue and have a pool of worker threads...
Connection Multiplexing
Hi; Supposing we have opened a connection of type either TCP or UDP to another remote machine. Having this connection, can we allow multiple connections virtually over this connection like VPN(but not VPN)? I mean multiple applications run on remote machine and you try to access to these applications, is there any multiplexing mechanism ...
SQL connection to database repeating
ok now i am using the SQL database to get the values from different tables... so i make the connection and get the values like this: DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConfigurationManager.ConnectionStrings["XYZConnectionString"].Connectio...
Any gotchas in migrating database connectivity to DataSource?
Looking at some old application code which uses explicit driver loading as Class.forName(...).newInstance I have been told to change this to use the Java 1.4.2 mechanism to establish a database connection using ContextLookup, and DataSource. Are there any gotchas I should be aware of? ...
Excel data connection - remove header row?
The excel spreadsheet is connecting to SQL server 2005 using the connection string below: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=XXXXXX;Data Source=XXXXXX;Extended Properties="HDR=No";Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=XXXXXX;Use Encryption for...
C# TCP First Message Delay
greetings, i am writng a socket program using sockets in c# (asynchronous). the issue is, when a client connects to the server it kinda happens quiet fast. then.. when the first message is sent there is a delay in responding. this only happens to the very first data being sent over the connection. and boh client and server suffers fr...
NHibernate is not connecting to sql server.
When i set up a regular connection, it works, however when i try to use nhibernate, hibernate.cfg.xml, i m getting the following error. Message="A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and...
How do you find what class is keeping a network connection open?
I'm accessing a database in steps, and making sure that I dispose of all my DbConnection objects & related when I've done with them; however, when all the network stuff is done & should all be closed I still find open network connections from the app on netstat. How do I find out what class instance is keeping these connections open? ...
Object reference not set to an instance of an object Error
I'm trying to save text fields in MySql using NHibernate in Asp.Net frame work. But while executing this I got the error"Object reference not set to an instance of an object". If anyone knew help me... Here is the code. if (!Page.IsPostBack) { IList siteList; ISessionFactory factory = new NHibernate.Cfg.Configuration().Configur...
Cakephp - detect if unable to connect to database and recover gracefully
I have a few sites built with Cakephp. If any of these sites lose their connection to the database for whatever reason it does not handle it well. Basically it renders itself inside itself trying to display an error over and over until the browser crashes. The rendering itself inside itself is caused by the use of requestAction from elem...
How can I programmatically determine (in Python) when someone connects into my windows 7 machine via RDP?
This doesn't need to be a real time solution, but are there some log files or system messages that could be read to identify periods of time where someone was connected via RDP to a Windows 7 machine? I'm building a watchdog script for a computer which will be deployed in a remote place and would like to add this metric to a daily statu...