current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

A database connection is a facility that allows client software to communicate with database server software, whether on the same machine or not. A connection is required to send commands and receive answers.

learn more… | top users | synonyms

0
votes
0answers
2 views

Cannot connect IBM data studio with DB2 Express-C (Error: User Id Revoked)

I have installed following software in the order: 1. IBM DB2 Express C version 10.5.1 2. IBM Data Studio version 4.1.0.1 I am having local admin rights. I have installed both above software using my ...
0
votes
0answers
21 views

Kill all connection to database using c# code

I am trying to restore my database using c# code ,So i googled and i found this link : http://www.codeproject.com/Articles/123441/SQL-Server-Backup-and-Restore-Databases-using The backUp part works ...
0
votes
2answers
22 views

JDBC driver - ClassNotFoundException, NetBeans

I've searched a lot and spent many time trying register JDBC driver. First, I copied my ojdbc7.jar file (downloaded from Oracle) into directory shown below: Driver File(s): ...
-3
votes
0answers
17 views

No Database Selected- Please Help me [on hold]

No database selected i Have connection to database $HostName = "localhost"; $UserName = "root"; $Password = ""; $Database = "dbCMSPortal"; $LinkSQL = new mysqli($HostName, $UserName, ...
0
votes
0answers
25 views

How to use JdbcInterceptor to retry queries

I want to retry MySql queries in cases of deadlock which will be removed if I can simply retry. I use apache tomcat jdbc pool library for mysql connection pooling and it has concept of ...
0
votes
0answers
13 views

System.Data.SqlClient.SqlException: Cannot open database “user_auth.mdf” requested by the login. The login failed. Login failed for user 'web_user'

I am trying to deploy my first VB.NET application on GODADDY. I created a SQL Server database and was able to create tables using SQL Server Management Studio. I created a user web_user and was able ...
-1
votes
1answer
19 views

Java Database Connectivity doesn't work

I have problem to connect to my Database from my Java Code. I am using MS Access Database. I have created DSR Name and selected appropriate Database for my DSR Name. DSR Name : connectionExample ...
0
votes
0answers
12 views

At least one JAR was scanned for TLDs yet contained no TLDs whilst creating database connectivity

<%@ page language="java" contentType="text/html; charset=US-ASCII" pageEncoding="US-ASCII"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib prefix="sql" ...
0
votes
0answers
25 views

RoR: 'NameError Exception: uninitialized constant Address' when trying to access recently added data from a populated postgresql table

I have created a Ruby script that inserts data into a PostgreSQL database. The db exists and so do the tables. I have an Address model and a Company model in my app and those two are connected ...
0
votes
1answer
33 views

Access 2010 VBA - DAO Database connection “Operation is not supported for this type of object”

I'm really stuck. My coworkers and I cannot figure out why this database won't connect to "CurrentDb". Here's my code: Dim db As Database, rs As DAO.Recordset Dim strSQL As String, strRowSource As ...
2
votes
0answers
18 views

Mule DB connector throws error: null (java.lang.NullPointerException). Message payload is of type: String

I just started with Mule, after working with OSB for months. I'm trying to use a database connector to select data from my postgres DB. The test connection says it's successful. XML: <?xml ...
0
votes
4answers
24 views

Unknown column error in where clause, using MySQL and Java

Following is my code line : ResultSet rs3 = stmt6.executeQuery("SELECT * FROM ShopSystem.Order where s_id="+s_id+" AND status="+Pending); I am getting the following error : Unknown column ...
0
votes
2answers
30 views

How do I use Ruby to connect to a MySql database outside of Rails as a scripting language

Hi Im using Ruby as a scripting language. Not for web development, but to connect to a local database on my computer and manipulate it. Id like to know how I can connect. Do I need to download/import ...
0
votes
0answers
29 views

Use Spring Framework and connect to MS SQL-Server 2008 database?

I have two instances of SQL Server on the same machine. A Sql 2000 and another in 2008 sql I'm not able to connect in the second instance (2008) with spring framework using the xml configuration ...
-7
votes
0answers
32 views

how to make a dynamic alarm clock iOS, like for Muslim prayer times [on hold]

So, I'm a little new to programming (I've learned a little bit of Java, and now I'm moving on to iOS), and for my first project, I want to make an app that notifies the user when the prayer time has ...
0
votes
1answer
6 views

can stale connection exception cause slowness?

While checking SystemOut.log during a reported slowness in the application I found StaleConnectionException occuring frequently. This exception was not observed earlier and I doubt that if this is the ...
0
votes
1answer
40 views

Retrieving data SQL less decimals than stored

In my database I have the stored value: quant = 1335.326233552119 But when I use PDO_MYSQL to retrieve this (select quant from table, etc) the returned value is: quant = 1335.3262335521 How ...
0
votes
0answers
5 views

how to connect OOBase to Netbeans

I saved my database in Open Office Base (*.odb) and wanted it to access through NetBeans. How can I establish connection from NetBeans? As far as I researched, I need to zipped the odb /save it as ...
-1
votes
0answers
19 views

Connect Oracle database with android application [closed]

I need to connect Oracle DB Server with android application, can anyone tell me, how to do this?
-1
votes
0answers
30 views

android studio display mysql values

I am tryinf to display a list of mysql values in my android app. I have searched through google about the way how to do it but no success. I have: lista.php //load and connect to MySQL database ...
0
votes
1answer
13 views

android studio doesn't connect with mysql db when configured with usb device

I am trying to connect my android app with mysql db. If I do it through emulator it is connected successfully, but when try with usb device (tablet) it doesn't. It shows this error: 07-29 ...
0
votes
1answer
33 views

Android studio application connection with mysql

I am trying to connect my android studio app with mysql database but I am having some troubles during this. I have made a simple login and also php files wich connect with db. public class ...
-6
votes
1answer
44 views

Best server side technology for mobile apps [closed]

I have to develop a mobile app (Android & iOS) that connects to a database hosted in a server. I would like to know: Best server-side technology, java, php, asp, ruby... Is a good option to ...
0
votes
0answers
15 views

JDBC: how to abort connection during the opening stage?

That's a simple question. All I want is: Connection connection = DriverManager.getConnectionButNoOpen(url) try { connection.open(... } catch (SQLException ex) { .... } And abort it during ...
0
votes
0answers
34 views

Update SQL Table via DataGridView in VB.net

Ok, possibly one of the stupidest questions ever asked here but I've been struggling with this problem for a couple of hours. Though in my defense I've only been a vb.net programmer for about 3 hours ...
-2
votes
1answer
16 views

Changing a global MySQL db file to MySQLi db file from PHP 4 to PHP 5.4

I have always used the following for MySQL database connection for procedural coding not OO running on PHP 4 and now I am moving some old websites to PHP 5.4: <?php global $db_user; global ...
0
votes
1answer
10 views

Sql Server Connection String Changes When Local and Remote

Hopefully this will be an easy one. I have several projects that use a Sql Server 2012 instance on one of our cloud servers. When I am developing on that server my connection string must be ...
0
votes
1answer
18 views

Reuse persistent dblink connection

We have a function that is quite often triggered and make a query to a remote db. If I am not wrong the connection persist just in the scope of the current call/session of the function. Is it possible ...
0
votes
0answers
30 views

Send data from one Database on my server to another?

I'm sorry if this a common knowledge, and I don't think I know the right terms to be searching for. When an order is placed on my website I want to send the information to the database of my web app ...
0
votes
1answer
23 views

Spring security with oracle credentials

I am trying to find the solution to allow to the users the possibility to connect with Our database credentials. At this moment, I am connecting with “generic database user” and then use a USERS ...
0
votes
0answers
26 views

mongodb number of connections

I'm trying to get the number of connected clients to my mongo server. I want to know how many connections are established and who did open those connections. I have tried doing so with db.server ...
0
votes
1answer
11 views

Dynamic DB selection (EJB 3.0 with Glassfish managed JTA server)

We are using JTA through Glassfish server managed dataSource, But we have a separate DB for Each client, How can I select DB dynamically according to user Logged In. If i set transaction type ...
0
votes
1answer
29 views

Retrieving data from Excel in C#

I'm using an Excel workbook as database, my code in C# WinForms and already writes on each Excel column and filters the Text from letters, etc. But I have one problem, when I double click N times ...
0
votes
0answers
20 views

Is it necessary to close a mySQL connection [e.g. with mysqli_close()], if so WHEN and WHY? [duplicate]

I've seen some posts that about debugging errors associated with mysqli_close(), more then once ive users have responded saying that it is not really necessary to close a connection? If its not ...
1
vote
0answers
24 views

Rails 4 database connection pool error

I have a rails app hosted with NGINX and Puma. Every 10 hours or so, the app becomes unusable. Whenever a user tries to connect, the following error message is displayed: Error during failsafe ...
1
vote
0answers
23 views

Mystery with Oracle inactive sessions JDBC connections and application slowness

Pardon me for my limited knowledge of Oracle Database. following is scenario I am currently working on application where my web application is deployed on 4 profiles of Websphere application server. ...
0
votes
1answer
16 views

MySQL connection works for Workbench but not Tomcat Application using same credentials

I am working on a remote Redhat system over SSH. Tomcat 7 and MySQL 5.5 server are both installed and appear to be running correctly. I can connect to MySQL from a local install of Workbench over SSH ...
0
votes
1answer
48 views

JBOSS AS 7.1.1.Final Closing Leaked Connections?

I have already done the following settings in standalone.xml as: <datasource jta="true" jndi-name="java:jboss/datasources/myDS" pool-name="java:jboss/datasources/myDS" enabled="true" ...
1
vote
0answers
42 views

2003: Can't connect to MySQL server on '127.0.0.1:3306' (99 Cannot assign requested address)

I am running a python2.7 application that performs "inserts" into a single mysql/mariadb instance on a multi-core 64 bit CentOS(or ubuntu) machine. as soon as the parallel processes/cores exceed 4 or ...
1
vote
0answers
31 views

Why does the Java App lose connection after MongoDB restarted?

The MongoDB is in a replica set with three members. Sometimes one or two MongoDB instances restarted, the Java Apps lose connection and show the following error and then I have to restart the Java ...
0
votes
0answers
91 views

SqlCeConnection open error in team project

For a few weeks we have been getting an error when attempting to run the program after getting latest version of the Sql Compact 3.5 database in our ASP.NET MVC5 project. It happens when trying to ...
0
votes
3answers
17 views

Connection Closed even when the connection is closed below the code

I have a basic code snippet below but it is not working.What may be the problem with it. public List<String> getStores() throws SQLException{ List<String> store_id=new ...
0
votes
1answer
22 views

How to check database connection status?

What is the most elegant/practicable way to get the database connection state via fluent nhibernate? I know there is the possibility to check the up-state via SqlConnection class, but is there a way ...
0
votes
1answer
22 views

php mysql connect fails even though shell client succeeds

I have a weird problem. I'm trying to connect from a linux host to a remote MySQL server on a Windows host. If I try to connect from shell using the mysql client it works perfectly. #mysql -h ...
-2
votes
4answers
28 views

Parse error: syntax error, unexpected '<'

I'm new to this PHP and MySQL world. I've been given an assignment about simple system. But i got this error and i don't know how to fix it. Hope you guys can help me. <?php include ...
0
votes
2answers
17 views

The result set is not updatable java-Mssql

I am working with java and Mssql. But I am a beginner. I have connected sql but when I want to insert data in sql, I have a problem. code: private void ...
-1
votes
0answers
24 views

How do I access to Typo3 Database?

I am new to typo and I am trying to access typo 3 database using $GLOBALS['TYPO3_DB']. but I am not able to get any results. I ended up with following result : Call to a member function ...
1
vote
1answer
32 views

Connection to local SQL Server database works on emulator but fails on real device

I am trying to connect to an SQL Server database that is currently hosted on my local machine. I am using the following code to connect: public class DBConnect { private static volatile ...
1
vote
1answer
39 views

Trying to connect Excel 2013 with Oracle - ORA-12154

I am trying to connect into Oracle through Power Query > From Database > From Oracle Database and then I type BI_TST, which is within my TNSNAMES (located in: ...
0
votes
0answers
33 views

Visual Studio 2013 connection to local MySQL Database

Getting right to the point, I'm learning Visual Basic, and I want to connect Visual Studio 2013 Express to a local MySQL database that I have running on the default 3306 port. For now I would be ...

1 2 3 4 5 … 63