Questions tagged [connections]
One or more connections to a database or database server. For questions about *establishing* a connection, use the **connectivity** tag instead.
181
questions
0
votes
0answers
26 views
Estimate of number of connections to a sql server instance
I want to get a proper or near accurate count for the number of connections in a sql server instance.
I have been using different queries from internet and i see that some people use dmvs ,some people ...
1
vote
1answer
29 views
Audit logins and logouts [duplicate]
I need to trace and monitor client login connections (successful and failure) to our important SQL servers (20 MSSQL Server). What method do you recommend?
Note: I think enabling "both failed and ...
0
votes
1answer
43 views
Same session ID(with same SQL text) but 3 different connection ids
I was listing out all sessions open in my sql server 2016 production server.
I have issues with slow performance and i have been investigating it.
I see that i have several same sessions(session_id) ...
1
vote
2answers
56 views
SSMS How do I open a new Query Window using Same Connection Instance of current Window
Coming from Oracle I have discovered that SSMS connects slightly different than Oracle's SQL Developer. Oracle you click ONE connection and then all tabs you open then use that Connection. SSMS ...
0
votes
2answers
70 views
How to connect using PDB userid on Oracle 18c XE?
I have created a PDB on Oracle 18c XE using following SQL command
create pluggable database virlux
admin user test1admin identified by test1pwd
file_name_convert = ('/pdbseed/', '/test1/')
;
Now, I ...
3
votes
1answer
179 views
Record MultiSubnetFailover value at connection?
With AlwaysOn, there are 3 options for the keyword MultiSubnetFailover
True (yes)
False (no) (example)
Not sent/used
Not all applications support it's use in connection strings. Not all vendor ...
1
vote
2answers
73 views
MySQL 5.6 — How do I tell if I need to increase innodb io thread setting?
I am trying to tune my mysql server for the high end system. We are using 16--32 core hosts with memory > 100GB.
I have looked into a bunch of existing setting, but not sure if I need to tune up the ...
2
votes
1answer
126 views
User connections without a login
I was looking at SQL Server performance and noticed that CPU utilization goes high when the number of connections go high(I believe it is normal).Usually number of connections on an average was ...
0
votes
0answers
17 views
Mysql 8. Event call Stored Procedure with Transaction to Federated tables never finish ESTABLISHED connection until timeout
We have a Mysql server which connect to remote Mysql Federated tables and copy data to local tables.
For several databases it works fine, but the new one did not close connection after Transaction ...
0
votes
1answer
26 views
ODBC connection with RD Gateway [closed]
here at my company, we use an RD Gateway server.
that means when we want to access a server we have to set up the gateway in the connection...something like rdsgw.mycompany.com
But, how could I do an ...
0
votes
1answer
14 views
how to change the driver of a ole_dbconnection from oracle_32bit to oracle_64bit
i have the connection string of:
connection= new OleDbConnection("Provider=OraOLEDB.Oracle;UserId=userid;Password=password;
Data Source=database;OLEDB.NET=true");
However after Oracle_64bit driver ...
0
votes
0answers
30 views
Aborted connections (Erros reading communication packets)
I set up a new Database Server over a SQL Dump with innoDB MYSQL 5.7 from MYSQL 5.6. The Server running external with many sleeping SMTP connections over 1 Mio a day. I made the server open for ...
0
votes
1answer
41 views
Is It Okay to Leave the Connection Open and Set CommandTimeout for Long Durations?
I have to process daily files and it's a long process that deletes, imports and updates processes. Like literally 20 to 30 minutes per file for several files a day.
** EDIT: I also have some ...
0
votes
0answers
33 views
Is sp_getapplock recommended for long running locks (> 10 minutes)?
I'm trying to get rid of a Redis dependency in our application.
We notice that is worse for our uptime to have a dependency on both SQL and Redis, above the performance benefits Redis would give us.
...
1
vote
0answers
32 views
What is “direct client connections” to Oracle?
The Oracle document states:
A read/write database instance, which is the default, can process DML and supports direct connections from client applications. In contrast, a read-only database ...
2
votes
2answers
87 views
MSSQL over the internet but we connect over RDP
We connect throguh RDP to our ERP solution which uses MSSQL 2008, right now I can see on windows logs and SQL logs that we have a HUGE amount of connection attempts to sa user and results in slow ...
0
votes
1answer
35 views
What is a connection in MySQL Workbench?
I've searched so much and still found no answer to what exactly a connection is. I'm a beginner and don't know how connecting to databases/servers works, so I can't move forward yet.
What does the ...
1
vote
1answer
23 views
Way to check where the MySQL connection was initialized?
Is there a way to identify who created the MySQL connection?
For example:
in file a.php
$conn = mysqli_connect($dbhost, $dbuser, $dbpwd, null, $port, $socket);
I would like to know that this ...
0
votes
0answers
40 views
SQL Server DAC - Connection Issue
I am having a strange issue when trying to connect to my SQL Server instance remotely from my client computer. I am able to do this on my other instances by opening up a new Database Engine Query and ...
0
votes
0answers
18 views
Adding PostgreSQL data source to excel didn't ask for credentials other than server IP and database
I saw Excel supported using PostgreSQL as a data source. I'm used to using ODBC connections for Access so having direct Postgres support is exciting.
When connecting I entered the Server IP and ...
0
votes
0answers
26 views
SQL Mirroring - Application not pointing to new Primary
Im stuck with a connection string issue
this is my connection string.
<add name="APP01" connectionString="Server=10.169.0.2; Failover Partner=10.166.0.2; Initial Catalog=DB2017; Integrated ...
0
votes
1answer
35 views
Mysql Connections are string when checking from SHOW STATUS LIKE '%onn%';
I have a Mysql db server which seems to be getting slow by time. When i am checking detail from SHOW STATUS LIKE '%onn%'; I get following details
Variable_name Value ...
1
vote
1answer
29 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
208 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
247 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
613 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
2k 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
172 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
213 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
493 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
371 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
22 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
373 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
1k 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 ...
4
votes
3answers
2k 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 ...
-1
votes
1answer
2k 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 ...
2
votes
0answers
2k 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
333 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
442 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
74 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
90 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
41 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
7k 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
904 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
163 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
230 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 --...
3
votes
0answers
1k 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
287 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
308 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 ...
