Questions tagged [database]

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.

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

TypeORM: Can you put multiple data migrations in one file? [migrated]

I have a data migration that calculates some data based off one column ("column1") in a table, and then inserts that data into another column ("column2") from the same table. Using the TypeORM, it ...
0
votes
0answers
10 views

Connecting to DB in LAN from outside

I've spent a lot of time on research and various tests with no luck Relevant topics from the forum Why can't I access my web server from outside the network? how can I access my server from ...
0
votes
0answers
19 views

How to reference a value from the n th in worksheet and move to the m th row in different worksheet

I have a group of data in worksheet 1 which is under a similar category every 4 rows 9 (i.e category A) I need a copy/Reference of the group/blocks data in a worksheet which as a pattern for every 25 ...
0
votes
0answers
19 views

Importing huge dataset held in POWER PIVOT table to Microsoft ACCESS

Background I am trying to make a database, but am having issues importing data into microsoft access. I have huge files, 4000,000 rows long and each one needed merging with much smaller tables. What ...
0
votes
1answer
42 views

Access Database repeatedly “in an inconsistent state” and “caused a serious error” - recurring issue

We have an Access Database that lives on a server in a shared folder. A few months ago the database was unopenable due to error messages like: The document caused a serious error the last time it ...
0
votes
0answers
25 views

What is the best way to store and use big JSON data?

I have downloaded a bibliographic corpus that consists of 10,000 zipped JSON files with the total size of ~200GB (zipped, ~800GB unzip) I have no experience in dealing with this amount of data, and I ...
1
vote
3answers
124 views

How to downgrade MS SQL Server 2019 Enterprise (evaluation) to Standard (purchased)?

SQL Server 2019 was installed in evaluation edition. When entering the activation code for a purchased copy of Standard edition I received the following message: I entered the activation code that is ...
0
votes
0answers
32 views

Set Default Directory to export table for SQL Developer

Is there a way(from config file or GPO or other) to set, for all Users, a default(and same) directory for the Export of DB on SQL Developer 4.0.1? I need that all User store the file in C:\[DirName]
0
votes
0answers
6 views

Google Search and user display name [migrated]

I made a google search of my full name to see results related to my name on the web using chrome. I had some YouTube videos results and wondered how these videos are chosen to appear on results. ...
0
votes
1answer
13 views

Connecting to an SQL database

When I am using the database connection wizard to connect to the database I type in DB server IP & credentials but it does not display any available database in list to select. Are there some ...
3
votes
1answer
30 views

Identifying old files types

I have three files with these extensions ".mrf, .md5, .ptr" that were created in 2009, 2007 and apprx. 2012 respectively. I know that file types could be different than the extension. For example, ...
1
vote
3answers
60 views

How to reorganize vertically repeating data to horizontal?

I have data on 1 variable from 1970 to 2017 from all the countries in the world. this data is organized as one large vertical list, with first a column with the (repeating) country name, then a column ...
0
votes
0answers
18 views

Strange MS Access Behavior - is this corruption?

Not sure where to turn with this. We have no MS Access Experts, but of course, we have a bunch of Access databases floating around that people use All of a sudden, on 4/1, a given database lost all ...
0
votes
0answers
20 views

Can I OR two field/item pairs in GETPIVOTDATA in excel?

Adding more optional fields to the GETPIVOTDATA function effectively "AND"s them together, which is fine. However, what about other boolean operations? In my specific example I want to "OR" two fields....
0
votes
0answers
23 views

How to correctly retrieve data from a table passed from a function?

What I am trying to do is returning a table from a function (ListBuilds) that retrieves it from a database. Then places rows from that table into a ListBox so that a row can be selected. The problem ...
1
vote
0answers
24 views

postgresql: can't select DB from windows with a restricted access setup

I have a remote machine, that has to access a DB on my server. I explicitly granted access with: host dbname dbuser 192.168.1.0/24 md5 and when testing from another linux machine with the ...
0
votes
0answers
13 views

Why are some connections in Oracle SQL Developer green and others not?

I have 3 connections I use all day on SQL Developer, but I can't but wonder why some are coloured green and another black: Both connect and work in what seems to be exactly the same way, so why is ...
0
votes
1answer
21 views

Take backup of SQL database from remote server to local computer across domains

So in this scenario there are two computers: A remote server hosting SQL that is not connected to a domain. A local computer that is connected to a domain. SQL Server Management Studio is installed ...
0
votes
0answers
21 views

Can't create Metasploit databases

I installed Metasploit Framework and started it. I got the proposal to create new databases. When I typed 'yes' I got mistake, because permission was denied. So I tried did it as superuser, but MSF ...
0
votes
1answer
25 views

Wordpress error connecting to database but it's correct

I've been struggling to find the problem but I just seem to be going around in circles and most of the tutorials just tell me to check the mysql credentials but I'm sure that they're right. I have an ...
0
votes
1answer
85 views

How should I set up volumes for multi-task database service in docker swarm?

I am new to Docker and I want to do mini-project with Docker Swarm. I built docker image with my Django app. In dockerfile I added project files, migrated all models, and then ran server. Now it is ...
0
votes
0answers
14 views

Upgrade VERTICA --> update_vertica --> Error: setHost called with empty host list

If you run update_vertica and get the following error you are probably using sudo which break the script. To fix the problem try first: su - root Error: setHost called with empty host list ...
0
votes
1answer
21 views

removing BerkeleyDB rows using Perl

I have no experience with Perl or BerkelyDB. I have a huge BerleleyDB with a list of email and a unix timestamp. I need help to remove email with older timestamp , older than 100 days . I have this ...
0
votes
0answers
53 views

How to link multiple fields in two different tables in MS Access

I am teaching myself MS Access to set up a master contact list and I am running into a problem. I have table of PEOPLE and a table of ORGANIZATIONS. In tbl_PEOPLE I have multiple fields including ... ...
0
votes
0answers
24 views

Is there any way to recover deleted messages from Skype?

I've been looking for it and can only find the old files from before some update. I've looked here: C:\Users\name\AppData\Local\Packages\Microsoft.SkypeApp...\LocalState\name and here: C:\Users\...
0
votes
0answers
17 views

How to relate columns in a table to a specific type?

I'm building a data model for an application. I'm relatively new to data modeling. I feel like there should be a textbook answer for the problem I'm struggling with, but don't know what the right ...
0
votes
0answers
41 views

Are there tests I can run to check if a Windows 10 computer flushes buffers when told to do so?

I'm currently investigating SQLite database corruptions caused by power failures. I read that corruptions could happen if a disk drive does not sync exactly when it's asked to do so from the ...
-2
votes
1answer
44 views

Connect to Database between two computers without internet [closed]

I want to connect my database on another computer without internet with a LAN cable, I've tried connected 2 machines with a LAN cable but it didn't work with database. My application works offline. ...
1
vote
0answers
88 views

Can't connect to virtualbox postgreSQL from host using navicat

I am currently trying to set up some databases using PostgreSQL 9.4 on a guest VM using VirtualBox running centos 6.5. I'm trying to connect to the database using navicat from the host but all it's ...
0
votes
1answer
55 views

Auto update cell

Is there some formula which can be used for cell linking. means if I type something in cell A1 and want some wanted result in B1. For example I type "A" in Cell A1 and it shows "Apple" in Cell B1 I ...
0
votes
0answers
28 views

Plesk: encrypt/hide specific database from other admins

Is it possible to hide or encrypt a specific database (or its contents) from other users with same privileges in Plesk linux?
0
votes
2answers
52 views

Easiest method of displaying how many instances for each hour?

I have a call log which has thousands of calls in it. Each call is an entry in a CSV file which includes a datetime stamp. What I would like to be able to do, is easily view how many calls there are ...
0
votes
0answers
28 views

Send an image to my database server

I am currently working on a webscraper that downloads an image and its title, description etc. from a website. The device that runs the scraper programm is my raspberry pi. I want to store the image ...
0
votes
1answer
29 views

How to plot longitudinal data in R

I am trying to plot longitudinal data in R. My data frame has this form: participant_ID group S1 S2 S3 S4 S5 S6 S7 S8 1 ctrl 14.00 14.00 13.00 13.00 7.00 8.00 4.00 1.00 2 ...
0
votes
0answers
94 views

Oracle limitation for Materialized View on a remote Table (via DB Link) having a nullable CLOB column

I recently ran into a problem with Oracle whereby I have a materialized view which maps 1:1 to a target table in a remote database over a db link. The target table has multiple columns, one of which ...
0
votes
0answers
21 views

Remote Jupyter Notebook - Working with Git

I am working on a jupyter notebook which is on a remote server, this is done though ssh-tunnelling (see here for details). My issue is that I now want to enable Git in my project, and allow all the ...
1
vote
0answers
33 views

During data import Access doesn't recognize all of the named_ranges available in excel file

As I described in the subject, during importing Excel file into an Access made database I'm facing an issue of Access not seeing all of the named_ranges I created in my Excel file. This is the data I ...
0
votes
0answers
101 views

How to avoid “View any definition” permission warning in Visual Studio?

I'm relatively new to Visual Studio. In comparing my project to my SQL Server database I am getting the warning: "The login for the target does not have the VIEW ANY DEFINITION permission. The ...
0
votes
0answers
57 views

ORA-12520: TNS:listener could not find available handler for requested type of server

I try to connect to a remote database using sqlplus but not able to connect only to particular database server.I am able to connect to other server databases.I checked listener services,tnsping,...
0
votes
0answers
18 views

Prisma can not edit database model

I edited fields of my database model via datamodel.prisma and deployed it, but nothing was changed in my database. To add some new fields works, but to edit or to delete some field not works... ...
1
vote
0answers
91 views

Access denied for user in DMS instance

I am trying to set up a data replication task with AWS DMS (MySQL to MySQL). The endpoint configurations have been successfully tested but the task is not terminated because it gives the following ...
0
votes
0answers
54 views

Issue in installing Oracle DB 11G in Oracle linux

I am trying to install Oracle DataBase 11g in oracle linux 7.1 , I have performed pre-requisite checks of system configurations as per oracle given matrix and also have created oracle user and dba,...
0
votes
0answers
56 views

I want to retrieve old viber messages from the viber.db file. Ive ran an sql query but I receive an error saying its not a database

I've recovered the viber.db file using recovery software, and have tried viewing it using different applications but I keep receiving the error 'its not a database'. Can you help me? Thanks.
0
votes
0answers
53 views

firebase admin Error

I have this structure to make a admin data-base date by promtp of an application for firebase ... the structure is the following: var admin = require("firebase-admin"); var serviceAccount = require("...
1
vote
0answers
84 views

sql-server in Kali Linux for Python

When I am trying to install MySQL-server in my Kali, I am again getting an error. Then, I tried to install something else like apt-get install MariaDB-server. It was installed, but afterward when I ...
0
votes
0answers
23 views

Migrating from one Data Modeler to another (Toad Data Modeler to Enterprise Architect)

I have been using Toad Data Modeler 6.5. The free trial is up, and my company just bought "Enterprise Architect". Is there a way to convert the Toad Model project (.txp) to Enterprise Architect ...
1
vote
0answers
13 views

Ripping or downloading large number of selected pages from wikipedia

I require only subject related articles from wikipedia i.e. ,not the entire database but specific pages, for offline viewing and reference purpose. the download page of wikipedia allows download of ...
-2
votes
1answer
60 views

Neo4j Apt Key Refused

I am trying to install Neo4j on a Debian system, thus I have opened the page https://debian.neo4j.org/ and followed the instructions. I had no problem with the first two command, but when I executed ...
1
vote
1answer
6k views

Mongodb+mongoimport+uncaught exception: SyntaxError: unexpected token: identifier : @(shell):1:15

Getting below error while importing a csv file in MongoDB database. command: mongoimport -d test -c FAQ --drop --type csv --file C:\Users\KUMA\Desktop\FAQ.csv --headerline --host localhost:27017 --...
1
vote
0answers
12 views

How to give phpmyadmin privileges to create databases?

How do I grant phpymadmin privileges to create databases?

1
2 3 4 5
17