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.
1
vote
1answer
224 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
votes
1answer
21 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 ...
-3
votes
0answers
15 views
Use search engine to list all possible values of an attribute? [closed]
Is there a way to use google search (or other SE) to list all possible values in a given category of an online catalog (where each object is a web page)? The optimal result would be a list of unique ...
2
votes
0answers
49 views
Microsoft Access 2010 Error
Ok, so I am not a pro in MS Access (or databases), but I tried googling this and no answers, so here goes nothing:
I am trying to create a field to convert currencies from one of 2 fields, thus I am ...
-5
votes
0answers
19 views
Why is PDSP playing up? [closed]
I have been looking up binding affinities of drugs to their pharmacologic targets in the PDSP database and for whatever reason whenever I change the species to Human when searching with the Ki ID, ...
-1
votes
0answers
12 views
Autoselect checkbox and save that value to the DB [closed]
I have this code here:
<input type="checkbox" <? if ($ifvisible) echo ' checked '; ?> name="agreevideoshare<?=$token?>" onchange="if ...
0
votes
0answers
14 views
Finding oracle physical database files [migrated]
I'm using oracle 11g and I need to find the database files to copied to another server. The database was created from migrating from SQL Server 2008 to 11g. There doesn't seem to be a counterpart for ...
0
votes
0answers
15 views
what software can I use to show mapping of 2 database?
I have 2 database server main database A and other database B.
Database B is same as A but the name of tables and some of the field name are different, but data inside is almost the same.
Database B ...
0
votes
0answers
26 views
How to install and configure database certificate tool?
How to install and configure Firefox Database Certificate Authority Tool (Certutil)
I have a PHP based web application with log-in functionality. Now the log-in works with the help of SQLite ...
2
votes
1answer
1k 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 ...
3
votes
1answer
40 views
Transfer Amazon S3 data to MySql Database [closed]
I have about 350000 files in my Amazon S3.
I need to transfer them to a MySql database running in my server..
Which is the best way to do this?
I saw this post which uses Pipeline, but Pipeline is ...
-2
votes
0answers
29 views
Is it well designed relational database just with one table? [closed]
I have MySQL database containing just one table, having 100 rows and 12 columns: ID (primary key), NAME, LATITUDE, LONGITUDE, TYPE, COUNTRY, CONTINENT, DESCRIPTION_PATH, STORY_PATH, PICTURE_PATH, ...
-2
votes
0answers
26 views
Average time for importing 750MB mysql database on WAMP [closed]
I am trying to import a database with 750MB of data size via the command mysql import.
It's been running for 45 minutes now.
Is this normal? How can I verify that it is running or see if it is ...
0
votes
0answers
13 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
23 views
To keep web application and database on different VMs? [closed]
I have an Analytics Database (star design in SQL server 2008) and a web application (ASP.NET) that gets data from the DB and renders various reports and charts (MS Charts). They run from the same VM ...
-1
votes
0answers
36 views
Using VBA to automatically assign gender in excel spreadsheet [closed]
I have to do an analysis on an online membership database within excel, but for some reason, some of the cells under the Gender column remain unfilled. I have found moderate success by downloading an ...
0
votes
1answer
42 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
8k 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
34 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
1answer
2k 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
2answers
76 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
14 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
59 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
4k 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 ...
-4
votes
0answers
41 views
Is there a database of software? [closed]
I need a database dump, that contain (well, as much as possible) common software as rows.
Something like
id software_name
---- ----------------------
1 Adobe Acrobat
2 ...
-1
votes
1answer
20 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
21 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 ...
2
votes
1answer
601 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
1answer
2k views
How to fix UDI-31623 error in Oracle?
Yesterday I've tried to import another DUMP as a new Oracle schema and failed to to limited space. So the impdp exited with an error. I've successfully deleted outdated schemas using the sysadmin ...
0
votes
1answer
542 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
2answers
3k views
How to connect to MySQL server in LAN?
Here is the technical description.
My laptop's config:
IP Adress:192.168.2.5
MySQL Server 5.0 on port 3306
Operating System: Ubuntu
The database is in this machine
My friend's laptop config:
...
2
votes
2answers
7k views
Compare two Microsoft Access databases
I have two Access databases that I need to compare but I don't know how I can do this.
I'm trying to compare the differences between both the structure and content (possibly limiting the comparison ...
0
votes
3answers
47 views
mysql access denied for 'root'@'name of the computer'
I am getting this error everytime im trying to connect to my database
Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045):
Access denied for user 'root'@'name of the computer' ...
1
vote
0answers
27 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
19 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
443 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
46 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
367 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
105 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 ...
2
votes
3answers
295 views
Is there a GUI interface for sqlite?
Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
1
vote
0answers
43 views
Is there a way to convert a memo field to a text field in Access 2010 in an expression?
I have two tables (each in an Access DB) -- called LinkedTable1 and LinkedTable2 linked to my working Access database. I got them on my computer after downloading them from a SharePoint site (Actions ...
1
vote
1answer
6k views
Importing CSV files into Excel using a macro
I'm want to develop a macro where in my excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...
0
votes
4answers
165 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
73 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| ...
2
votes
2answers
625 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
25 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
24 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 ...
0
votes
0answers
61 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 ...
4
votes
1answer
49 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
2k views
SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051) - What does this error mean?
I get following error when i try to connect via "HeidiSQL" to my database server (local network)
SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051)
SSH Connection via Putty works ...
