Hi, For a school project, I have installed MediaWiki on my local machine, and am required to have any database connection to the local MySQL database use SSL. I am unsure of how to connect all the dots. Here's what I have done so far: I have installed OpenSSL, and created a self-signed certificate, and associated keys. phpinfo() sho...
I've seen a lot of discussion about this subject on here. If i have a static class w/ static methods that connects to a database or a server, is it a bad idea to use this in a multi-user environment (like a web page)? Would this make a new user's tread wait for previous users' threads to finish their calls before accepting a new one? ...
I have MySQL installed on a Windows 2003 server on our domain. I cannot connect to it from other machines on the domain. I open up the MySQL Administrator panel and try to change the server name from localhost to the machine name it does not recognize it. I have tried fully qualifying the name also. Any ideas what I need to change? ...
Here's my proposed (very simplified to illustrate the problem space) design for a C# console application. The database connections implement IDisposable, and this solution doesn't allow for using the database connection objects. Can someone propose a more correct structure for a console application? This is a problem I need to solve ...
Hi, I'm trying to use to different methods of connecting to a database to edit data, the declaration below is working: Dim rsConn As ADODB.Connection rsConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _ & Application.StartupPath & "\VFMS_DB.mdb;" _ & "Jet OLEDB:System Database=Security.mdw", "Ads", "1234") but now I want t...
Hello. I've recently inherited a database driven e-commerce site written in C# ASP.Net, with an MS SQL database. I have had little or no experience with this exact type of application up to this point, although I am comfortable exploring code, and am familiar with SQL query structure and C# (and web mark-up languages too). So far I've be...
I am writing a code in python in which I established a connection with database.I have queries in a loop.While queries being executed in the loop ,If i unplug the network cable it should stop with an exception.But this not happens ,When i again plug yhe network cabe after 2 minutes it starts again from where it ended.I am using linux and...
MSSQL Server is in the "abc" domain and have mixed mode authentication. I am connecting from the machine which is not in domain or in a domain "xyz" but with in the same network using MSSQL Jdbc driver 2.0. I have logged in as admin or account in xyz domain. It works fine using following url for connection for "sa" or SQL Mode Authentic...
For compliance reasons, my organization is looking to take our database connection settings out of properties/XML config files and into a central registry - ideally federated over multiple physical machines, to avoid a single point of failure. I have been looking at the possibility of using JNDI to achieve this, but haven't really got m...
I was wondering if there is a way to access a database service on a remote computer without having a webserver installed on that computer? Does MYSQL DBMS provide some interface (port) which can be connected directly to, or is a webserver (that forwards the communication) mandatory? ...
Single-threaded version description: Program gathers a list of questions. For each question, get model answers, and run each one through a scoring module. Scoring module makes a number of (read-only) database queries. Serial processing, single database connection. I decided to multi-thread the above described program by splittin...
What is the maximum number of connections to SQL Server 2005 for one user? I'm having a problem with C# code trying to make multiple connection to the database in different threads. After about five threads the connections in other threads start timing out. If i knew the exact number of connection for one user, even if it was one, wou...
I am able to connect to an Oracle database using several tools, but am unable to connect using Toad for Oracle 8.5.3 (though before a login/logout to Windows I was able to). I am not using TNSNAMES.ORA to connect. I have two Oracle homes: C:\Oracle\product\10.2.0\client_1 (OraClient10g_home1) and C:\Oracle\product\10.2.0\client_...
Hi, How do table adapters make use of connections? To explain that a bit, do they automatically open and shut connections or if I already have the connection open before calling a tableadapter method, do they use it and leave it open? Regards ...
In Java and C#, they both have something like System.terminate(). If my program has open database connections, database readers, and database command variables, and I terminate my program in a catch clause, will database resources still remain in use? or will they be freed automatically since my entire program has just exited? Normally,...
I am running a Rails app so now I am trying to remote connect to mysql and I am getting this error Could not connect: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 ...
Hi All, I'm having a slight issue with one of my Rails models. It's nothing I can't work around (as I've already done so), but I'm interested in the actual issue. Basically, I have an ActiveRecord-based class named "Events" that I've connected to a remote database using "establish_connection". It all works fine and I can even perform...
In MS SQL Server, the Database Properties dialog has the "View Connection Properties" link over on the left. Clicking that brings the "Connection Properties" dialog with properties of the current connection, such as Authentication Method, Network Protocol, Computer Name, etc... Is there a way to get that information programmatically by ...
I have a program in which I need to run multiple insert statements (dynamically generated) against a MS SQL Table. Right now, I do (pseudo-code): Loop Generate Insert Statement String SQLCommand.Text = Generated Insert Statement String SQLCommand.Execute(). End Loop Close Connection Is it better performance-wise to simply construct o...