Category "database-connection"

Access database error in R (RODBC connection)

I'm trying to get data from an Access database by using the RODBC package, but I get this error: Error in sqlTables(c) : first argument is not an open RODBC cha

How can i pass database name dynamically in ssis execute sql task

In my server there are multiple databases. Hence having multiple connection manager for each db on server. Would like to pass database name as parameter in exec

Access mysql running on localhost from minikube

I am running some services in minikube and trying to connect to mysql running on localhost(127.0.0.1) on 3306 port. I read this and trying to create service a

Laravel MSSQL Server Connection not working

Laravel version:7.13, SqlServer:2019 SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: An existing connection was forcibly closed by

sqlite cannot connect to database error: java.lang.UnsatisfiedLinkError: org.sqlite.core.NativeDB._open_utf8([BI)V

I get the following error: I have this code I have tried several things going before I posted this, I determined that this was the source error it did not conne

Errors when connecting to MySQL local database

So, I have my local database, set it up, ran it from the windows services window. I open MySQL Workbench, and try to connect to the server. Hostname is localho

Mysql2 connection in ruby always take my Ip address to connect and ignores the value in host

I am trying to connect to my database through mysql2 in ruby with the following: client = Mysql2::Client.new(:host => host, :username => username, :passw

Connect to Postgres from Swift

In a Swift app, how does one connect to a Postgres database server? In Java, we use JDBC with an compliant driver to connect to a Postgres server, communicate

cant create a database in DBeaver

im just starting using databases and I'm working with PostgreSQL using Dbeaver. When I want to create database,i need to create a new connection ,so I select Po

Single Large Transaction VS Multiple Small Transaction

I am designing a system where users can select/ insert/update/ delete multiple rows of multiple tables multiple times (n times in a loop based on some logic, th

Getting intermittent error java.sql.SQLException: ORA-01005: null password given; logon denied issue

I am creating database connection pool using Hikari and it connects and create connection pool successfully on application startup. Application also works fine

Correct Way of using Redis Connection Pool in Python

How should two different modules foo.py and bar.py get a connection from a Redis connection pool? In other words, how should we structure the app? I believe th

MySQL connection and disconnection frequency

Is it better to open and close a new MySQL connection every time a query is made or to keep the connection open and run multiple queries in a single MySQL sessi

MySQL connection and disconnection frequency

Is it better to open and close a new MySQL connection every time a query is made or to keep the connection open and run multiple queries in a single MySQL sessi

unable to import MySql.Data.MySqlClient

I have created a website that uses a MySQL database, but when i put it online, it doesn't work anymore. in my class connection.vb that i use for my connection t

PostgreSQL could not receive data from server: Software caused connection abort (0x00002745/10053)

I tried to establish a connection in pgAdmin to the PostgresSQL server. I always get the message: could not receive data from server: Software caused connectio

Why we need Weblogic Inactive Connection Timeout

If a connection is 'inactive' I guess the Weblogic internal data source manager should recover the connection. Why should 'Inactive Connection Timeout' be a con

Connection to SQL DB with Cypress

I'm trying to connect with SQL db using cypress followed the NPM guide . All the dependencies are exactly as mentioned but on running this cy.sqlServer('SELECT

Connection to SQL DB with Cypress

I'm trying to connect with SQL db using cypress followed the NPM guide . All the dependencies are exactly as mentioned but on running this cy.sqlServer('SELECT