Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [connections]

One or more connections to a database or database server. For questions about *establishing* a connection, use the **connectivity** tag instead.

-1
votes
0answers
9 views

I can establish local remote connection to PSQL database, but I can't make a public remote connection

Currently, I am able to connect to my Ubuntu 18.10 Laptop's PostgreSQL 11 users from my Windows 10 PostgreSQL client. Both computers are in the same house. I did this by writing down my local IP ...
1
vote
1answer
17 views

MySQL Server :: My C Code can remotely create a database, but not “INSERT INTO” it

I’ve written a C program which does the following when it starts: Connects to a remote Linux MySQL server over the network Creates a new, uniquely-named database Sends a “USE _____” command to ...
0
votes
2answers
46 views

MySQL performance tuning related connection

I am running openstack cloud and it use mysql database which is MariaDB 10.1.30 I am sometime seeing connection reset from multiple clients, to trying to find out what is going on in database, I am ...
0
votes
0answers
36 views

PostgreSQL 11 and pgagent connection string issue

On PostgreSQL 11 running on Windows 2012 server, I created a job with pgagent and pgAdmin4. In the step, in connection string I used the password parameter and it works. Instead, I would like to use ...
2
votes
0answers
55 views

How do I do an ODBC connection to ORACLE from SSIS/ Visual studio?

Despite that OLE Db and ADO.NET are newer than ODBC potentially, I've heard that ODBC connections to Oracle are potentially faster within SSIS. So --- I'm trying to set up a simple ODBC connection to ...
10
votes
5answers
1k views

How to deny access to SQL Server to certain login over SSMS, but allow over .Net SqlClient Data Provider

We have a situation where Developers do not have any UPDATE permissions, BUT they work with applications and see connection strings -> they know passwords from some SQL accounts (example SQLLogin1) ...
0
votes
1answer
38 views

MySQL stalls and strange threads/connections behavior is observed

We have a MySQL instance which most of the time works just fine. From time to time, however, we observe strange behavior. What happens is that suddenly MySQL connections reach the limit (currently set ...
0
votes
0answers
48 views

Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

Getting one issue in error log in every 30-45 mins. Mysql version 5.6.20-log Server is slave of master main server and its having 100 slaves to this server. Replication hierarchy is there in 3 stages. ...
6
votes
2answers
147 views

Are CNAME aliases for connection strings a good idea?

To be very flexible and move database to different servers more easily, we came up with the idea of using an alias per database. So by simply changing a DNS entry, we can route all queries to a ...
0
votes
2answers
67 views

pg_dump: Write failed: Connection reset by peer

we are trying to move all database data to other location. we chose to perform pg_dump and we encountered few problems: first was out of memory problem: during pg_dump initialization we get an error: ...
0
votes
0answers
19 views

Sharing read/write resources between connections in an unfair way

I have two applications that connect to a Postgresql database. A read-only application querying tuned MVs A write-only application updating the database and the MVs We only really require that (1) ...
0
votes
1answer
70 views

Can't connect to MS SQL Server via IP address anymore

I'm using a PLC connected to a laptop (over EthernetIP). The development software for programming the PLC has a built in settings page for connecting it to various database engines (MySQL, PostgreSQL, ...
1
vote
1answer
110 views

“Keyword not supported: Server” error when using ADO.NET connection string to connect to Azure DB

I have an ASP.Net project that I am running. I have added a database to Azure, and Azure generated a connection string for the database. When running the application I however get an error stating ...
3
votes
3answers
1k views

Database Connection vs Raw TCP Connection [closed]

I have some fundamental questions about how database clients & database interact Do databases support multiple transactions simultaneously on a single database connection from client? If not, why ...
0
votes
1answer
414 views

Keep H2 in-memory database between connections

I create and use a H2 database in-memory (no writing to storage) for demos and quick tests using this code in Java: Connection conn = DriverManager.getConnection( "jdbc:h2:mem:example_db" ) ; This ...
1
vote
0answers
315 views

Switching users in PgAdmin

I'm looking for a way to enable switching between users in pgAdmin 4. I'm aware of the possibilty to change user from the properties-dialog before connecting. However this isn't useful when I'm ...
2
votes
2answers
206 views

What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?

In Postgres 11, the CREATE DATABASE command that makes a new catalog has an option ALLOW_CONNECTIONS. The documentation says this option can be used to block all connections to the database: [ ...
0
votes
1answer
233 views

Can `listen_addresses` system configuration setting in Postgres stop pre-authentication exploits?

You can set various configuration parameters for Postgres by either editing the postgresql.conf file manually or by calling ALTER SYSTEM commands. One of those config settings is listen_addresses. ...
1
vote
2answers
34 views

MySQL: No. of Connections

I have a medium sized database (7 GB) with around 200 concurrent users. I am getting some database lag issues, suddenly my node-mysql client freezes during selects and inserts. As a process of ...
2
votes
1answer
62 views

What connection do internal sessions belong to in MS SQL Server?

By querying select * from sys.dm_exec_connections I do not see corresponding connections for internal sessions, about the existance of which I know from sys.dm_exec_sessions DMV. My questions is ...
0
votes
1answer
30 views

database connection and sessions in an example of social media

I am referring to MS SQL connection and sessions. I know that each application should make a connection in order to access the database, and each connection can have multiple sessions. In case of a ...
2
votes
1answer
1k views

Logon failed for login due to trigger execution

I have been trying to login using one of my sql server logins but I am getting the error message below: General Error Message Copy Message Text TITLE: Connect to Server -----------------------------...
2
votes
2answers
328 views

Cannot connect to <instance>. A severe error occurred on the current command

Recently, and on more than one occasion now, we have attempted to connect from one of our SQL Server instances to another using SSMS only to be greeted with the following error: A severe error ...
0
votes
1answer
79 views

Percona pt-table-sync Can't determine Master

We have following Multi master replication scenario. We are using MariaDB 10.1.34 and Percona 3.0.11 Master: Name: db-master1 (192.168.14.5) Slave: Name: db-slave2 (192.168.15.5) Replica Connection ...
1
vote
1answer
95 views

DBForge can't connect with MySQL server, server is running

I recently installed the latest version of MySQL Server. I initialized it with --initialize-insecure so I have a "root" user with no password set. The server is running, with the command mysqld --...
2
votes
0answers
510 views

Very Sporadic Cannot initialize the data source object of OLE DB provider “SQLNCLI11” for linked server

OLE DB provider "SQLNCLI11" for linked server "001" returned message "Unable to complete login process due to delay in opening server connection". Msg 7303, Level 16, State 1, Line 19 Cannot ...
2
votes
1answer
195 views

Stored Procedure Execute as Owner Close Database Connections Not Working

I created a stored procedure to allow users to Close All Db connections in the QA environment. I am SA and created the procedure. When I modify the SP , run it Without 'Execute as Owner', I get ...
1
vote
1answer
133 views

Mysql 5.7 cannot start again

For the first time in my life, I have Ubuntu, so I do not know much how to manage and what should I be looking for; I'm using version 18.04. I installed MySQL 5.7, it worked great for a couple of days ...
1
vote
1answer
18 views

Permission errors on insert after schema drop/create (Pg 9.0.23)

We have a web application that allows users to modify data through an API. In order to allow people to run tests, we provide a sandbox area called 'daily'. This sandbox gets refreshed every day from ...
0
votes
2answers
131 views

Unable to connect from remote computer, while local connection works

I have a Windows 2008 R2 64-bit server with SQL server 2008 R2 installed on it. I manage to log to SQL server with SSMS with the sa SQL account and with a test SQL account. But when I try to ...
0
votes
1answer
58 views

Having multiple ResultSets in parallel on same connection.. Will it cause any problem? [Mysql/Postgres] [closed]

I have tried out the following in my local machine using jdbc/mysql: step 1: conn = getNewConnection step 2: stmt1 = "new statement" using connection 'conn' step 3: stmt2 = "new statement" using ...
0
votes
1answer
389 views

“undefined function pg_pconnect()” when connecting to Postgres from CodeIgniter

I just installed Postgresql and pgadmin in my Ubuntu system. I can create a database from the pgadmin interface and everything seems ok, but when I try to connect to the database from my CodeIgniter ...
1
vote
1answer
406 views

in what situations the dynamic port number in sql server is used?

I have the following script to find out what is the Static and dynamic port numbers: --=============================== -- sys.dm_exec_connections --=============================== SELECT [user]=...
0
votes
2answers
43 views

Connections increasing by 10+ a second with no requests

I'm getting no answers from my host, but I suspect their DB servers are compromised. I was getting some ridiculous page loads for requests to a standard Wordpress installation - upwards of 30 seconds,...
1
vote
2answers
2k views

What reason could cause AWS RDS connections to

It's my first time using RDS on AWS, I use a t2.medium instance running MySQL Aurora with default configs. The CPU usage and DB connections is quite normal until "something" happen, which cause the DB ...
1
vote
1answer
385 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 ...
0
votes
2answers
2k views

Oracle Client sessions keep disconnecting

We recently moved our Oracle server from a remote location to a local server and now the Oracle clients keep disconnecting. It does not seem to be a timeout issue because it happens while we are ...
0
votes
1answer
58 views

Check connection details to SQL Server 2000/2005

I want to migrate some databases hosted in SQL Server 2000/2005 to SQL Server 2014. I don't have direct access to the databases and I want to know all applications connecting to it and connection ...
0
votes
2answers
1k views

Cannot connect to mongos

Following the MongoDB Sharding Documentation, I start a mongos using a configuration file with the specifics of my config server. It seems rather straightforward, yet I am running into an issue. I ...
0
votes
0answers
51 views

How do I set up an Active Directory group to use with DSN-less linked tables from MS Access to SQL Server

I have set up a group in Active Directory. I have added all my users to that group. I have set up a login for the group with default database as mydb. The login is a member of the public server ...
1
vote
1answer
463 views

Azure SQL Databases: High number of SA connections with “BRKR TASK” and “TASK MANAGER” commands

Found out that all our Azure SQL Databases (pricing tiers S1-S2) have high number of connections/sessions from SA SA - BRKR TASK - around 60 sessions SA - TASK MANAGER - around 20 sessions Here are ...
0
votes
1answer
51 views

What if a connection closes in the middle of a commit?

I have a few large CSV files to upload to an instance of SQL Server.(Nope, can't use SSMS) I'm using JDBC to read the CSVs line by line and insert the lines in a table in batches. Supposing my code is ...
1
vote
2answers
228 views

SQL server 2008R2 default encryption?

I was wondering if SQL server 2008 R2 has any default security if you're using it via ODBC or SQL Server Management Studio? I was reading about SSL here https://technet.microsoft.com/en-us/library/...
0
votes
2answers
343 views

How to connect from local computer (mac) to remote Oracle DB and execute script and save results to CSV?

I can connect to remote Oracle DB using this signature: sqlplus 'user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))' Now want to ...
0
votes
1answer
1k views

Python Postgres psycopg2 ThreadedConnectionPool exhausted

I have looked into several 'too many clients' related topic here but still can't solve my problem, so I have to ask this again, for me specific case. Basically, I set up my local Postgres server and ...
1
vote
0answers
160 views

Postgres vacuum drops connections

I receive randomly errors for database connections, like: socket closed. I observed postgres logs and found suspicious line: database system was interrupted. Can that happen that postgres drops the ...
1
vote
0answers
287 views

Keeping MySql connections alive

I'm running a Windows service, which connects to a MySql database via Entity Framework. Every 10 seconds it issues a query to the database to see if any new records have been added. If it finds any, ...
1
vote
1answer
1k views

Reasonable values for thread_cache_size in relation with Connections [closed]

I want to know reasonable values for thread_cache_size in relation with the connections that you have. Which is the good proportion? And which proportions do you handle in relation with your clients ...
0
votes
3answers
117 views

How to limit the number of sessions for a specific login [closed]

How can we let just one program to connect to the database, in case many programs have the connection string. (limit the number of sessions for a specific login)
1
vote
1answer
153 views

SQL Server Error “Database 'mssqlsystemresource' does not exist.”

On Linux, whenever I run use mssqlsystemresource to get access to Resource Database, I get an error. How do I resolve this. 1> use mssqlsystemresource 2> go Msg 911, Level 16, State 1, Server ...