Questions tagged [connections]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
21 views

SQL Server Identifying Connections that are utilising SQL from an application

Is it possible to identify connections in SQL Server 2014 that are utilising SQL that is passed from an application as opposed to calling an SP ?
0
votes
1answer
25 views

Warning message: invalid value for parameter “default_tablespace” in postgres

I create a new tablespace using the following script: CREATE SCHEMA semiarido; CREATE ROLE semiarido PASSWORD 'senha'; GRANT CREATE ON SCHEMA semiarido TO semiarido; GRANT USAGE ON SCHEMA semiarido ...
1
vote
0answers
33 views

2020-07-29T07:44:29.817503Z 108716 [Note] Aborted connection 108716 to db:

We are getting continuously logs in mysql error logs 2020-07-29T07:46:56.534666Z 111536 [Note] Aborted connection 111536 to db: '' user: '' host: '' (Got an error reading communication packets) we ...
0
votes
0answers
5 views

How to create hs oracle to SQLSERVER with rac scan

hi i am trying to create an hs for oracle rac for a course but i am unable to configure the hs How to configure the listener with scan_listener? hs example: odbc windows64 bits system dns: ...
0
votes
2answers
44 views

How Are SQL Server Clients Connecting?

I am asking two questions in this post. If I see activity in netstat with port 1433 for an unnamed instance, whose tcp addresses are not enabled, what does that mean? What is the preferred way to ...
1
vote
2answers
35 views

Why would I download CA certificate when starting a managed Postgres cluster on DigitalOcean?

I am trying for the first time a Postgres cluster provided as a managed service by DigitalOcean.com. As part of configuring the new cluster, their web interface gives me a user name, password, port ...
0
votes
0answers
17 views

Can't connect to Azure Database for MySQL server

I created a resource in azure: "Azure Database for MySQL server". I added the firewall rule to connect from my ip. It is a fixed IP. When I try to check if the socket open it works: When I ...
0
votes
0answers
7 views

MySQL8 leaves railing connections open

We're looking to upgrade our stack from MySQL5.7 to MySQL8. We are using a standard LAMP system on ubuntu16, php7.0 and symfony 2.3 . On our tests, I have noticed that there is a lot of trailing ...
0
votes
1answer
19 views

Why do I have 2 connections when im using 1 client?

The command: select * from pg_stat_activity shows all currently active connections. The database is hosted by AWS RDS and I am accessing the database with pgAdmin 4, thus I expect one other ...
0
votes
0answers
38 views

Postgres memory usage grows over time, resets when clients restarted

I have a Postgres DB running on the same small server as some applications that use it. Immediately after restarting the applications, Postgres uses <100 MB memory. After a few days without ...
0
votes
1answer
38 views

Why would the user matter when running a query?

I have a web page with a database lookup that contains multiple optional parameters. When I select a couple of parameters and run the query, it returns in less than two seconds. However, when ...
1
vote
1answer
434 views

How to see unclosed PostgreSQL connection while using psycopg2? [closed]

I run python code: con = psycopg2.connect(some_dsn) cur = con.cursor() cur.execute(some_sql) res = cur.fetchone() #con.close() <-- connection is not closed Then I try: ps auxf | grep postgres ...
0
votes
0answers
95 views

No Tables or Views Could be Loaded

Could not retrieve the table information for the connection manager 'Excel Connection Manager 3'. Failed to connect to the source using the connection manager 'Excel Connection Manager 3' How to ...
1
vote
1answer
142 views

SQL Server Encrypted Connections - Configuration Manager does not see Certificate

My goal is to implement encrypted connections on Test SQL Server instance First, tried to create self-signed certificate in the Certificates snap in (certlm.msc), Personal > All Tasks > Request New ...
1
vote
2answers
235 views

Queries on large database kill connection to the server, works with LIMIT

I'm trying to run queries on a large-ish database without killing the connection to the server. I'm using Postgres 12.1 on a mac with 16gb of memory, and about 40gb of free disk. The database is ...
1
vote
1answer
184 views

How many pool connection size should be set for a 1000 users Jira system?

For a Jira system, if use Jira's default connection configuration as below: <?xml version="1.0" encoding="UTF-8"?> <jira-database-config> <name>defaultDS</name> <...
0
votes
1answer
30 views

SQL*Loader and DC firewall timeout

We are loading a huge dataset using SQLLDR and there are index creation that lasts for a couple hours or even more. Firewall drops this connection as there is no data transfer during index creation ...
0
votes
1answer
45 views

Remote connection scheme without Windows Authentication/Domain in detail [closed]

There is a legacy C++ system that needs to be "translated", that uses ODBC for connecting to remote SQL Server Database. System is distributed to many different OS and different domains, some always ...
0
votes
0answers
36 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
38 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
223 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
209 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 ...
1
vote
2answers
846 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
193 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
226 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
173 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
28 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
60 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
20 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 ...
1
vote
0answers
217 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
43 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
73 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
115 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
39 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
24 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
46 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
32 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
27 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
50 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
39 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
372 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
360 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
857 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 ...
11
votes
5answers
3k 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
314 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 ...
6
votes
2answers
748 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
507 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: ...
1
vote
1answer
2k 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
3k 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 ...