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)

4
votes
0answers
1k 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 ...
3
votes
0answers
3k 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 ...
3
votes
0answers
628 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
258 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
63 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
240 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
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
444 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
14 views

Database: AOC (intersection-based) efficient 3-way join?

I am attempting to improve performance on a highly normalized database wherein I have the following structure. entity (identity) org (identity) entity-org relation (many to many) ...
1
vote
0answers
16 views

Miscrosoft Access - Multi-Table Data Entry

I'm using Microsoft Access 2016, and am designing a tool to track our engineer drawings at work. As you can see from the image of my relationships, the project info cascades down on the left and the ...
1
vote
0answers
42 views

Is there any way(e.g. software etc.) where data can be matched visually

I have two columns in excel(see N.B.) that contain as below Column1 Column2 ------- -------- USA India Serbia United States of America Bharat China ...
1
vote
0answers
19 views

How to display database/list online with images that show up when hovering over each row

I have this project of mine that ended up making me create an Excel database. Current state is 300ish rows x 15 columns. However, the project is getting to big for me to handle alone. I'd like to ...
1
vote
0answers
12 views

Exporting data from Unicode DB to Non-Unicode DB

So, I have 2 databases A & B. A is Unicode database and B is non-unicode. I am going to send some data from Unicode database A to non-unicode database B. I do not have any multi-byte data in ...
1
vote
0answers
325 views

Hibernate Entities generated using IntelliJ have no Foreign Keys generated

I have a normalized SQL Server database with 20+ tables on it that created using SQL Server Management Studio 2014. I am able to connect to this database in IntelliJ and follow along with the steps ...
1
vote
0answers
90 views

Specific request on SQLMAP using “where” clause

In order to clean a database and delete inactive users, I would like to know users that haven't loged onto their account since at last 2 years. These are the data i have : database name : db01 table : ...
1
vote
0answers
73 views

Can MS Access make a column-of-rows type of form like the one pictured?

I am trying to make a form consisting of multiple forms stacked side-by-side in Access, like the one pictured below but have run into many, many issues. I will settle for a report if I can't get a ...
1
vote
0answers
15 views

What database uses “H??X!$L<” (“ndcy”? ) as a Magic Header String?

I'm trying to determine what database Cydia uses for metadata on jailbroken iOS devices. There is no file program available to offer a possible answer. Here's the head of the cat: iPad:~/root# cat ...
1
vote
0answers
100 views

PostgreSQL and database cluster ownership on shared storage

For my research, I am using an always on virtual machine for the primary analysis of my data. In doing this I need (or, I suppose, would like to) create and store the data in a PostgreSQL database. ...
1
vote
0answers
139 views

How do I combine data in two tables in LibreOffice?

I have a spreadsheet with two sheets. SheetA has Customer number and location, and SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and location? ...
1
vote
0answers
105 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
783 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 ...
1
vote
0answers
1k 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
170 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
58 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
165 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
215 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
79 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
81 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
56 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
41 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
186 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
302 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
53 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
422 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
446 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
49 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
664 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
375 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
396 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
402 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
68 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
365 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
186 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
1k 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
45 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
11 views

RPM-GPG-KEY Error While Installing Oracle Database 11gr2 on CENTOS 7

I am Trying to install Oracle Database 11gr2 in CENTOS 7.For installation process I am following this procedure https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-7 ...
0
votes
0answers
8 views

Self-creation of odd database files?

Quark 11 has just created two files and they now appear in my 'open recent' list. One is called 'link', one is called 'ls'. Neither can be opened by this version of Quark, both are locked. I don't ...
0
votes
0answers
19 views

15 MB SQLite database file from Chrome history shown blank

I accidentally removed the profile from my Chrome on Windows and everything disappeared. Except I was able to recover 15 MB history file from my hard drive it said the file was not corrupted. But ...
0
votes
0answers
25 views

Classic .ASP and OnChange and reading an Access database (WIN10)

I'm trying to populate the contents of a web form with an Onchange header function (select * in database where ID="somevalue") but I don't know how to open the database whilst in the header function ...