hi i use sqlite database on my iphone app and i need to update this database from the internet from my server how i can download the new database and delete the old database and recopy the new database to document directory ...
Hi, guys. I seem to have an issue with connecting to an embedded FireBird database from a sample C# app. Here's what I've got. static void Main(string[] args) { //Some constant parameters used to form up the connection string... #region constant literals const String User = "SYSDBA"; const String ...
Context: ASP.NET MVC 2.0, C# At the moment I use following pattern: using (var db = new MyDatabaseDataContext()) { var model = new MyPageModel(); model.player = db.blah.blah.blah; model.info = db.blah.blah.blah; model.bossKillCount = db.blah.blah.blah; } It works fine, one problem is that I have to redefine those mod...
I am writing a driver to act as a wrapper around two separate MySQL connections (to distributed databases). Basically, the goal is to enable interaction with my driver for all applications instead of requiring the application to sort out which database holds the desired data. Most of the code for this is in place, but I'm having a prob...
Does the following code leave the connection open if there is an exception? I am using a Microsoft SQL compact edition database. try { SqlCeConnection conn = new SqlCeConnection(ConnectionString); conn.Open(); using (SqlCeCommand cmd = new SqlCeCommand("SELECT stuff FROM SomeTable", conn)) { // do some s...
This is a simple database security & performance question, but I've always used either a special user (eg. mydbuser), or Windows' built-in Network Service account as the owner when attaching databases to my SQL Server instances. When deploying my database to a production server, is there a specific user I should stick to or avoid? I w...
Hows does Drupal 6 interact with MySQL for connections and transactions? Does connection pooling get used? How are transactions handled? At what level are these things managed by Drupal vs being handed off to be handled by MySQL? I did a good amount of searching on the web and within Stack Overflow, but mainly, I only found articles ...
My program has been working for a long time. After trying to use SMO in my program to do a database restore I can no longer attach my database to my named instance. I keep getting the following: "Cannot open user default database. Login failed.\r\nLogin failed for user ...". At first I could not attach to it in Management Studio eith...
I am trying to Query a remote Oracle database from Windows Server(production environment) through a .net app. I keep getting this exception. I have Oracle XE client installed on the system. I tried to install Oracle 64 bit connectors but the jvm won't allow me to do so. Exception: System.BadImageFormatException: An attempt was made to lo...
Does the database connection have to be set inside a TransactionScope? Or can I set it in the ctor and then have instance methods create up a TransactionScope? EDIT: e.g. Public Sub New() Dim conn = new SqlConnection(...connection string) Public Sub SomeClassMethod() using ts as new TransactionScope //conn has already b...
My app is a very complex game that uses json objects to store its execution state (aka save games). I'm looking for a nice database script that can talk json and interact with javascript via ajax. ...
Hello all, I have a form that has text boxes, buttons on it for the user to sign up and sign in. I need to store the entered sign up credentials in any database(Oracle, Service based database, local database). Then when he tries to sign in, entered credentials should be compared with stored sign up values for authentication. This is do...
Hi all, I want to make something like http://www.djangosnippets.org/accounts/register/ using django..the register form. I am new to django. i have made a simple view form using django forms but unable o understand how to connect my form to a database. Im using postgresql. is there an easy way to use some snippet or script to achieve thi...
Now i get the problem at the try statement ( int count =insert.......). The compailer says(when i push the buton on the form to save the values in textboxes) that it Failed to convert parameter value from a String to a Int32. code: private void button1_Click(object sender, EventArgs e) { string conString = "Provider=Mic...
Background School Corp. has two databases with a common table, employees. These two databases are located at the company's offices in New York and Atlanta. Client computers connect to the databases to make changes. If employees join at the New York office, the information pertaining to them should be available at the Atlanta office as we...
I just finished my first PHP site and now I have a security-related question. I used PEAR:DB for the database connection and made a separate parameter file for it. How should I hide this parameter file? I found a guide (http://www.kitebird.com/articles/peardb.html) that says: Another way to specify connection parameters is to put ...
Hi Guys What application should I use that is able to automatically access a website to gather information? Basically I have a database that completes calculations for me; however I have to manually gather the parameters from a website and input these into my database. What I would like is have an application that will take my input sa...
Hi , I have a problem connecting to my db on a shared hosting. My host provider says they deployed SQL 2005 express on their database and I prepared my connection string as follows to take advantage of sql express. <add name="PMIS_DBConnectionString" connectionString="Server=localhost;AttachDBFilename=|DataDirectory|PMIS_DB.mdf;Databas...
Hi, I'm having trouble making a secondary MySQL connection (to a separate, external DB) in my code. It works fine in PHP 5.2.9 but fails to connect in PHP 5.3.0. I'm aware of (at least some) of the changes needed to make successful MySQL connections in the newer version of PHP, and have succeeded before, so I'm not sure why it isn't wor...
I want to prevent database connection being open as much as possible, because this code will run on an intensive used server and people here already told me database connections should always be closed as soon as possible. def do_something_that_needs_database (): dbConnection = MySQLdb.connect(host=args['database_host'], user=args['...