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
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
183 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
86 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
2k 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
6k 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
287 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
3k 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
314 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
252 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
68 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
314 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
47 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. ...
0
votes
1answer
106 views

Visual Studio 2010 SQL Querys how to set BIGGER default font

By default, the default font when you perform a query on a table by going to right click over table -> New Query is very small, you can increase it pressing ctrl+ but when the query is execute the ...
0
votes
1answer
2k views

Libreoffice Base: combobox keeps replacing value to 0

I have a ComboBox which loads a country list, every time i select one item and then focus in other object of the form it resets to 0. This ComboBox is linked with an Integer value in the main table ...
0
votes
1answer
538 views

Is there an easy fix to this copy/paste into Excel error?

When I attempt to paste a large spreadsheet (from a DB, ~90,000 rows) into Excel, I keep getting this error: Microsoft Excel is waiting for another application to complete an OLE action I ...
0
votes
1answer
1k views

Why is my mysql database table not allowing me to edit data manually?

For some odd reason out of the blue my database in MySql will not allow me to manually edit any records. My guess is it never has. I am logged in with the Workbench under the root account. I have ...
4
votes
1answer
344 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 ...
2
votes
1answer
1k views

How to add new customized columns to windows 7 explorer (or find a similar application that is more customizable)

I like the way windows 7 explorer allows me to organize all my files by sorting columns - except there is little room for customization: I can't add my own types of columnns that can then be directly ...
2
votes
1answer
553 views

Spreadsheet application that can handle big data OS X

I've been working with Excel for quite a while for some statistical analysis that I do regularly. The size of the data that I'm working with has gotten much larger as of late, however. The layout of ...
4
votes
3answers
4k views

How does geolocation based on IP address work?

As all Internet users, I've visited web sites which appear to know in which country and city I'm located. I understand that these web sites typically look up my IP address in a database which maps IP ...
1
vote
0answers
587 views

installed mysql using yum but mysqld dowsnt start: Fedora 16

i installed mysql mysql-server and mysql-libs ... after installation i thought to start the mysql service using command systemctl start mysqld.service Failed to issue method call: Unit mysqld.service ...
1
vote
1answer
422 views

What does the output of this “source” command mean?

Unix newbie here, installing MYSQL. Per the directions from the server admin, I just added two lines to the end of my .cshrc file to create 2 new environment variables: setenv MYSQL_UNIX_PORT ...
0
votes
1answer
40 views

Is running multiple databases on login going to make my Mac really slow?

Sometime ago, I installed Postgres, and the Launch agent that causes it to run when I log in. Just now, I did the same thing for Mongo. I was just about to do it for Couch. I don't remember if I ...
1
vote
3answers
10k 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: ...
0
votes
1answer
342 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
215 views

How to get the difference between two dates based on an item (truck) number

I'm trying to set up a database for a co-worker to track information based on truck number, amount disposed, etc. Sometimes trucks are left with garbage at then end of the day. That truck may not be ...
0
votes
3answers
306 views

Easy to use database with views for a medical student doing research?

I'm having trouble finding a tool that does this for my friend (without designing it myself). What is needed is a simple program with a database where input forms and views can be designed and saved. ...
0
votes
1answer
487 views

What command in MySQL is like the command “host” in oracle sqlplus

Oracle sqlplus allows you to drop down to a system command line shell which lets you run operating system command like ls, cd, cp, etc. Here are examples SQL*Plus_FAQ, docs.oracle.com Is there some ...
1
vote
2answers
94 views

How to transfer results to Excel

I have a massive (and I mean MASSIVE) amount of results from Minitab 16 displayed as plain text organized in columns and rows. My problem: I need to put all this information into tables to manipulate ...
2
votes
1answer
4k 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 ...
1
vote
1answer
472 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 ...
0
votes
2answers
47 views

Access, select or utilise names in another worksheet of the same book

I've created a name database on an Excel sheet and I would like to access, select or utilise any of these names in another sheet of same book.
1
vote
0answers
269 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
0answers
108 views

What enterprise tools exist for exporting from a database into a set of files?

I'm looking for software that's designed to select/query data from a database (SQL or NoSQL), and export it into files (CSV, XML). Ideal characteristics: Manage very large datasets (petabytes), ...
1
vote
1answer
295 views

Alternative, more efficient scraping method for a noncoder, than Google doc's importxml and xpath?

I've searched throughout the net for a simple solution, but it seems everyone has their own unique method (coding language) of achieving this. I'm only just beginning to learn Linux, and my coding ...
0
votes
1answer
211 views

MS Query unresponsive after launching in Excel 2007

User is launching MS Query from within Excel 2007 querying a database and then MS Query becomes unresponsive staying minimized to the task bar. Any assistance would be appreciated, the user is able to ...
1
vote
1answer
189 views

Change location of storing mysql database

Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
0
votes
1answer
150 views

Issue changing mysql password on Debian

I installed mysql on my Debian server. I couldn't get into the database because it kept saying I put in the wrong password so I looked on the internet and found that I could log onto mysql using the ...
1
vote
0answers
304 views

Export MS SQL database as *.dbschema

We have a production database and visual studio 2010 database project. We had to make some changes in database schema. Unfortunately we don't have previous database schema file for production ...
1
vote
2answers
3k views

SQL Server Management Studio: Database Attachment Failed

I have publish my website in IIS7. It is running in DefaultAppPool. The Identity of this app-pool is set to LocalSystem. The IIS is running and I can run the application from IIS without any problem. ...
0
votes
3answers
59 views

Can there be permissions/limitations with browsers over a network?

I'm part of a network at my job and the only thing that can be accessed from my/my co-workers computers is the company database and sharepoint. These are accessed through IE. Everything else is denied ...
1
vote
1answer
184 views

Is there a term for software that allows users who don't understand DBs to create reports from a DB? [closed]

Is there a term for software that allows users who don't understand DBs to create reports from a DB? A customer might just say I wanna see people and addresses that are related to this incident, for ...
3
votes
2answers
798 views

How can I keep every fifth row in Excel

I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set. ...
0
votes
2answers
180 views

extract information from table of values

Hi I have table of values stored in a csv file and the table is organized the following way: Method1,,Method2, T1,T2,T1,T2 a1,b1,c1,d1 a2,b2,c2,d2 a3,b3,c3,d3 a4,b4,c4,d4 One example of something ...
2
votes
1answer
3k views

What's the difference between .db and .sqlite files?

I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in ...
1
vote
0answers
74 views

Why are there limits to scaling relational databases? [closed]

It is often repeated that the Big Data problem is that relational databases can not scale to process the massive volumes of data that are now being created. But what are these scalability limitations ...
1
vote
1answer
202 views

Fastest way to transfer an mssql database backup from one windows server to another?

Would it be by copying it onto a hard disk or is there a faster way?