Questions tagged [windows-10]

The tag has no usage guidance.

18 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
291 views

All but one of my SQL Server 2017 databases are GONE after Windows 10 nightly update failure

EDIT: Restored to a restore point from three days ago, prior to a "Critical Update", and the databases are back. This is, I believe, the culprit update: September 10, 2019-KB4514601 Cumulative Update ...
2
votes
1answer
741 views

Connection's MAC address randomly changes on Windows 10, then stops

Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications). We do ...
2
votes
0answers
3k views

How to relax file permissions conditions on postgres database folder?

Postgresql service refuses to start if the data folder (PGDATA) doesn't belong exclusively to the postgres user (i.e. permissions = 700). Is there any way to disable or circumvent that condition? ...
1
vote
0answers
769 views

ODBC from Win10 32bit client only connects using IP address, but not using hostname

I'm experiencing a pretty strange problem. We're using a MS SQL based quality assurance software. The database is hosted on a MS SQL 2016 Std. server running on a Windows Server 2012 R2 VM. Our ...
1
vote
0answers
59 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
1
vote
0answers
556 views

PostgreSQL service stops immediately after installing Windows Fall Creators Update 1709

The server itself runs fine with pg_ctl -D <datadir> start But the service stops immediately ("...Some services stop automatically if they are not in use by other services or programs") ...
1
vote
0answers
551 views

How to run Oracle Client 10g from non Administrator account?

Hi I have 2 users configured on my Windows 10 Home machine. One is Administrator and another is my own user. Although my user is configured as an Administrator, I can use Oracle Client 10g from my ...
1
vote
0answers
102 views

How do install and configure Grid Infastructure on Windows>

I'm studying for the 1Z0-062 exam with John Watson's exam guide and I'm trying to install Grid Infrastructure alongside my Dbhome. The book seems to run an installer that displays a configuration ...
1
vote
1answer
133 views

SQL server memory pressure

First observed few months ago at end-user's laptop (rather slow i3 CPU, 4GB RAM, SSD) with SQL 2014 Express. The problem persists with SQL 2019, even with clean Windows 10 1903 installation. The ...
0
votes
0answers
2 views

dbeaver connection cannot change driver properties schema

For the dbeaver connection, edit connection (Athena JDBC, i.e. AWS daata lake), "driver properties" tab: I cannot change driver properties schema field (default) anymore. This used to be ...
0
votes
0answers
25 views

What is the alternative of PL/Java for PostgreSQL 11 and 12?

Understand from: https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/user-guide/11/EDB_Postgres_Advanced_Server_Guide.1.80.html that PL/Java is deprecated in Advanced ...
0
votes
1answer
388 views

Connect to WSL2 Postgres database from local network

I run Postgres 12 service in Windows Subsystem for Linux 2 (WSL2). In my /etc/postgresql/12/main/postgresql.conf, I have: listen_addresses = '*' while my /etc/postgresql/12/main/pg_hba.conf has this ...
0
votes
0answers
31 views

Essbase installation on windows 10 : problem with prerequisites

I would like to install essbase on windows 10 pro, but I have some problems. I followed this tutorial : here by changing the OS to windows and version to the latest. I picked the files corresponding ...
0
votes
0answers
182 views

Import table data using multiple sql file in psql

Local Machine(l1): Windows 10 psql Remote Machine(R1): linux EDB(postgres) On my local I have 1000+ sql script containing insert statement . psql is also installed locally . I need to run this sql ...
0
votes
0answers
2k views

Failed to add 'Admin user' to %2% user group in Oracle 19C Windows 10 installation

Oracle 19c installation fails with this error message. I am trying to set up oracle for my 'Existing Local User' account Installation logs tries to add Admin user to all groups and fails .it says ...
0
votes
0answers
435 views

PostgreSQL: "PANIC: out of memory"

Got an error while running an application connected to a PostgreSQL DB (10.12). All the connections got disconnected, looking through the server logs, I found the below. TopMemoryContext: 292488 ...
0
votes
0answers
99 views

Sybase 8 to Sybase 16 migration in Windows 10 OS

Currently we are using Sybase 16 db in our project. But there are few Sybase 8 db's (that clients are using in market) that needs to converted to Sybase 16 for any patch testing. I used to use the ...
0
votes
0answers
421 views

Vanilla installation of MySQL on Windows 10 fails, service cannot start, corrupt InnoDB page

I started with a clean machine (Windows 10, 64bits), no previous installation of MySQL. I downloaded MySQL Installer Web Community 5.7.20.0, and installed the following: MySQL Server 5.7.20 (x86) ...