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

-1
votes
0answers
4 views

What is the best way to connect to a remote database server that can only be accessed from a different ec2 instance?

How would I go about connecting to a database that can only be accessed through an ssh tunnel to an ec2 instance. The current route would be: My ubuntu laptop -> ec2 instance -> postgres database ...
1
vote
0answers
10 views

PHP Mysqli 'dynamically' saying what connection (variable) should be used

What is the best way to use multiple (dynamic) PHP Mysqli connections? Currently I have a single MySQL server. All my data is on this server in a few databases. But in the not too distant future my ...
0
votes
2answers
28 views

Mysqli connection design

I going to create a website that can get as much as 6,000 alerts daily(those alerts containing up to 140-characters, that's approx. 30 words-tokens-). My question is if i have a function that verify ...
0
votes
1answer
10 views

A potential statement leak detected for connection pool

for the following code I get this warning : [2013-08-07T16:44:27.442+0300] [glassfish 4.0] [WARNING] [] [javax.enterprise.resource.resourceadapter.com.sun.gjc.util] [tid: _ThreadID=94 ...
0
votes
0answers
13 views

IBM DB2 Connection using VS2012 framework 4

I am trying to connect to IBM DB2 using VS2012 and framework 4.0. I installed the 64 bit IBM Data Server Driver Package (DS Driver) (V10.5 fix pack 2) and 32 bit (only 1 available) IBM Database ...
0
votes
0answers
17 views

can any one say me how to establish a connection between asp/JScript and local sql server 2008 in a local machine using IIS

Here is how I establish the connection but it's not working <%@language="JScript"%> <%function sql() {`` var conn, sql; conn = Server.CreateObject("ADODB.Connection"); ...
0
votes
0answers
6 views

Difficulty connecting to SQL Server remotely

Alright, I have a pretty broad error that I've run into while attempting to connect to a remote sql server on my home network via Data Connections in the Server Explorer of Visual Studio 2010. The ...
0
votes
1answer
20 views

Connection pool opens more connections then maximum pool size

Hey I'm using Glassfish open source v4 and I'm having a weird problem. I have defined a JDBC connection pool to Oracle 11g in the admin console and I've set : Pool Settings Initial and Minimum ...
1
vote
2answers
44 views

How to find out the set login timeout for a Connection object in Java?

I have a Connection object in Java(1.5) and I want to know what value was set for the login timeout. Is there a way to access this? I am trying to set the timeout in the URL itself, like ...
0
votes
1answer
24 views

Login to DB and extract info BEST PRACTICE?

I have already framed the connection between the app and the db on my web server using JSON(the app extracts the info using the JSON) although I have second thoughts in this type of connection I have ...
1
vote
1answer
26 views

“no pg_hba.conf entry for host” but “LOG: connection authorized”

I have a wierd problem. I have a service running using PostgreSQL 8.3. On parallel platform I have installed PostgreSQL 9.1 and try to connect to it using my working php script. Got an answer: ...
0
votes
0answers
7 views

Obtaining information of tables being used in stored procedure using DbConnection.GetSchema

Is there a way to obtain information about the tables being used inside stored procedure using DBConnection.GetSchema()? I tried using DbConnection.GetSchema("Procedures",new string[] {db,null, ...
0
votes
1answer
15 views

symfony 2 define doctrine connection per bundle

I have a SaaS Symfony2 project with many bundles and a global database connection defined in config.yml. Now lets say, a specific client wants some custom funcionality. Because I want it to be ...
-1
votes
0answers
9 views

Cannot remote to postgresql database over internet

I am new and not enough skilled in this field, so I am asking for some help. I use an application where the database is located on a postgresql 9.0 server, I want to connect or remote as client to ...
0
votes
1answer
31 views

Music database to run track data against

I'm writing an app that will let me manually edit my iTunes music library from outside of iTunes using a SQL-like syntax. I know how to edit the library, but I want to be able to run my track info ...
0
votes
1answer
27 views

how do I connect to sqlite database?

How do i connect to a sqlite database? I am planning to distribute a db with my application with all the tables already made in it, so i don't need to create a new db or tables, just distribute it. I ...
3
votes
1answer
33 views

Cannot connect to SQL Server: Failed to retrieve data for this request

I have been writing a program in c# using Visual Studio 2012. This program makes numerous calls to the database, and everything has always worked perfectly; never had to mess with any configurations ...
0
votes
3answers
44 views

PHP PDO Database Connect Class [duplicate]

This is what I have as my database class: <?php // Define configuration define("DB_RDBMS", "mysql"); define("DB_HOST", "localhost"); define("DB_NAME", "ccaweb"); define("DB_USER", "ccawebroot"); ...
0
votes
1answer
12 views

Integrated Security with Impersonate=true / Connection String issue / ASP.NET

We have a website deployed with Impersonate=true. A connection string is defined as this: Integrated Security=SSPI;Persist Security Info=false;Initial Catalog=MyDatabase;Data Source=MyServer; ...
0
votes
0answers
14 views

Hardcoded DB Failover - Java, JDBC, MSSQL, Cisco CVP

Need to add failover DB functionality in our system with access to limited codes that can be revised. The current Cisco DB element that we are using is not up for revision to maintain standards so we ...
1
vote
1answer
28 views

How to whitelist 2 ip-adresses with ip-tables and block everything else?

I want to whitelist 2 external ip-adresses vor port 3306 (mysql), but block all other IP-adresses to the port 3306 on a debian server running a mysql-instance. Both external ip-adresses should be able ...
0
votes
1answer
24 views

Importing CSV to Django and settings not recognised

So i'm getting to grips with Django, or trying to. I have some code that isn't dependent on being called by the webpage - it's designed to populate the database with information. Eventually it will ...
0
votes
0answers
23 views

c# Oracle Dynamic Connection string solution

I have an application that connects to specific Oracle user & database with data provided by user through one little form. User inputs Username, Password and host address and can connect to any ...
0
votes
1answer
40 views

MYSQL connector saying it has connected even with the wrong username?

I am building a database connection scanner for my security course at university. I have used DriverManager.getConnection(connectionURL, username, password) and it seems to work fine but with one ...
0
votes
4answers
31 views

php mysql database connection in an array with port number

In php I am doing connection to the mysql database in a simple way like this <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . ...
1
vote
1answer
31 views

C# exe not working on target platform x86

so, I'm trying to log accesses to my shared files on the network (I'm modifying Abdollah Zawari's ShareMoniter), i do this by starting openfiles.exe like so: var process = new Process(); ...
0
votes
1answer
21 views

MySQL connection from my desktop to remote MySQL not working

The error specifically says "Host ..com is not allowed to connect to this MySQL Server" I have the correct userid and password which works fine on remote MySQL if I RDP and login locally. The TCP ...
0
votes
4answers
74 views

finidng time difference between two times stored in database using sql and c#

string sqlUserName3 = "SELECT out_date FROM status where s_id='" + TextBox2.Text + "'"; SqlCommand sqlcmd3 = new SqlCommand(sqlUserName3, sqlcon); sqlUserName4 = "SELECT in_date FROM status where ...
-1
votes
1answer
17 views

How to Put Database Connection to ServletContextListener [closed]

Servlet ContextListener is helpful in informing about context Initialization and destruction. In a typical content management web system, there is always a database behind.
0
votes
0answers
9 views

simulate a model of a specific ODBC Driver

I have to write a program to work with a specific ODBC connection on a clients server, but it is not possible for me to have access to the server during development. What would be ideal would be... a ...

1 2 3 4 5 … 74
15 30 50 per page