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
218 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 ...
0
votes
0answers
38 views

Microsoft excel 2010 - how to transfer multiple rows based on single key

I have a structure like this Current Department/Responsibility unique code/Target Department I want to create a new sheet where I will put down all the new departments(target departments) and draw ...
0
votes
1answer
91 views

KeePass like program without password auth [closed]

I'm looking for a program that's like KeePass's UI, and self contained 1 database file, but without the master password requirement. Essentially take KeePass, and remove the master password ...
11
votes
1answer
35k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
0
votes
4answers
312 views

How do I have Wordpress keep its database in the same directory as other files (for sharing via Dropbox)?

I am working on a Wordpress site with another person. At the moment the Wordpress files are on a shared Dropbox folder, which allows both of us to see all the files we need to work on. However, ...
0
votes
1answer
57 views

Corrupted database disk image [duplicate]

I have a corrupted sqlite .db file which cannot be opened in java because "the disk image is corrupted". I'd like a way to repair the database and recover as much data as I can, and make it openable. ...
0
votes
0answers
110 views

openoffice base report

I'm using open office Base to create a stand alone database for my service record. the problem is when i try to create a specific report, i cannot get the output that i want. lets says, I want to open ...
4
votes
1answer
78 views

How to store processed data?

I'm working on a project involving Twitter data. I have several hundreds thousand tweets downloaded and stored in files. The data was returned in json format, and the stream consumer I was using ...
0
votes
1answer
392 views

Trouble connecting to LibreOffice Base database in split database mode using HSQL 2.2.8

I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on this site ( How to set up ...
0
votes
1answer
985 views

How to extract numerical value after a certain string within a sentence in Excel cell?

I want to extract the numerical value immediately following the string "ABS" (Case sensitive) within a bulk of text in a cell from an Excel table. Not all the cell may contain the the string I'm ...
1
vote
1answer
148 views

Copy data from mail server to database

Is it possible to backup emails into MySQL database? Say, I have an account me@domain.com and I want to keep record of all the emails inside the mail.domain.com locally, in my computer. From what ...
0
votes
1answer
422 views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
1answer
54 views

What Microsoft product is used to draw a Relational Database for MS SQL?

What Microsoft product is used to draw a Relational Database for MS SQL? For MySQL I have used MySQL Workbench what is similar for MS SQL?
0
votes
3answers
109 views

I have a mysql table with 150k rows and do regular updates. Updates can take 1-3seconds. What options do i have to reduce this?

I have a table (mysql) that has 150k rows. During the day there are multiple updates (1000s) that change an int value to another int value (update table set field = ? where table.id = ?). nothing ...
11
votes
4answers
15k 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 ...
2
votes
1answer
69 views

PostgresSQL created a user account on OSX

Hello I installed PostgresSQL on my macbook but when I restarted my macbook later I saw that instead of the usual User account and the Guest account I now have also a Postgres user in my startup page ...
2
votes
1answer
2k views

how to connect to pervasive sql through odbc?

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = ...
1
vote
0answers
47 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 ...
3
votes
1answer
277 views

Which program does *this instance* java.exe belong to? Why is it there, and can I remove it safely?

Since I'm stuck in deciding for sure if I should just delete C:\WINDOWS\system32\java.exe ... (I use the java.exe from C:\Program Files\Java[javaversion]\bin, which I explicitly set in my path ...
0
votes
1answer
69 views

Relational database on a slow storage

I'm trying to pick a RDBMS for usage as a backend for KDE's Akonadi PIM framework. Problem is that the storage (/home partition) resides on a pretty slow SD card with reiser4 filesystem on it. The ...
1
vote
1answer
318 views

Copy data from “SELECT Multiple” Selection Box

I need to copy data from a selection box with the "multiple" HTML attribute that looks something like this: I have tried selecting all options and do "Ctrl-C" but it didn't work. When I go to the ...
1
vote
1answer
1k views

How to get the articles out of the RSSOwl database (db40)?

The feedreader RSSOwl saves all articles in a database rssowl.db. As far as I read, it's a "db40" database. Size of my rssowl.db is at the moment 3.9 GB. I also got another database with size of ...
0
votes
0answers
74 views

Configuring the mysql server

I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
1
vote
2answers
94 views

Kubuntu - how to find out what DB is installed

I'm newbie in linux, I installed latest kubuntu release. I was told that it already has sqlite on it/ How can I find out is it installed and what version of SQLite is on it?
0
votes
2answers
207 views

what is the main difference between a file with .db extension and a file with .txt extension while I save both of them from a text editor?

What is the difference between a file with .db extension and a normal file with .txt extension , leaving the fact that a .db extension is for a database file and .txt makes a normal text file. I open ...
2
votes
1answer
195 views

Do .frm files represent the entirety of a MySQL database?

So let's say I copy /var/lib/mysql and save it somewhere else, then uninstall/reinstall MySQL and put the original /var/lib/mysql back where it was. Will I have all of my databases without any ...
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
295 views

Mapping of child elements

I can't find one good way to solve this problem. I will try to sum the issue as best as I can: I use Hyperion Essbase Excel ad-in to navigate inside OLAP cubes. What I am trying to accomplish here is ...
1
vote
1answer
1k 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
1answer
100 views

Querying variables in Excel

I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type. Here are some ...
2
votes
2answers
300 views

Record bash_history to private database for all users?

I want to be able to setup a MySQL database and record all commands issued on my server by username and command. Is this possible, and if so, how would I set it up?
-2
votes
1answer
373 views

Ceridian HR-Payroll Source SQL error

We are using an old piece of software from Ceridian called Source this is a HR Payroll piece of software. I cannot phone their support as we no longer have a contract but use the software for archive ...
0
votes
1answer
45 views

Cannot connect to database

I created a php file to connect to my database hosted on ipages.com with the following simple code: <?php mysql_connect('hostname', 'username', 'password'); ?> When I load this page, I get ...
1
vote
1answer
104 views

How to connect or set a specifig schema in LIBGDA database browser?

I've here a PostgreSQL based database, with a schema and some tables inside it. When I use psql I must put the schema name in front of every statement: SELECT * FROM schemahere.tablehere; Or is ...
1
vote
2answers
34 views

Best option for db installed in home dir? [closed]

My research group shares a server for which I do not have root access. I would like to install a database in my home directory to manage my results. What would the best option in terms of ease of ...
1
vote
1answer
2k views

Difficulty connecting to a database with Primavera P6

I'm having trouble connecting to Primavera P6 (project). When I enter my username and password, I receive an error: This user is already logged in... The password was never changed.
1
vote
1answer
230 views

MySQL deadlock - Adding columns

I had a nasty MySQL problem arise the other day. I added two new columns to table 'Promotions' (13 existing columns, ~750 records) using the PHPMyAdmin interface. This query ("ALTER TABLE.....") ...
0
votes
1answer
104 views

Am I using the best/fastest method of connecting to a remote database?

In my work, I often need to connect to a remote database. so I use a virtual private network(VPN) Client called "ShrewSoft VPN Client" , and that has some configuration. Then I use Windows "Remote ...
0
votes
2answers
3k views

MySQL File viewer/editor

I'm dealing with some very massive SQL files and I need to be able to go in and edit them. Are their any editors that work on Windows I can use? I need to be able to cut out what I don't need and ...
2
votes
1answer
7k views

How do I extract excel data from multiple worksheets and put into one sheet?

In a workbook I have 7 sheets(Totals and then Mon to Sat),I want to extract rows which have the word "CHEQ" in its cell (this is a dropdown list with two options-CHEQ/PAID)from all sheets. On my front ...
1
vote
0answers
349 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 ...
0
votes
3answers
2k views

How may I retrieve data from an Excel table based on a variable number of criteria?

I have the following salary data for example: Country State 2012 2013 -> 2027 ======= ===== ==== ==== China Other 1000 1100 China Shanghai 1310 1400 China Tianjin ...
2
votes
3answers
4k views

Can an Excel 2007 Pivot Table merge data from different tables like a database?

I want to analyze data with a pivot table in Excel 2007. I tried to construct an easy example to explain my question below: I have a table (Table2) with data sorted by Person. I want to analyze ...
0
votes
1answer
354 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
0
votes
1answer
282 views

Why did I fail to build mariadb?

The error message is as follows: 141> Call Stack (most recent call first): 141> D:/tmp/mariadb-5.5.27/bu/cmake_install.cmake:81 (INCLUDE) 141> 141> 141> CMake Error at ...
0
votes
1answer
69 views

Did Microsoft TechNet 2005 contain Visual Fox Pro 9.0?

I'm working at a company that has an old copy of Microsoft TechnNet 2005, and I was told else where that "If you have a license to MSDN Professional (or higher) you have a license to Visual FoxPro" ...
1
vote
0answers
356 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 ...
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
1answer
19 views

searching the database objects

How can I search SQL server database to find string in any of objects name? I have a problem when testers says this and that is not working and I can not find it by it's name.
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. ...