I have a new VPS server, and I'm trying to get it to connect to another server at the same ISP. When I connect via mysql's command line tool, the connection is very fast. When I use PHP to connect to the remote DB, the connection time may take up to 5 seconds. Queries after this are executed quickly. This is not limited to mysql, usi...
When I connect to the SQL Server 2008 remotely it only works once, after that the server hangs. The service cannot be stopped or restarted and when trying to connect again it gives a 'Timeout' error. The server has TCP/IP connections enabled. The default port is set to 1433 and I cleared the 0 from the dynamic ports. I enabled the 127.0...
I'm using PHP with MySQL database. The PCs are having a network to each other. My problem is I want to connect to the MySQL database on another computer. I want to store data on that MySQL database from another computer. How could i possibly do on this? Thanks so much for any suggestions. ...
In c# when I use the code : public System.IAsyncResult BeginConnect(System.Net.EndPoint remoteEP, System.AsyncCallback callback, object state) I declare the EndPoint with the ip-address of the remote host am communicating with and a port number. In this case the port number represents a port on my system or on the remote host?? ...
When I publish my project clients will need to be able to setup the initial configuration, and part of that is the Sql Database Connection. I have an instance of Sql Server 2008 running on my system (MSSQLSERVER2008) as well as SQLEXPRESS2005. I am trying to use the following connection string locally just to see if this works, and I can...
I have a stored procedure that runs against a local database, and fills a temp table. I'd then like to connect to a remote database and query it based on the values of the local temptables. Is that possible? Thanks. ...
I'm usind db2 8. Try to connect to the database (on the remotee computer, using vpn). While connecting I have an error: SQL0332N There is no available conversion for the source code page "1251" to the target code page "UNKNOWN". Reason Code "1". SQLSTATE=57017 I tried to set DISABLEUNICODE=1 in db2cli.ini, and aslo tried to set db2...
Hello there, I am having some problems with user authentications, I want the authentication through command prompt when user accesses it. I'm opening session with libssh2_session_init(). Then, i'm using libssh2_userauth_keyboard_interactive() to enable user to input password at command prompt. You can check the code at http://www.lib...
I have a sql server on a dedicated machine, running SQL 2008. I have the IP of the box, a database setup on it. I've built a small script that just does a connection test, and when I run it, I get the following error. Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture...
Hi, I installed oracle-xe into my virtual box that running with Fedora 13 successfully. Although I can ping my virtual machine, I can not connect the database from outside the box. Do I have to make some changes on tnsnames.ora or can I use another connection type for this situation? I would be greatly appreciated if someone be able to ...
How to connect to MySQl db on linux server using toad? what i should give on host? i get the error Can't connect to MySQL server on 'tinywall' (10061) ...
Ok, so I have the correct username / pass for a remote host, and I have a NSURL Object referring to the file on the server. How can I possibly write data to that server via Objective-C? I cannot find anyone with this problem, so you help would be greatly appreciated! ...