Tagged Questions

10
votes
5answers
12k views

SQL Express Connection string - Relative to application location

I am using a SQL express databases as part of a unit test project in c#. My databases is located in ./Databases/MyUnitTestDB.mdf I would like to use a relative path or variable in the app.config ...
13
votes
7answers
7k views

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. When I call Open(), it will open the connection. If I call the Close() or ...
29
votes
5answers
19k views

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

I am getting following error when i am trying to connect Production DB from Local Environment. I was able to connect Production DB before, but suddenly i am getting following error, any idea? A ...
3
votes
3answers
4k views

Connecting to Sql Server with Python 3 in Windows

Can someone please point me in the right direction of how I can connect to MS SQL Server with Python? What I want to do is read a text file, extract some values and then insert the values from the ...
2
votes
2answers
11k views

mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication.

I am getting the following error: Database connection fialed: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password ...
0
votes
3answers
2k views

SqlConnectionStringBuilder form in .net C#

I am wondering how I can add DATA LINK form to my WIN application. You know those forms where Users can choose on witch SQL server they going to connect and what type of security they going to use and ...
3
votes
2answers
2k views

Visual Studio 2008 (C#) with SQL Compact Edition database error: 26

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is ...
2
votes
3answers
80 views

Why does a connection have to be open for a nonquery but not to fill a dataset?

When I connect to a SQL datasource in my C# application, I can fill a dataset using the following code. Note that I am not explictly opening a connection to the datasource. SqlConnection cw_con = ...
2
votes
1answer
3k views

Cannot create JDBC driver of class '' for connect URL 'null' : Tomcat & SQL Server JDBC driver

I've tried just about everything I can find out there, if someone is able to help me out, I will be eternally grateful (and a lot more free in my time). Basically, I have an error in Tomcat 7.0 (both ...
1
vote
3answers
10k views

Getting current connection properties in SQL Server

In MS SQL Server, the Database Properties dialog has the "View Connection Properties" link over on the left. Clicking that brings the "Connection Properties" dialog with properties of the current ...
0
votes
1answer
1k views

Close connection to DB does not close all connections

I have connection leak to DB in my code. The funny thing is that when I debug, all the connections are closed successfully (or when I do Thread.Sleep(100) ). but without that there is always one ...
0
votes
4answers
1k views

SQL, PHP - Close a sleeping connection

Good day to all. I have a little problem: How do I close the sleeping connections to a database? When I issue a query the query is executed then the connection remains on sleep mode for 2-3 ...