What is the best way to centralize and secure the connections strings used by applications? In my environment we have many internal applications. Each application requires one or more connection strings in order to access the database. We have a goal of centralizing all these connection strings (particularly SQL logins and passwords) ...
Hi! We have a .NET object that does a lot of reading/writing with the database. Throughout the life cycle of this object (or the asp page that uses it), it may hit the database with a query/update anywhere from 1 to 10 times. Instead of opening and closing a database connection every time the object needs to hit the database, it simpl...
When using Castle ActiveRecord, is it possible to determine during runtime which connection string to use? As I understand it, ActiveRecord has to be initialized only once during the application's lifetime and this means that database connection strings have to be configured prior to initialization. However, is it still possible to det...
I have a multi-threaded program whereas each thread, at the start of execution, acquires a single connection from a MySql connection pool class. The thread then uses a number of database table wrapper classes to do its business logic by passing its database connection to the wrapper classes. The operations on these wrapper classes are no...
we have SAP Business One - Fourth Shift Edition running here at a small manufacturing company. The consulting company that has come in to do the installation/implementation uses the "sa" id/pass to initially connect to the database to get the list of companies. From then on, I have to assume that its the sa id/pass that is being used t...
Any simple, but secure script available for Flash > MySQL DB integration? I need something for a Login DB. Exchanging variables with PHP is nice and easy, but obviously insecure. via Remoting? I've got the Flash 8 remoting components installed, and some ideas: idea-1, idea-2. via NetConnection? Got some leads: lead-1, lead-2. Cold Fu...
I am using the Microsoft.Practices.EnterpriseLibrary Database tools and I'm having trouble creating a new database using just the connection string information. Ideally I would like to do the following: Database dbEngine = DatabaseFactory.CreateDatabase( "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SS...
lI am using the Data Application block for a majority of my data access, specifically using the SqlHelper class to call the ExecuteReader, ExecuteNonQuery, and like methods. Passing the connection string with each database call. How can I modify this to enable connection to a MySQL database as well. ...
One of our clients has an application (FoxPro 9) running on top of a SQL Server 2005 backend. Intermittently, they are losing their ODBC connection with the SQL Server database. Below is the intial error information: Err Msg: Connectivity error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). ODBC Err Msg: [Micros...
Here, it is said that Sql Server Compact allows up to 256 connections. But when I try to open 2 connections, I receive a file sharing error. How can I solve this? SqlCeConnection c1 = new SqlCeConnection("Data Source=testDB.sdf;Encrypt Database=True;Password=test;File Mode=shared read;Persist Security Info=False;"); SqlCeConnection c2 ...
I am interested in knowing how databases handle connections that are not explicitly closed by the entity that initiated the connection. Say I have a database that can accept only 2 concurrent connections at a time. I have a piece of code that opens a connection and never closes it. This piece of code runs forever, but it uses the conne...
I've installed an instance of SQL 2005 Express on <computername>/SQLEXPRESS. There is only once instance installed. I've allowed remote connections, turned on SQL authentication, enabled TCP/IP, Named Pipes and VIA but I still can't access the database from another computer. I keep getting: A network-related or instance-specific er...
I have a Java program consisting of about 15 methods. And, these methods get invoked very frequently during the exeuction of the program. At the moment, I am creating a new connection in every method and invoking statements on them (Database is setup on another machine on the network). What I would like to know is: Should I create only...
Is it possible to open a .mdf database file created in Visual Studio with some external SQL server IDE like Quest Toad for SQL server? Databases created in Visual Studio are rather similar to simple Access databases in that they're a single file. It appears external IDE's like Toad can't see the .mdf being served by my localhost's SQL ...
Currently the major means of connecting Flash AS2/AS3 to a MySQL database are: Flash > PHP > MySQL -- "secure code" in PHP Scripts Flash Asql or Assql > MySQL -- "secure code" in MySQL Stored Procedures The second approach is newer, but directly connects to a MySQL DB using binary sockets and ByteArrays. In which case would the "sec...
I'm about to begin my first project with java Let me tell how I used to handle these things... So far now, I've been workin on asp with a com+ componente made with VB6. The component is registered via the com+ administration console with a domain user, something lile my_company_domain\my_app_account The components reads the configura...
I have to develop a tool in C# that retrieves some data from an Oracle DB. Since our IT support is having some trouble with installing the Oracle client, I want to be able to connect to the database without the client installed. The idea is to just install (and maybe register) an additional library together with the app. Which alternati...
I am trying to delete an existing database in SQL Server 2005. My first attempt produced the following error: 5030: The database could not be exclusively locked to perform the operation. I have since killed all processes that are accessing the database. I have also removed the replication subscription that it had previously bee...
Hi Guys.I am trying to connect to a Sql Server in my apllication using the following code : SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = "Data Source = (local);Initial Catalag = Inventory; Persist Security Info = false; Integrated Secu...
php generates GIFs on the web server using a databases on a second server. The the page shows 20 GIFs, so there is some load for a short time (multiple connections) Some GIFs are loaded but some are not, in /var/www/logs/error_log [Mon Feb 23 10:05:56 2009] [error] PHP Warning: mysql_connect() [function.mysql-connect]: Lost connect...