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)

-4
votes
1answer
18 views

Does exists software who manage export/upload/download/import data processes? [on hold]

I'm looking for a software who can manage data exchange between systems, with a 'main control panel' who alerts me for succesfull/failed of each export/import steps. I'm working for a mid sized ...
0
votes
0answers
4 views

Same Excel workbook fails to connect to Access DB for SOME users

I have an Excel workbook that is pretty heavy with code and connections to Microsoft Access. When the Workbook opens, it looks at the database's full path, written in a cell in the Settings sheet. ...
1
vote
0answers
5 views

Format sqlite3 .schema command output

I created some sqlite tables schema using python. When I use the sqlite3 client and issue the .schema command, I can see the output is pre-formated as in the SQL source file I used as argument for the ...
-2
votes
2answers
31 views

How to connect multiple websites to one database in same server

What would you do if you have one server and multiple websites in that server and you want to connect all of the websites to one MySQL database in the server? I know it decreases the security but I ...
0
votes
1answer
22 views

Synchronizing database between local and remote machines

This may be a popular question, But i am new to synchronization concept. Please guide me with suggestions. My requirement is to have a local and remote database(cloud) to sync the data between them. ...
-1
votes
0answers
12 views

Quandl, How to pull data from Quandl using API

Does anyone have any thoughts on how to pull data from Quandl into a simple database, so that I can run a query or group of queries against that database to pull the information I need? For Example. ...
0
votes
0answers
22 views

MySql 5.6 - windows 8.1 can't access or copy ibdata1 file after force restart - cannot restart MYSQL

I'm having a serious problem with my MySQL server and my ibdata1 file. I had for force restart my development machine - as result I cannot restart my MYSQL server. When I restart my MySQL server - ...
-3
votes
0answers
23 views

How to take inputs and create database in excel

I apologize in advance for the broad question. I am using excel to keep a database of a group of around 20 people and (theoretically an infinite amount) of companies for a school club. Basically, I ...
0
votes
1answer
15 views

Exchange Server DAG and Failover Cluster with High Availability

I have 2 exchange servers (EXCH1 and EXCH2) that have Exchange 2013 on them. They are both on Windows Server 2012 R2 (Standard) machines. They are also a part of a DAG (Database Availability Group) (...
-2
votes
1answer
21 views

Excel - Manage database to import to CRM

I have a database where each row contains a variety of company info (name, address, website, phone, etc. Each row also contains three contacts and their corresponding title. The headers are CEO Name,...
3
votes
2answers
29 views

SQL : Restrict view of tables in database

This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
1
vote
1answer
64 views

MySQL error, can no longer login as root

So I updated my MySQL and PHPMyAdmin yesterday and ever since then I cannot login to MySQL as root or any other username I have. I tried both phpmyadmin and the terminal and still cannot get in. How ...
0
votes
1answer
28 views

How to convert 3 colum in an excel matrix?

I have many data set on 3 column as the tab above and I would like to convert to a like the one in the picture. Is there a function that do this in MS-excel 2007? I think I need to create a ...
0
votes
0answers
6 views

sql server 2000 vs 2014 local login

I have an application written in delphi AND uses sql server 2000 as database engine.I was on windows server 2003 for many years without problem.recently I upgraded to windows server 2012 r2 and sql ...
1
vote
1answer
104 views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
0
votes
0answers
43 views

RPM-GPG-KEY Error While Installing Oracle Database 11gr2 on CENTOS 7

I am Trying to install Oracle Database 11gr2 in CENTOS 7.For installation process I am following this procedure https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-7 ...
2
votes
1answer
21 views

In Microsoft SQL Server, how can I disable “X rows affected” at the end of my output?

I'm querying a database in Microsoft SQL Server and writing the output to a csv file. When importing the outputdata into another program i get an error because the last line of my output file ...
0
votes
0answers
8 views

Self-creation of odd database files?

Quark 11 has just created two files and they now appear in my 'open recent' list. One is called 'link', one is called 'ls'. Neither can be opened by this version of Quark, both are locked. I don't ...
-1
votes
1answer
25 views

How to automate a database search on a website from a third party website?

My users will be uploading products on my website which are registered by a government organisation. This government organisation has created an online database of these products which is free to ...
0
votes
0answers
23 views

15 MB SQLite database file from Chrome history shown blank

I accidentally removed the profile from my Chrome on Windows and everything disappeared. Except I was able to recover 15 MB history file from my hard drive it said the file was not corrupted. But ...
1
vote
0answers
14 views

Database: AOC (intersection-based) efficient 3-way join?

I am attempting to improve performance on a highly normalized database wherein I have the following structure. entity (identity) org (identity) entity-org relation (many to many) org-entity-owner-...
0
votes
0answers
28 views

Classic .ASP and OnChange and reading an Access database (WIN10)

I'm trying to populate the contents of a web form with an Onchange header function (select * in database where ID="somevalue") but I don't know how to open the database whilst in the header function ...
0
votes
0answers
102 views

TortoiseSVN database locking errors after disabling Samsung RAPID mode

One of my users is getting database lock errors from TortoiseSVN after disabling Samsung RAPID mode. What's a good way to find out what programs had a file locked recently? Since it requires a ...
0
votes
0answers
47 views

SQL Server 2014 Express has reached database size limit. What is the quickest solution?

My SQL Server 2014 Express database has reached database size limit. What is the quickest solution to get back up and running? Is Express software the same as the full version, with just some ...
0
votes
1answer
63 views

Hardwareinventory - Copy Record with values in Access 2016 Web App

I want to make a WebApp in Access which help me inventory all our Hardware. Below is a VERY wip ERM for the Database behind it. Every CPU-Object is its owm physical thing (if we have 2x i5-3450 there ...
0
votes
1answer
81 views

Excel Pivot Table with Microsoft Access Connection

I have a pivot table which sources its data from a query within an Access database file. Whenever I make an update, I make a copy of both the Excel and Access files first - and carry out the update on ...
1
vote
1answer
62 views

What embedded database format is used by this Chrome extension?

Chrome extension F.B. Purity writes its data at ~/.config/chromium/Default/Local Extension Settings/ncdlagniojmheiklojdcpdaeepochckl/000003.log (not a log file despite its name). This file is a kind ...
0
votes
0answers
13 views

Query optimization in Data stream

I am confused about the idea of query optimization in stream of data. As a background, I know that optimization for any query is happening inside the DBMS with using of system catalogs which contain ...
2
votes
2answers
36 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
0
votes
2answers
40 views

Excel 2016 list of options for connection to DB has suddenly reduced, (MySQL, PostgreSQL)

I work with open source dbs such as MySQL or PostgreSQL as a back-end data storage with my excel 2016. I had the full list of connections to all different kinds of dbs but they are suddenly reduced ...
1
vote
0answers
16 views

Miscrosoft Access - Multi-Table Data Entry

I'm using Microsoft Access 2016, and am designing a tool to track our engineer drawings at work. As you can see from the image of my relationships, the project info cascades down on the left and the ...
0
votes
0answers
75 views

MySQL Install DB Error 13 / 1005

I am trying to programmatically install multiple mysql databases on a Ubuntu distribution server via a bash script, and I keep hitting the ERROR: 1005 Can't create table 'db' (errno: 13) each time I ...
0
votes
1answer
239 views

XAMPP and MySQL workbench [duplicate]

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
0
votes
0answers
75 views

XAMPP and MySQL

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
0
votes
0answers
46 views

“Navicat for PostgreSQL” gives error “80070003: PrectServer2 not connected” when attempting to autocomplete with materialized views

For some reason I get the error "gives error "80070003: PrectServer2 not connected" when Navicat tries to autocomplete. Take the following example select co.| from visualize.co_mention co When the ...
0
votes
0answers
13 views

How to allow a database user to do anything inside the databases she/he creates?

I have a problem with yabs, a free business software. This piece of software can use a mysql server for storing its data. As usual a user in mysql-server is created to limit the authorities of the ...
0
votes
0answers
11 views

Curious search behavior in Sql Server 2014, searching for dot also returns comma results

Background I'm getting some unexpected search results, consider the following pseudo-query: SELECT SomeField1WithSearchCriteria, SomeField2WithSearchCriteria, ...
-1
votes
1answer
35 views

drop database via bash with dash in database-name

I have a variable in a script with the list of folder names with dash in their names DBDIR="some directory" dbdash=`ls -l $DBDIR | egrep '^d' | grep '.-.' | awk '{print $9}'` And I want to drop ...
0
votes
0answers
56 views

How to Create Drop Down Tables In Microsoft Access 2013

My question is: how do I make multiple drop-down tables in Access? I'm trying to make a table with multiple entries and drop-down tables underneath. For example: Main file: Car Types, Sub File 1: ...
1
vote
2answers
49 views

Why am I getting this MySQL database creation error?

I have a redhat linux in AWS EC2. I created a few dbs yesterday for an application. Today, I am getting an error in creating a new database. mysql -u root -p pw: xxx CREATE testdb; I get an ...
1
vote
1answer
74 views

Is there a way to automate the conversion of old Access databases (.MDB files) to the newer .ACCDB format?

I have a couple hundred old Access databases, in the old .MDB file format. I'm not sure which version of Access they were created in. My ultimate goal is to make them usable to someone who has Access ...
-1
votes
1answer
211 views

C# console Application with DB

i have c# program connected to SQL server and it is working very good but when i am trying to install this program in other PC it doesn't work unless SQL installed the data base is very simple .. i ...
0
votes
0answers
5 views

SonarQube Server end of an update process

during a CI process,after a SonarQube Scanner analisys, we must produce some reports using fresh analisys result data. SonarQube stores analisys results data asynchronously but we have to know if a ...
0
votes
0answers
87 views

Cleaning up data fetched from Google Spreadsheet to Excel

I've been trying to synchronize and build a local database with Excel data. I need to build the database and program to create user accounts, manage the packages, track and log the status of the ...
0
votes
0answers
18 views

Merging multiple folders with different names, but similar content

I have a database of images, within the images folder are different folders of the alphabet: C:\Images\A C:\Images\B etc... Within the alphabetical folders, there are folders with the naming ...
1
vote
1answer
25 views

Database Query and Excel

I have a report on Excel that built using database query. I need to write comments on each row. When I refresh the file the comments don't stay on the same row and don't match the record. What should ...
0
votes
0answers
136 views

Microsoft ODBC for Oracle not working with Oracle 11.2.0.2

I have Oracle client installed and i am able to connect using sqlplus, i am also able to use My requirement is to try to use Microsoft ODBC for Oracle using the following VBSript code my .vbs file ...
0
votes
1answer
111 views

Remove all references to removed Sql Server database

One of my programs that I have written, creates on installation a SQL Server database. The database name is hardcoded in the sources. Now I have the problem, that on a clients machine the program was ...
0
votes
0answers
15 views

Is column imprints applicable to string columns

I came across this secondary index 'column imprints' which is very interesting and effective. My usecase is, I want to know whether these imprints can be applied on string columns. I found monetdb ...
0
votes
1answer
38 views

How do I convert sql to excel syntax?

I have two sheets in an excel file, "sheet1" and "sheet2". The first sheet has a table called Oranges, it shows where the oranges were produced and where they were exported to: On the second sheet ...