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

Import MS Access Database Query into Excel using VBA without Login Prompt

I am trying to import an MS Access query into excel without triggering the log-in prompt. I have attempted this operation a few different ways, but both methods haven't given me a complete solution. ...
0
votes
1answer
15 views

Check MySql DB Connection

I wanted to create a mysql connection checker for my program and as always i used my usual advisor SO and i landed on this Question and the answer was not exactly right. The Question is: How to check ...
0
votes
0answers
21 views

Can not connect to local server with Microsoft SQL Server Management Studio

I would need to create a local server with Microsoft SQL Server Management Studio, but after registering the new server I can not connect to it, getting the error message below: Testing the ...
0
votes
0answers
6 views

Oracle JDBC Connection Not Closing After Upgrade to JDK7

In my application I need to connect to an Oracle 10 database and run a simple query. Because, that's all I need to do, instead of using JPA entities etc. I have a class that creates a JDBC connection ...
0
votes
0answers
26 views

Stop php re-proccess all when hit refresh

I'm here again with high traffic problems, i'm having a problem with "Sleep" thread on Mysql, after searching a lot i'm on my way to solve this problem. I make sure db connection is killed after the ...
0
votes
1answer
7 views

SQLite: SQLITE_BUSY on ATTACHed database and parallel read-only connection to the attached database

let me try to explain the problem in general parlance. We are using SQLite 3.7.11 by System.Data.SQLite Wrapper for .NetCF in Version 1.0.80. We have two database files: master_data.db ...
1
vote
1answer
6 views

Best way to handle Underlying Provider Failed to Open Internet Dropout

What is the best way to handle internet dropouts with the entity framework? I have an app at a location that often has the internet die, and while it doesn't totally fall over, what are the strategies ...
0
votes
1answer
40 views

can't connect to MySQL database using external ip address

I have a MySQL server running on my Windows 7 computer as a Windows Service. When I try to connect to it using external.ip = my ip address from http://www.whatismyip.com/ in command prompt: mysql -h ...
-2
votes
0answers
39 views

Connecting to mysql through php on an internal connection [closed]

I am attempting to log into mysql through php at work. I am connect internally to the server, but when I use localhost, it doesn't work. When I use the internal or the external ip address, I have an ...
0
votes
2answers
44 views

how to display value in dropdown list depending on another dropdownlist using jsp?

i m tying to bind the value to dropdownlist i.e named as subtype which is depending on another dropdownlist i.e named as type.please tell me how i can do that.. i have given i following code wich ...
0
votes
2answers
19 views

phpmyadmin (wamp) not working anymore

I've played a little with php and data bases a few weeks ago and it worked perfectly. Now, when I tested the same thing again, I realized that it is not runnable anymore. More exactly, when I have to ...
0
votes
1answer
22 views

OracleConnection life cycle

I'm using ODP on my DB application. I created wrapper classes over ODP for my application. It's a desktop applicaton it runs in a linear way(user can not do any other operation during a running ...
0
votes
1answer
34 views

mysql_connect warning, database host issue [closed]

I suddenly gοt this: Warning: mysql_connect(): in C:\xampp\htdocs\login.php on line 12 cannot connect to server A connection attempt failed because the connected party did not properly respond after ...
0
votes
1answer
15 views

Watching state of OracleConnection

I'm using ODP on my Oracle DB application.I registered to OracleConnection.StateChange event for watching the state of the connection. When i disconnect the db connection the event fires but for ...
0
votes
1answer
33 views

actionscript does not see changes to the textbox

Here is the relevant AS3 code: public function processLogin ():void { var phpVars:URLVariables = new URLVariables(); var phpFileRequest:URLRequest = new ...
0
votes
1answer
24 views

connection to ms sql server with php failed

I want to connect to SQL Server database using php and I couldn't do that. I receive Fatal error: Call to undefined function mssql_connect(). I have followed some guidelines but didn't help much. For ...
0
votes
1answer
36 views

Failed to load native dll (C:\Users\[Username]\AppData\Local\Temp\…\dbdata.dll

I'm trying to create an SAConnection into a Sybase IQ database. I'm attempting to create the connection through a simple visual studio C# application. My code fails at: SAConnection connection = ...
1
vote
0answers
15 views

Local system windows service is throwing Webexception:“Unable to connect to remote server”?

I am working on a windows service to upload data from database to a remote server in C# using visual studio 2012, when I am using a "Local system windows service", it is throwing a ...
0
votes
0answers
17 views

Sybase jtds driver trying to connect to sql server

I have a scenario where user provides me with hostname, port and credentials for the database he wants to connect to. I do not know the flavor of the database though. So what I try to do is try ...
-1
votes
0answers
19 views

ORA 12705 - Cannot access NLS data files or invalid enviorment specified

I am using an Windows XP Virtual Machine (I need to use VS2005 for devleopment purposes). I am trying to access an oracle database in VS 2005 via the Server Explorer. I am recieving this error (ORA ...
0
votes
2answers
27 views

DB2 can't connect to the server

I am tring to set up a db2 server on a Windows 7 machine and I cant connect to database from remote, only from local. I think I might miss some configuration. 1) I turned off the firewall 2) my ...
0
votes
0answers
15 views

Web App Hangs on OracleConnection constructor

We are having a situation where the OracleConnection (Oracle.DataAccess.Client) constructor hangs on a developer machine. There's no exception, it just hangs for 5-10 minutes, and then starts working ...
0
votes
1answer
25 views

how does iphone access sqlite database in my mac

I am crating an app in Xcode which stores some user information in an SQLITE database called contacts.db in my mac in the documents folder and my simulator is able to pull it up. So everytime a new ...
-1
votes
0answers
41 views

com.mysql.jdbc Connection and java.sql Connection [duplicate]

I am having a very big confusion. Whenever I am trying to do Database Connection in Java in Eclipse, I am making an object of Connection Class, i think, as there is an auto-complete facility in ...
0
votes
1answer
9 views

SPSS don't see MSSQL-view

I Connect SPSS 20.0.0 via ODBC to MSSQL server 2008. But now it has stopped displaying New views I create in the database. It displays all views I have created earlier. But New ones? No! Excel and ...
0
votes
4answers
39 views

Database error doesn't get values inserted phpMyAdmin

ctimings.html <html> <head> <link rel="stylesheet" type="text/css" href="cstyle.css"> // <script type="text/javascript"> // ...
1
vote
2answers
53 views

web2py webserver - Best way to keep connection to external SQL server?

I have a simple web2py server that we use to visualize data from our PostgreSQL Server. The following functions are all part of the global models in web2py. The current solution to fetch data is very ...
0
votes
0answers
15 views

connection refused while trying to build activiti

I am trying to build Activiti 5.10 using their build.xml. However the exact cause of the problem is the database connection being refused to create a database build.xml:156: ...
0
votes
1answer
23 views

How to create database in MATLAB

Actually I built a GUI to show the result of my program. When I click on the buttons, they need to read the input from a folder, which I choose for them, but I want to have a database to store all the ...
0
votes
2answers
49 views

How to differentiate users in web application

How to differentiate users, after they log in into their account, in the way that they cannot see and edit other users' data? Is it a good approach to remember somehow user id during logging procedure ...
0
votes
1answer
34 views

codeigniter unexpected model load

I'm building an app where it contains 3 mysql database connections to 3 different databases. Ex. 1. Default connection => DB1 2. conn02 => DB2 3. conn03 => DB3 All this 3 connections use same ...
0
votes
0answers
31 views

Why doesn't CodeIgniter's mysql database driver work for remote databases in WAMP?

I have not found any other question/answer that is this specific. A few clarifications: The same codebase for the project connects just fine on a LAMP, MAMP or even XAMPP stacks. WAMP version is ...
0
votes
1answer
35 views

Android app connectivity to remote database in Derby

I am trying to connect an android app to a derby database on a pc to get data form that. For this i googled a database specially for this purpose i.e. Awake SQL. I tried the following code for the ...
4
votes
1answer
98 views

connecting to an SQL Server database

I've recently started programming asp.net with C# (using VS2008) and I wrote my first web application that connects to a database. First version worked ok but now there are some problems once I modify ...
0
votes
0answers
10 views

SQL Server Management Studio seems to randomly open connections to databases

In our environment, we have remote users who engage in a transfer process that involves detaching a database on the server, and uploading a new copy of the database with updated data in it to the ...
0
votes
0answers
22 views

SQLite: Multiple Connections to one file - the one and only writable is not persisted

We are using the System.Data.SQLite Wrapper in Version 1.0.80. Using this to establish multiple connections to a single SQLite database will show a weird behaviour. We ensure having just one writable ...
2
votes
1answer
30 views

create a jboss datasource connection pool dynamically

I've been asked to write some code which can create multiple jboss datasource connection pools programatically upon startup. I've done this using a shell script which generates -ds.xml files at ...
0
votes
1answer
29 views

PDO drivers are installed, but connection test says otherwise

I'm trying to connect to my database using PDO drivers and as far as I know they are installed correctly. I have added the extensions to my php.ini file and the drivers are in the ext folder, I ...
1
vote
0answers
17 views

Including SQLite in release build Visual studio 2010

I am currently developing a project for school. We are told to include a database, and that this database should use the latest version of SQLite. Inorder to use and edit the database we use ...
1
vote
1answer
44 views

DB2.iSeries ConnectionString with Port

I am trying to connect to DB2 using the following connection string: <add name="ConnectionString" providerName="IBM.Data.DB2.iSeries" connectionString="Data ...
0
votes
1answer
22 views

Error from OdbcDataAdapter.Fill

I sometimes get two different of error when executing OdbcDataAdapter.Fill(DataTable). Here is the code example: string odbc = "select item, upcno from table"; OdbcCommand cmd = new ...
1
vote
0answers
12 views

Protocol used by Oracle RMAN to communicate with auxiliary [migrated]

What protocol is used by RMAN to communicate with the server used for backing up/restoring data? I searched everywhere but couldn't find any docs with this information. Background: I am developing ...
0
votes
1answer
23 views

Rails to Labview networked connection

I have a Rails server that needs to send a little bit of a data to a LabVIEW system when a record is saved. That shouldn't be too hard in Rails using an after_save hook and quite possibly a redis ...
0
votes
0answers
39 views

Setting a login timeout when connecting to sql server with android

I'm using the jtds 1.2.7 driver to connect to an sql server express database on an android device. I deliberately set it up so that I would NOT be able to connect so I could try to set a custom ...
2
votes
1answer
41 views

Advantage Database Server INSERT/UPDATE queries performance issues

I'm using the Advantage Database Server v10 and the corresponding ADO.NET provider. I found that AdsConnection.Close takes significant amount of time after an executing of INSERT/UPDATE queries. For ...
1
vote
2answers
44 views

Connect MySQL database to several domains

I have two websites with different domains and I have to share data between the two, such as user registered on first website will be login on the second website too. Is it possible to connect the ...
1
vote
2answers
38 views

Using for IDbConnection/IDbTransaction safe to use?

While my assumption may seem to sound subjective, after some research, I found that it's not uncommon to find developers who favour a dummy Try/Catch instead of using the Using statement for ...
1
vote
1answer
48 views

How to get database connection object

I would like to get database connection object in portlet environment. So, what is java class name which provide the connection object ? (i don't use servicebuilder because of my own reasons). Thank ...
0
votes
0answers
27 views

Can latency cause PHP mysql DB connections to build up?

I use the following common PHP code in all a site's scripts to connect to the DB: $con = mysql_connect(DB_HOST, DB_USER, DB_PASS) or trigger_error('Unable to connect to database'); ...
0
votes
0answers
31 views

Unable to connect using pymssql with windows authentication

While trying to connect to MSSQL Server 2012 using pymssql, I get the following error. My server name in Windows Authentication is SARATH,User Name is Sarath\SarathShanker and I did not set a ...

1 2 3 4 5 … 43