tagged [database-connection]
SQL Express connection string: mdf file location relative to application location
SQL Express connection string: mdf file location relative to application location I am using SQL Express databases as part of a unit test project in c#. My databases is located here: I would like to u...
- Modified
- 14 May at 14:35
Setting up PostgreSQL ODBC on Windows
Setting up PostgreSQL ODBC on Windows I have the latest 64 bit version of PostgreSQL. I am running Win 7 64 bit. I had installed the ODBC driver (via the initial installer) when I installed PG, and up...
- Modified
- 22 Jul at 21:18
Correct way to close database connection in event of exception
Correct way to close database connection in event of exception Does the following code leave the connection open if there is an exception? I am using a Microsoft SQL compact edition database. ``` try ...
- Modified
- 16 May at 01:3
phpMyAdmin on MySQL 8.0
phpMyAdmin on MySQL 8.0 Newer versions of phpMyAdmin solved this issue. I've successfully tested with phpMyAdmin 5.0.1 --- I have installed the MySQL 8.0 server and phpMyAdmin, but when I try to acces...
- Modified
- 19 Feb at 12:43
Testing an Entity Framework database connection
Testing an Entity Framework database connection I have an app that connects to a MYSQL database through the entity framework. It works 100% perfectly, but I would like to add a small piece of code tha...
- Modified
- 27 Apr at 15:3
Warning about SSL connection when connecting to MySQL database
Warning about SSL connection when connecting to MySQL database With the two classes below, I've tried connect to a MySQL database. However, I always get this error: > This is the test class with the `...
- Modified
- 14 Sep at 07:36
MSSQL Error 'The underlying provider failed on Open'
MSSQL Error 'The underlying provider failed on Open' I was using an `.mdf` for connecting to a `database` and `entityClient`. Now I want to change the connection string so that there will be no `.mdf`...
- Modified
- 16 Feb at 09:31
Do I need to force a Dispose after a LINQ query?
Do I need to force a Dispose after a LINQ query? My DBA says that there are way too many connection open and he thinks it is my code in .net that is leaving them open. I am using LINQ querys and EF co...
- Modified
- 20 Feb at 05:19
Closing database connections in Java
Closing database connections in Java I am getting a little confused. I was reading the below from [Java Database Connectivity](http://en.wikipedia.org/wiki/Java_Database_Connectivity): ``` Connection ...
- Modified
- 6 Feb at 12:2
How does spring.jpa.hibernate.ddl-auto property exactly work in Spring?
How does spring.jpa.hibernate.ddl-auto property exactly work in Spring? I was working on my Spring boot app project and noticed that, sometimes there is a connection time out error to my Database on a...
- Modified
- 3 Oct at 13:54
Database application.yml for Spring boot from applications.properties
Database application.yml for Spring boot from applications.properties I've got a working Spring Boot Application that connects to a Postgres database. I've got the project set up with an application.p...
- Modified
- 11 Jan at 12:41
OracleConnection.Open is throwing ORA-12541 TNS no listener
OracleConnection.Open is throwing ORA-12541 TNS no listener So I am connecting to an external server through C#. I just installed client on my machine from here: [http://www.oracle.com/technetwork/dat...
- Modified
- 24 Sep at 19:16
ExecuteReader requires an open and available Connection. The connection's current state is Connecting
ExecuteReader requires an open and available Connection. The connection's current state is Connecting When attempting to connect to MSSQL database via ASP.NET online, I will get the following when two...
- Modified
- 18 Apr at 14:11
Servicestack MySql connection string
Servicestack MySql connection string I'm trying to figure out how to create a connection string in Servicestack for (in this case) MySql. The question is: what is the connection string in Web.config s...
- Modified
- 23 Jul at 13:58
DBContext disposing doesn't change the number of opened connections
DBContext disposing doesn't change the number of opened connections In highload legacy application I've found tons of code which just creates new DBContext, then makes request and doesn't dispose the ...
- Modified
- 21 Sep at 03:27
How to force a SqlConnection to physically close, while using connection pooling?
How to force a SqlConnection to physically close, while using connection pooling? I understand that if I instantiate a SqlConnection object, I am really grabbing a connection from a connection pool. W...
- Modified
- 19 Jul at 04:25
Pass connection string to code-first DbContext
Pass connection string to code-first DbContext How do I pass a connection string to entity framework's code-first DbContext? My database generation works correctly when both DbContext and the connecti...
- Modified
- 10 May at 02:33
How to connect to an Oracle database Connection from .Net Core
How to connect to an Oracle database Connection from .Net Core Within a .netCore library I want to connect to an Oracle database. Is there any way I can do that yet? I have tried the suggestions on [a...
- Modified
- 23 May at 11:54
Connection.open for hangs indefinitely, no exception is thrown
Connection.open for hangs indefinitely, no exception is thrown When I try to do the following code, the program hangs indefinitely. I don't know why and there seems to be other unanswered topics on th...
- Modified
- 26 Sep at 23:23
Listing table results in "CREATE TABLE permission denied in database" ASP.NET - MVC4
Listing table results in "CREATE TABLE permission denied in database" ASP.NET - MVC4 I'm using ASP.NET MVC 4 - c# to connect to a live database, and list the results, however when I go to view the pag...
- Modified
- 6 Feb at 11:8
How to fix "The ConnectionString property has not been initialized"
How to fix "The ConnectionString property has not been initialized" When I start my application I get: Web.config: The stack being: ``` System.Data.SqlClient.SqlConnection.PermissionDemand() +487664
- Modified
- 3 Mar at 21:31
Losing ODBC connection with SQL Server 2005 Database
Losing ODBC connection with SQL Server 2005 Database One of our clients has an application (FoxPro 9) running on top of a SQL Server 2005 backend. Intermittently, they are losing their ODBC connection...
- Modified
- 8 Sep at 11:34
Error occurred during the pre-login handshake
Error occurred during the pre-login handshake In a project that I am debugging I receive a SqlException saying the following: > Additional information: A connection was successfully established with t...
- Modified
- 24 Apr at 22:51
How to connect and use Firebird db embedded server with Visual C# 2010
How to connect and use Firebird db embedded server with Visual C# 2010 I was trying to use Firebird embedded server with Microsoft Visual C# 2010. so here is what I done till now: 1. Downloaded Firebi...
- Modified
- 17 Sep at 12:44
Using MySQLConnection in C# does not close properly
Using MySQLConnection in C# does not close properly I try to write a class to make MySql Connections easier. My problem is, after I open a connection and close it. It is still open in the Database and...
- Modified
- 23 Jul at 01:14