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)

0
votes
0answers
18 views

Upload data in .txt file to SQL database through ftp in command line

I have a table in .txt file with header, and an empty table Final_Beta_Table with header only in SQL database. It's a NETEZZA database and there are many other tables in it. How can I upload the .txt ...
1
vote
1answer
55 views

How can I convert MS Access 2003 (2000 file format) to Sql Server Express 2014?

I've been searching for the past two days on how to get this conversion done, but every suggestion I've seen yields no effective results. I've installed Sql Server Express 2014 and have verified that ...
0
votes
1answer
17 views

How do I resolve data range failure from Excel?

When refreshing a data source in Excel 2013, I get an error about a data range. How do I stop this error from occurring? I think that the error has something to do with removing connections because ...
0
votes
0answers
5 views

How do I open tox.db for clients for the secure Tox network?

I made an issue in one of the Githubs for Tox, but I don't know whether the developers have time to deal with it. https://github.com/notsecure/uTox/issues/1091 There's this file called tox.db that ...
1
vote
1answer
26 views

How to calculate number of possible records in Redis per 32GB of memory?

In my company are talking about the possibility to build some part of our backend in Redis instead of mongodb but we want to calculate how many records we will be able to store in a server with 32G. ...
3
votes
4answers
753 views

Is there a GUI interface for sqlite? [closed]

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
0
votes
2answers
4k views

How can I remove Postgres completely from my Mac?

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
0
votes
1answer
6 views

SQL 2014 adds null transaction log entries every time a custom service wakes up to look at the database.

SQL2014 on Server2012 (12.0.2000) versus SQL2008R2 (10.50.6000) on Server 2008R2. In SQL2014 but not in SQL2008 .... Both examples add the noted entries to the transaction log once a second (every ...
2
votes
1answer
5k views

In Visio 2010, how can I create a mandatory, non-identifying relationship between two database tables

I'm working in MS Visio 2010. This is the relevant part of my ERD: The relationship between Event and Adventure is correct: there's a foreign key from Event to Adventure, and that FK is part of ...
8
votes
3answers
9k views

How do I repair a corrupted Firefox places.sqlite database?

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies ...
0
votes
0answers
16 views

To edit commandline Anki flashcards in MySQL

I need to make a small change in 77777 Anki flashcards, preferentially programmatically, not by using their replace tool which is not sufficient. I imported data originally there as CSV files where ...
0
votes
0answers
8 views

Search views in multiple MS SQL databases for use of Order BY and record which view uses it

In the process of migrating over some old databases to new servers, we know that some views in some databases might be using an ORDER BY, but we're unsure which / where. We'd like to record which ...
0
votes
0answers
3 views

Can't open firebird db with python

A client of mine uses an application with a firebird db. I'd like to do some data analysis so I need to access to the db from some programming language(Python in this case). The problem is that I ...
0
votes
1answer
19 views

If I have a data entry field in a SQL Server table, can I index it efficiently?

I've got a backend SQL Server database. It's my understanding that clustered indexes are most efficient, but that they physically order pages to make it efficient. So, if it's a user-entered field, ...
0
votes
0answers
29 views

Why does Windows Server Backup save as .VHD file?

On our Mail server we are running Exchange 2010. We have four databases. One of the database is called Regional. I decided to take a backup of this Regional database using Windows Server Backup and ...
0
votes
1answer
440 views

BCM - Database Tool 2013 on SQL 2008r2

Im trying to setup a Database with the Business Contact Manager Database Tool -2013 on one of our server. The tool is able to detect the SQL intance but can't create the Database. I've gone through ...
0
votes
1answer
38 views

Connect mysql database to Ms Access directly

I am trying to connect mySql database on our server directly to an msAccess database we have. I want to be able to download data from the mysql database directly and upload it too directly. I want ...
0
votes
1answer
19 views

How to put a multi-lines text in a database from the command line?

I have emails exports in full text (one file per email). I want to put them in a database from a shell script (bash or python). Let's say I have created a database with a emails table, and from, to, ...
0
votes
1answer
28 views

How do I create a new database?

Since upgrading to Yosemite 10.10.1, I can't create a new database set theOutputFolder to choose folder with prompt "Please select an output folder:" tell application "Database Events" make new ...
1
vote
2answers
43 views

Find out database type from files

How can I find out database type in order to examine data when all I have is the database. By database I mean the database folder under program root folder with bunch of files around database.db file? ...
0
votes
0answers
17 views

Configuring a centralized rsyslog server with MySQL database, gathering events from multiple servers

I'm trying to configure my rsyslog server to collect logs from many servers and write them to a local database. The problem is, the server writes the data to the DB as local (host, ip, etc) I'm ...
0
votes
0answers
15 views

Find riak node's listening HTTP and Protobuf port

I recently followed and scripted the Riak 5 minute install, successfully getting 4 nodes running on a Ubuntu 14.04 VM. Currently the nodes are running and are joined / clustered successfully. ...
0
votes
1answer
21 views

Remove PostgreSQL database files

I've uninstalled PostgreSQL some time ago, but now I needed it again, and installed it. When running rcpostgresql I get the following: /usr/sbin/rcpostgresql Your database files were created by ...
0
votes
1answer
54 views

Split data in half evenly by adding column with value: 1 or 2 based on specific cell value - excel

I have a query I pulled from a database with student information. The table has the following columns: StudentID, CourseID, CourseGrade. The CourseGrade column can contain any of the following ...
0
votes
1answer
39 views

Monthly Pivot Tables In an Annual Report

I was given 12 tables of purchase orders (one for each month) that my school has made and was asked to create an annual report listing purchases for each month which is pretty simple. The thing is ...
4
votes
3answers
160 views

How do I force an application to recognise two names for a disk drive?

I have an extensive image database (3.25GB metadata, 90K images) held in a legacy product (idImager V5). This in turn utilises SQL Server 2005 as the underlying DBMS. Over time, I have been adding ...
9
votes
4answers
13k views

“FATAL: lock file ”postmaster.pid“ already exists”

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
0
votes
0answers
20 views

Advanced Query Filtering in Access 2010

I am using Access 2010 to log prospective students for a school program. Once these students apply, they need to have a school ID generated (or if they are a current or former student, simply looked ...
0
votes
0answers
19 views

URLField in django models allowing users to submit blank records, why?

This is what my models.py file looks like: from django.db import models class accounts(models.Model): url = models.URLField(max_length=200, blank=False) The database is still allowing blank ...
2
votes
1answer
71 views

phpmyadmin not displaying schema

I have a server with a large number of mysql databases. Recently some of the schemas have stopped displaying when logged in as Root. If I use the login for that specific database then I can see it. ...
0
votes
0answers
19 views

asp connection to asphostportal mysql database

I'm trying to connect via asp to a asphostportal mysql database on their server. I've created the database and added a users table. I have an opensource intranet (UAPortal) that is really ...
0
votes
0answers
28 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
15 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 ...
1
vote
2answers
60 views

Query for false values in Access not working

I'm trying to create a simple database to keep track of paperwork as it's turned in. In the form and table I've used yes/no check boxes, checking them when a paper is turned in. What I want to do is ...
1
vote
0answers
11 views

Mongoose: Failed to connect to IPC Port. [closed]

Failed to connect to IPC Port. Mongoose installed without issue. But I get this error when I attempt to actually use Mongoose.
0
votes
2answers
96 views

Is there a tool to put a phone number into E.164 format?

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example: (123)456-7890 fred ...
0
votes
0answers
9 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
1answer
17 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
0
votes
2answers
49 views

Lotus Notes, Tabs, & Reference Database

A colleague is experiencing a problem with Lotus Notes on her computer that I (first line of tech support) cannot replicate and also cannot find a solution to. My department has 30+ people in it, we ...
0
votes
0answers
23 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
2answers
572 views

Apache couldn't be started because port 8888 is in use by some other software

I am having an issue starting up MAMP, when I attemp it, I get this error message: Apache couldn't be started because port 8888 is in use by some other software I have been trying for the last 2 ...
0
votes
0answers
35 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
13 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 ...
1
vote
2answers
417 views

Excel: How to connect to a sqlserver localDB

I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013. Here is the part of the "connection property" dialog in SSMS which shows the ...
1
vote
0answers
28 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, ...
0
votes
0answers
12 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
36 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
24 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
64 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 : ...
-1
votes
1answer
60 views

Automated Visio Database Model Diagrams

Is it possible to automatically create a Visio database model diagram from a edge list or some sort of source/target file? I am looking to automatically create some sort of data flow diagram in Visio ...