A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.

learn more… | top users | synonyms (2)

3
votes
0answers
489 views

How can I move the database location of Evernote successfully?

I am currently on Evernote 4.5.x and lost quite some data because I didn't notice that the crashing Evernote deleted recently created notes due to space limitations in my TC container. I am not happy. ...
2
votes
0answers
289 views

How to use ShemaSpyGui for view database diagram

I installed Postgre today and I want to watch database shema. I resolvse to use schemaSpy and download it and also schemaSpyGui and then I see: This is the command (password not displayed!) ...
2
votes
0answers
139 views

What desktop computer hardware specifications are most important for database heavy applications?

I am purchasing a new personal desktop computer with the hope of improving performance for database-heavy applications (mostly data mining). I will want versatile hardware for all sorts of future ...
2
votes
0answers
54 views

Oracle Session Numbers Going Crazy - What is the best strategy to over come this issue?

We have a JVM web application which is running on Oracle Application Server and it uses commons-dbcp (http://commons.apache.org/proper/commons-dbcp/) and implicit connection pooling. Our db is Oracle. ...
2
votes
0answers
150 views

Store Values from a Dynamic Cell Elsewhere in the Spreadsheet - Building a Database with Excel/Google spreadsheets

I have a list of values that updates as new data becomes available on a website using importXML (cells A1-A25). I want to store those values elsewhere in the spreadsheet so that when the values ...
2
votes
0answers
2k views

Display primary : foreign key relationships in Visio database diagram

I've created a Database Model relationship diagram in Visio with tables and relationships. However, I can't find any way to automatically display the Primary Key :: Foreign Key relationship in the ...
2
votes
0answers
927 views

Free Tool to Generate Diagram of SQLite Database

I tried using openoffice via ODBC, and it connected properly, but when I tried to use tools->Relationships... , it gave me the error message "The database does not support relations." I'm using OOo ...
2
votes
0answers
35 views

Automatically find license of music

Is there some kind of database or online API that would enable me to automatically find the license for a certain music album? I would like to legally share music with some friends, but my collection ...
2
votes
0answers
401 views

Create view based on table in MS VISIO 2003

I'm working on a physical ERD in Microsoft Visio 2003, and I want to create some views based on only one table. Right now I've having to manually add all the columns from parent table. Is there a ...
1
vote
0answers
12 views

Is there a way to let PostgreSQL restore but not create a new timeline

I'm using PostgreSQL 8.4 and am creating a standby server. Since PostgreSQL 8.4 doesn't have built-in replication support, I did the following things try to get read only access to the standby server, ...
1
vote
0answers
382 views

How to recover MySQL database on xampp/windows using ib/frm files?

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
1
vote
0answers
82 views

How to fix botched Outlook CSV data export 2013

When I exported contacts from outlook into a CSV file (to later upload it to Insightly database), it placed company names as part of the email address, it looks like this: Column named "E-mail" ...
1
vote
0answers
26 views

Database-based word document

I will take an example, it'll be easier: So I have a database about classrooms. There is student db which contains all the students like so: id name surname slug class 0 John ...
1
vote
0answers
97 views

SQLite GUI for my grandma

I created a SQLite database for my grandmother to store all her poems because I was tired to see her search/copy/paste across many different Word documents. Yet I have still to convince her to use it. ...
1
vote
0answers
89 views

Excel 2010 won't remember password when importing data

After connecting an Excel workbook with an SQL server (within a company network, over a static IP address, using the data connection wizard within Excel), if I close the workbook and reopen it, it ...
1
vote
0answers
2k views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...
1
vote
0answers
67 views

SQL Server - Database with strange storage space

I have a strange problem with one SQL server database: The database takes 180GBs on disk, with no space available; while the only table it contains should use only sth like 25GBs: EDIT: database ...
1
vote
0answers
52 views

Database for Quotes needed: Tags, multi-language support?

Dear superuser userbase! Almost every website now supports tags. I want to harness the power of tags for a private database, can you help? Ideal: A database of quotes (columns: English | German | ...
1
vote
0answers
52 views

How to dump all MySQL databases for one specific user?

I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so. ...
1
vote
0answers
37 views

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
1
vote
0answers
123 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
1
vote
0answers
179 views

Pull Data From Web Database With Excel 2007

I have a web based database that I work with regularly that uses 802.1x authentication (Smart Card with password). From the website you can pull premade and custom reports that are ultimately stored ...
1
vote
0answers
43 views

How to migrate a CRM database to an other? Manually or with an ETL solution?

I would like to migrate a database: - from Goldmine 5.0 - SQL Server 2000 (more than 10 years old, huge quantity of datas) - to Microsoft Dynamics CRM 2011 - SQL Server 2005 ETL solutions so far I ...
1
vote
0answers
978 views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
1
vote
0answers
312 views

CDX currupt index file & Windows 2003 Server

We're experiencing almost everyday database index corruption on Windows Server 2003. I wonder if it can be somehow connected with caching or other server settings. We are running an old application ...
1
vote
0answers
326 views

Info path 2003 refuses to submit - 'The form does not contain any new data to submit to the datasource'

I have this error InfoPath cannot submit the form The form does not contain any new data to submit to the datasource How can I fix this? I've made a form in InfoPath specifying an access ...
1
vote
0answers
48 views

Visual Studio 2010 DON'T CLEAR Query if doesn't succed or syntax error

In VS2010 when you perform a query against database if the query itself has any syntax error the VS by default clears all text from screen. This makes you to type again the text and resolve syntax. ...
1
vote
0answers
605 views

installed mysql using yum but mysqld dowsnt start: Fedora 16

i installed mysql mysql-server and mysql-libs ... after installation i thought to start the mysql service using command systemctl start mysqld.service Failed to issue method call: Unit mysqld.service ...
1
vote
0answers
293 views

Sage 1000 data dictionary

I'm just starting doing reporting using MSQL SSRS against a Sage 1000 database. It's working well but I'm trying to find out more about the data model on the database in order to make best use of the ...
1
vote
0answers
311 views

Export MS SQL database as *.dbschema

We have a production database and visual studio 2010 database project. We had to make some changes in database schema. Unfortunately we don't have previous database schema file for production ...
1
vote
0answers
319 views

Getting complement of two text files on the Unix command line

Is there a fast Unix-based utility (ideally written in C) for getting efficient, streaming intersection/union of tab-delimited text files? For example, allow queries such as "give me the all the ...
1
vote
0answers
63 views

Converting an SVN repository to SQL database

I have downloaded the svn repository of Atunes using TortoiseSVN. I would like to transfer the logs of activity of the developers to a SQL database, preferably an Oracle one. Is there any software ...
1
vote
0answers
299 views

Error in accessing MySQL using RODBC in opensuse

I have installed R 2.13 in opensuse 11.04. I wanted to access a MySQL db using R. I Installed RODBC without any error. I can even load the RODBC (usinglibrary('RODBC')). When I tried to connect to db ...
1
vote
0answers
132 views

Using Visio to document access databases?

I'm using Visio to create diagrams of a number of Access databases, using the Database->Reverse Engineer option. Do I have to create an ODBC connection for each access file, or is there a quicker way ...
1
vote
0answers
802 views

The best way to sync an MS Excel file with DB data (including saving it)

I have an Excel file that is supposed to mirror some data from an MS SQL DB. This file is synced automatically to a remote location. I would like that whenever the Excel file is synced, the data that ...
1
vote
0answers
39 views

Tools for interactive type-2 (SCD) work?

Are there any good tools for interactive type-2 SCD work? I'm looking for both analysis (e.g., "what changed between date_1 and date_2?") and execution (e.g., "update my type-2 table with this new ...
0
votes
0answers
7 views

Where does the Lazarus Chrome extension store its database?

Lazarus' website is down, so I can't look this up. Where in Linux should I look to find its SQLite database of saved forms?
0
votes
0answers
10 views

What diagnostics are available for a General Protection Fault from an old Windows program?

I have run an old (1996) Windows program that accesses DBF files. If I run with an old copy of the database it works fine. But if I run with my current copy of the database, I get the GP Fault when ...
0
votes
0answers
6 views

Carbox Database Software Keyword Error

Having an issue with keywords not taking effect in the Cardbox Database software. It is happening in several different records - the last 30 and a few random ones in between. It isn't registering ...
0
votes
0answers
12 views

OSX: mysqladmin create database: connect to server at 'localhost' failed

I'm trying to create database in mySQL on OSX using the command line: $ mysqladmin create database Getting: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user ...
0
votes
0answers
17 views

Oracle SQL Developer Data Modeler: How to Search for a Table and Show in the Diagram

In the Oracle SQL Developer Data Modeler 4.0, there is find functionality. It's icon is the binoculars in the top right corner. When we use that find operation, we receive a list view of results that ...
0
votes
0answers
25 views

Please explain the content of my snorby database.yml

I'm trying to reconfigure my Snorby (installed for MySQL) to work with already existing Snort database (Postgres). This is Snorby database.yml file: snorby: &snorby adapter: mysql username: ...
0
votes
0answers
8 views

Password issue for Access db in SAP BI

It is little bit complicated system so let me do it in points: We have SQL server 2005 database that is accessed by multiple programs. We have Access 2013 database that works as front end for ...
0
votes
0answers
11 views

Apollo message broker integrity check?

We're currently using Apollo message broker 1.6 on Linux and one thing we noticed is that if for any reason the broker service doesn't shutdown properly (machine crash, daemon killed, etc) there's a ...
0
votes
0answers
18 views

Receiving authentication failed error while running sonar with Mysql

Receiving authentication failed error while running sonar (3.7.3) with Mysql.I am able to run sonar using h2 database of the same.So i dont believe it's due to the wrong user name and password. And ...
0
votes
0answers
19 views

boost application process in ubuntu

Are there other ways to boost an application process in Ubuntu other than "nice"? I want to backup a database without using import and export method and just use push and pull method instead. I tried ...
0
votes
0answers
42 views

Exception in WCF service while reading Data from Database using ID

I have got exception on live server. pl. let us know, why we have got error so many time Exception in Repository.DTTransaction.Get(). TransactionId: 26397149Exception : ...
0
votes
0answers
11 views

Alligning Two data sets - one data set has duplicates

How can I align two data sets so that one data set spaces out to match the other. For Example I have two Data Sets: DATA SET A DATASET B Individual ID Household ID ...
0
votes
0answers
195 views

The LDAP Server is unwilling to perform (53)

I know the problem is not new, but I'm trying to get this server work at least one week. The steps I did. Install OpenLDAP Importing all ldif (It was working). ls /etc/ldap/schema/*.ldif | xargs ...
0
votes
0answers
18 views

How to Create a VirtualBox like Oracle developer day VM using CentOs?

Oracle has provided us a way to use Oracle Database on Mac with its Developer day VM's. But its of huge size and I couldn't resume the download. So I want to build a VM with Oracle Database installed. ...