How to dynamically render the location of your DB file?

I have replaced the bottom line with the code that is in comments to make the location dynamic but it doesn't work. I have also changed the app.config file accordingly but still no hope. Could someone please guide me. // public string str = @"Data So

Is it necessary to deconstruct sql singleton connections?

Normally I'm using the statements: using (SqlConnection connection = new SqlConnection("Data ...")) { .... } to define areas where I use sql commands. Now for a specific application I'm considering putting the sql connection into a singleton ins

q Release of the debug console with time stamp

I wrote a qt small console utility for testing database connectivity, the code block is: db.setHostName("hostIP"); db.setDatabaseName("name"); db.setUserName("uid"); db.setPassword("pw"); db.setPort(1521); while(tru

remote data & amp; query OpenVMS RMS files

What options exist to query RMS files in OpenVMS? The context for the query/access would be for BI & reporting. Currently, a very old FOCUS (Infomation Builders, v. 6.9.8) is in use, and that only from within the native OpenVMS command line shell. My

Querying data from two databases on the same server

I'm writing a program in C# using Visual Studio 2010. I need to collect data from two tables which are in two different database. I'm using Microsoft SQL Server Management Studio to view the data. Both database are on the same server. I wrote a SQL q

Database unable to connect

I have a database project, Im trying to connect to database from netbeabs and I created a connection class which is ; public class Global { public static Connection createConnection() { Connection conn = null; System.out.println("Checking if Driver i

Problem of connection to the MySQL database phpMyAdmin

I'm pretty new at php and I'm getting an error whenever I try to load a php page that requires access to the database I set up on phpMyAdmin Here is the error: Database connection failed: Can't connect to local MySQL server through socket '/tmp/mysql

jdbc hive connection giving a memory error

I'm just trying to run a sample hivejdbc client program but it's giving me an out of memory error. import java.sql.SQLException; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import java.sql.DriverManager; public c

Using the connection closure to the database in php

I was always in assumption that it is always a good practice to close database connection, regardless of database/ORM, like mysql_close(), Propel::close() etc. With reference to one of my other question and some other research on Internet, I came to

Refresh LINQ object db-connection

My collegue helped me with starting programming in c# although I had no experience but I like it. All went well until I came across some problems we both can't fix. He uses SQL himself but started me up with LINQ. To do a LINQ-query I use this object

java.sql.SQLException: general error

Getting java.sql.SQLException java.sql.SQLException: General error at sun.jdbc.odbc.JdbcOdbc.createSQLException( at sun.jdbc.odbc.JdbcOdbc.standardError( at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(

2008 sql server connection

hey can someone tell me what is the problem here? SqlConnection sqlConn = new SqlConnection(); sqlConn.ConnectionString = "server=zekyakad-7727\\sqlexpress.master.dbo;database=master;"; sqlConn.Open(); //error line Error msg: A network-related o

Solving Base Performance Problems

I've a problem with database, and here is a scenario I'm dealing with every day: usually application can deal with traffic etc. but several times a day I'm dealing with performance issue. When it's happening stored procedures increase their execution

Best practices for connecting to a single user database

With MS Access single user, Is it good practice or okay to maintain a persistent connection throughout? psuedocode: app.start(); access.connect(); domanymanystuff(); access.disconnect(); app.exit(); --- OR ---- app.start(); access.connect(); doonetas

what kind of database are good for the arrays?

i want my database to support one company haveing many users how can i do that? example users table(UID,username,password) company table(CID,companyname,usersthatistheownerofthecompany) how can i do that? what should i do ? should i make an array in

Why are there open connections to my databases?

I have a program that stores user projects as databases. Naturally, the program should allow the user to create and delete the databases as they need to. When the program boots up, it looks for all the databases in a specific SQLServer instance that

How to execute queries on a DB connection in Rails?

I have certain initializing functions that I use to set up audit logging on the DB server side (ie, not rails) in PostgreSQL. At least one has to be issued (setting the current user) before inserting data into or updating any of the audited tables, o