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)

-3
votes
0answers
20 views

Connection of database in MySQL [on hold]

I am new to MySQL. I have installed MySQL Workbench 6.3 CE and created a database and one table, and I'm trying to get data from window form application. Following is code for connectivity: String ...
0
votes
0answers
11 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
18 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
14 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
19 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) ...
-1
votes
0answers
12 views

Script for gathering data from one remote server and insert result into another one

I looking for example/solution how to take data from one db and insert into another db. (both db are on a different server). Scenario: Connect to the remote DB and execute query SELECT Result of ...
0
votes
0answers
25 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
20 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
16 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
29 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
49 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 ...
0
votes
0answers
14 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
26 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
28 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
66 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
132 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
59 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
34 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
10 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
31 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
54 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
47 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
47 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
141 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
60 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
15 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
23 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
99 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
70 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
31 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 ...
1
vote
1answer
82 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
0
votes
1answer
59 views

Where can I find an RRD file specification?

I'm trying to write a Python program to directly pull information from RRD performance files stored on our servers at work, but the files aren't stored in plaintext format, and I cant find any ...
0
votes
0answers
35 views

AddContactFromOutlook command not working after splitting database

I built a small Access database to track my tasks and a have a few forms where I add clients and contacts. To simplify this, I used a build-in command to add the contact from outlook which worked ...
1
vote
1answer
30 views

MS SQL query which split to other table columns

I have two table: table1: |Manager | USER | +--------+------+ |John | Tom | |John | David| |John | Marry| |James | Henry| table2: Now is empty, but must be like: ...
0
votes
2answers
29 views

UTF-8 not recognized in SQL batch process through Putty

I have an .sql file with a few simple "Insert into" SQL commands that are being inserted into a table called Künstler. insert into Künstler (name) values ('Mariah Carey'); insert into Künstler (name) ...
0
votes
1answer
25 views

basic manipulation of sqlite tables

I have two tables in my .sqlite. These two tables are almost identical in terms of structure/content and I want one column of the first table to be replaced by one column of the second table. This is ...
0
votes
0answers
37 views

Can UltraEdit connect to a database (via ODBC) and send a query?

Is there a way for UltraEdit to connect to the database and send an SQL query? I am looking through their web site and try to find a way. I work with databases (SQL Server, DB2, SQLite and ...
1
vote
0answers
42 views

Is there any way(e.g. software etc.) where data can be matched visually

I have two columns in excel(see N.B.) that contain as below Column1 Column2 ------- -------- USA India Serbia United States of America Bharat China ...
-1
votes
1answer
25 views

commands to upload sql file to database

There is a database file in this path : /var/www/db.sql in server. Our database size is about 800mb. we have to upload this sql file to the database : "age" username : root, password : pass, ...
0
votes
1answer
36 views

Is it safe to connect (select, update, insert) to Oracle database 10G with a 11G client?

I have to work in an Oracle 10G database. The normally used client is Oracle SQLDeveloper. But it has some limitations not related to the database use (Java versions on my PC, but that is another ...
1
vote
0answers
19 views

How to display database/list online with images that show up when hovering over each row

I have this project of mine that ended up making me create an Excel database. Current state is 300ish rows x 15 columns. However, the project is getting to big for me to handle alone. I'd like to ...
1
vote
1answer
104 views

Phabricator installation - change database name prefix

I'm on a shared host and I'm in the process of installing Phabricator. One issue I've come across is created the databases for Phabricator, which want the following, phabricator_audit ...
0
votes
1answer
67 views

I need a software for converting hex file to readable text [closed]

I need some suggestions for software that can convert corrupted database file (in hex format) to readable text in one line. As you can see in the screenshot, I want that text in red box to be ...