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)

1
vote
0answers
15 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
0answers
18 views

Setting user-level-security in new versions of MS Access

I've read this MS info which should cover my problem. There are quite clear steps: Open the .mdb or .mde file that you want to help protect. On the Database Tools tab, in the Administer ...
0
votes
1answer
19 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 ...
0
votes
1answer
42 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 ...
-1
votes
0answers
10 views

Database is not connecting [closed]

I'm trying to connect database. Here's the details of my work: $con=mysql_connect("localhost", "root",""); mysql_select_db("employees",$con); if(!$con) { die("cant establish database ...
0
votes
0answers
9 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
1answer
14 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
0answers
7 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 ...
0
votes
0answers
13 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
16 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
14 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
31 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 ...
4
votes
3answers
156 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 ...
2
votes
1answer
62 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. ...
1
vote
0answers
8 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
0answers
8 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
14 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
0answers
17 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
26 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
35 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
12 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
0answers
19 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
2answers
179 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 ...
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
2answers
37 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
22 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
21 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
56 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
47 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 ...
-2
votes
1answer
487 views

OSX: Snort: ERROR: /etc/snort/../rules/local.rules(0) Unable to open rules file “/etc/snort/../rules/local.rules”: No such file or directory

I'm trying to setup and run Snort IDS on mac using this kinda tutorial: https://discussions.apple.com/thread/3370709?start=0&tstart=0 OSX Yosemite (10.10.2); PostgreSQL 9.4.1 (installed with ...
-1
votes
1answer
171 views

OSX: Postgresql port 5432 is closed. How to open?

Mac OS X Yosemite (10.10.2) Postgresql 9.4.1 (installed with Homebrew) Snort 2.9.7.0 (installed with Homebrew) I can't connect to psql - port 5432 seem to be closed: $ psql postgres psql: could ...
0
votes
1answer
24 views

Postgresql: can't rename the database

PostgreSQL 9.4.1 (installed with homebrew) I want to rename a database. I'm doing this: $ psql postgres postgres=# ALTER DATABASE snot RENAME TO snortdb postgres-# \l ...
1
vote
0answers
112 views

How to convert a FoxPro database without spending $$$ [closed]

Got an old piece of software that I need to pull the database out of, so it can be easily moved to some new software. Based on the information I have found so far, I believe it is a FoxPro database ...
-1
votes
1answer
58 views

.mdb file completely corrupt after the frequent recoveries

I am running Access database and one of .mdb files was corrupted for a long time. I got an error messages repeatedly, unfortunately I don’t remember exactly which ones. I let it go because I was still ...
0
votes
1answer
43 views

Performance comparison for older server [closed]

Given the falling price of older decommissioned server hardware, I am considering purchasing one to use for my research at home. I will be running Linux, PostgreSQL, Neo4j and R-Server on it. I ...
1
vote
2answers
160 views

Access database error: The module name xxx is misspelled or refers to a module that doesn't exist

We are using Access database 2003 (I know, too old) with Win server 2008 in my company. We have one .mdb file split into two. A couple of days ago we had a problem trying to open modules. It all ...
0
votes
2answers
69 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
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
236 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 ...
-3
votes
1answer
25 views

sql database errors 823. Can someone help me? [closed]

I have a question….How to fix sql database when generating an errors 823? Please help me to out this! Thanks
1
vote
3answers
56 views

Can a database be too relational?

I have a question about database design. I'm asking here because I'm an enthusiast/hobbyist and not a "professional" so I don't want to post it on the "Database Administrators" stack exchange ...
2
votes
1answer
92 views

Connecting to host OS database from guest OS VirtualBox virtual machine

I’m using Pentaho BI server in a CentOS VirtualBox machine, and now I want to connect it to an SQL Server database that I am running in my Windows host OS (localhost). Is there a simple way to do ...
0
votes
0answers
19 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. ...
0
votes
2answers
444 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
34 views

How to backup and migrate only the user account data of one Gitlab server to another?

So we have 1 Gitlab server that we've outgrown so I am expanding to a second one for all new repositories but keeping the old one for existing repos. Our userbase is the same but I don't want to go ...
0
votes
1answer
19 views

cumulative profit of each client in table no 2 from data of table 1

I want cumulative profit of each client in table no 2 from data of table 1 formula i use is ...
0
votes
0answers
17 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 ...
0
votes
0answers
47 views

what permissions are needed to run a jar file on a shared drive

I want to run an executable jar file from a workstation that accesses the file from a shared drive on a network server. The program accesses a local database on the server and if accessed directly on ...
1
vote
0answers
459 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 ...
0
votes
0answers
19 views

Copy SQL Server database with full transaction log

I have full SQL server transaction log on one server and one database (full recovery model) that I unfortunately don't have direct access to the database. Something in the software is filling up the ...