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
1answer
68 views

Access Query for Positive Checkboxes

I have a table which contains personal information of our staff, at the end of the table there are checkboxes for general training (medical, military, health and safety) etc. Say for example i wanted ...
-1
votes
1answer
406 views

How to update a Powerpoint slide with an external database?

I have a database of 1000 users with their name, number, photos, addresses, and other fields, etc. (in RDBMS-like say mysql, PostgreSQL). But I want to implement this mostly in Excel. So what I want ...
0
votes
0answers
222 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
66 views

Sort by selection..spreadsheet software

I am so frustrated... I use ArcMap a lot and therefore I use the 'show selected features' a lot when I am in the attribute table. Now I need to manipulate a csv file in excel with 150,000+ records ...
1
vote
3answers
10k views

.pdb file viewer or reader tools?

I have a lot of files in .pdb (as in a Palm Pilot Database) format, major of them downloaded, but until now I can't using or read what the inside, so I looking for how to read, view the .pdb file ...
0
votes
1answer
1k views

How to access my database stored in PHPMyAdmin from different computers?

I am working on my Java application in Eclipse that connects to the database and makes some queries with the data. This database has been created and managed in PHPMyAdmin. The database is stored ...
2
votes
2answers
6k views

Dynamically filtering data before importing from SQL Server in Excel

I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...
1
vote
0answers
80 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, ...
-2
votes
1answer
173 views

How do companies like walmart,target etc. update there barcode scanner systems? or create a barcode system? [closed]

I was wondering how a big company make a barcode system? Are there any barcode databases off the web that I could just download as a whole? And once I had one where would I go to update the already ...
7
votes
3answers
5k views

What file format/database format does Picasa use?

I am trying to figure out what file format the .db file and .pmp files are. I tried using db_dump (Berkeley DB) for the .db files, but it seems that they are not Berkeley DB, or of an older version. I ...
-1
votes
1answer
57 views

phpMyAdmin: Make foreign relation more readable [closed]

I am adding some foreign relations in phpMyAdmin to make data more easily accessible when adding rows. How can I make the foreign relation value stay as is (ex. ad6c68d9c365364f437e4a569765de2e) but ...
2
votes
1answer
54 views

What are the risks for logging across databases via a trigger?

I've searched for this online and had mixed or unclear responses. On SQL Server 2005, we currently log certain table changes via triggers using the inserted/deleted tables. Currently, our log ...
0
votes
1answer
1k views

Oracle database client on OS X?

I am looking for a way to run the Oracle database client on a Mac. The server will be on a remote host. There used to be a Mac version of Oracle 10gR2 Client, but now I can't find it on Oracle's ...
1
vote
0answers
108 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
34 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 ...
8
votes
7answers
563 views

School Management System

I am looking for a school management system to replace a homegrown Access db. It should be able handle the following for both a Primary and Secondary school Scheduling classes Student ...
0
votes
1answer
81 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 ...
7
votes
4answers
461 views

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
0
votes
1answer
211 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 ...
3
votes
3answers
521 views

Is there a GUI interface for sqlite?

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
0
votes
4answers
279 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, ...
2
votes
1answer
110 views

Easy way to put multiple columns in Excel on their own rows?

I have a sheet that looks like this: A | B | C | D | E | ---------------------------------------- 62| Value1| Value2| | | 345| Value3| Value4| Value5| ...
4
votes
2answers
4k views

Where can I find H2 JDBC driver?

http://www.h2database.com/html/download.html I don't see it on this website. Is there anything I missed?
0
votes
1answer
47 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
71 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
65 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 ...
20
votes
4answers
45k views

Sync Two MySQL Databases

What is a good way to sync two MySQL databases? I would like to sync the data in my production website's database to my local development database. Right now, I am just using the PHPMyAdmin ...
0
votes
1answer
638 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
98 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
50 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
2answers
74 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 ...
0
votes
4answers
4k views

Microsoft Access: How do you create fields with multiple boxes to tick?

I'm using Microsoft Access to fill in information from a questionnaire, which has been answered by 80 people. This is a questionnaire with both quantitative and qualitative answers. I've set it up so ...
2
votes
1answer
61 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 ...
1
vote
1answer
400 views

How to migrate a database from MyISAM to InnoDB?

I am migrating a database with MyISAM tables to an InnoDB engine. Some of the tables in MyISAM have full text indexes. If I have to retain the full text indexes in InnoDB engine, what are the things ...
4
votes
1answer
283 views

MySQL quiet installation references wrong executable

I am trying to install MySQL 5.5.27 (latest) quietly from the Windows (XP) command line via batch file using the MSI method. Following the directions on the MySQL site, I simply do this: msiexec /i ...
1
vote
0answers
220 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 ...
0
votes
1answer
228 views

Merging Database Modifications - CVS

I'm working on a project using git for version handling. What is the best approach to include a mysql database in the cvs? For example, if I checkout the database and install it at home, make some ...
1
vote
0answers
38 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 ...
0
votes
1answer
76 views

Should a dev team use a local database or a remote shared one? [closed]

I'm part of a team of developer and today, we do our developments against an Oracle 11g database installed on our own machine each. I would like to know your point of view about this way of working ...
0
votes
1answer
257 views

Conversion of GRIB and NetCDF to my database

I have downloaded "High Resolution Initial Conditions" climate forecast data for one day. It was a .tar.gz file so I extracted it in my local directory and I get the files as shown in the image below: ...
0
votes
1answer
58 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 ...
0
votes
1answer
131 views

ADODB Connection - Webserver doesn't resolve the hostname of the mssql server

I have a mssql connection resource file as belows: <% Set Conn01 = Server.CreateObject ("ADODB.Connection") Conn01.Open "PROVIDER=SQLOLEDB; Data ...
2
votes
2answers
88 views

Creating A Log Of Files In A Folder

I am an absolute newbie in this thing. Can anyone help me to build a table that lists all files in a specified folder so whenever a file is copied to that folder the table should update. I need the ...
3
votes
1answer
188 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 ...
1
vote
0answers
497 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
187 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
579 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
53 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
64 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
159 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 ...