» Home » connection » Page 1
Error adding connection in Server Explorer: “Unable to add data connection. ExecuteScalar requires an open and available connection.”
by mitry in Programming Languages

I'm using Visual Studio 2008, and my database is SQL Server 2000.


I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.


But when I click OK, I get the error:


Unable to add data connection. ExecuteScalar requires an open a


Dynamically change connection property on connection obtained from Java JNI connection pool
by GarlicBreath in Java

I'm using Java and retrieving my database connections from a JNI connection pool (Weblogic Server).


I want to set the connection property, oracle.jdbc.V8Compatible="true", for the connections I retrieve because if this is not set then an Oracle bug is present that causes the wrong behavior when working with Dates and Timestamps.


There is a lot of already existing code wh


Norm.MongoException: Connection timeout trying to get connection from connection pool
by Pierre LeBoo in Programming Languages

I'm using Rob's mvc startesite http://mvcstarter.codeplex.com/ with ASP.Net MVC 2, Ninject2, NoRM (http://github.com/atheken/NoRM) and MongoDB. It works so fast and the developpement is even faster but I'm facing a big problem, I at some points, get connection timeout. I can't figure out what I'm doing wrong.


I already asked a question here : http://stackoverflow.com/questions/3159


Connection Rollback while getting/returning connection from connection pool
by Raphaël Slinckx in Development Tools & Services

my application is using org.apache.commons.dbcp.BasicDataSource for managing connection pool.


Our DBA's generated AWR report which shows many user rollback (in millions) we have put log statement while rollback and application rollback count is not matching with AWR report.


I read from below link that Connection pool automatically perform a rollback when transaction is c


I have a page that uses a mysql connection. How can i make 1 mysql request using a new connection without messing up the current connection?
by alphamars in Programming Languages

I currently have a page that is something like this


<?php
mysql_connect(...);
mysql_query('the pages queries');
### here ###
mysql_query('the pages queries');
?>

but where it says ### here ###, i basically want to do this:


mysql_connect(new server/new user)
mysql_query(update db2.log ...)


jetty websockets connection closing connection and sending messages are thread safe?
by Roman in Programming Languages

I've started adding to my application a small websocket server based on jetty.


However I'm interested since I didn't find anywhere in the documentation if the sendMessage and disconnect methods are called asynchronous or synchronous?


In case the methods are asynchronous what is the callback method??


here is the link with the documentation: http://download.ecl


Multithreading Entity Framework: The connection was not closed. The connection's current state is connecting
by Disco_TechnoStu in Coding

So I have a windows service process that performs a workflow process. The back end uses Repository and UnitofWork Pattern and Unity on top of Entity Framework with the entities class generated from the edmx. I won't go into a whole lot of detail as its not necessary but basically there are 5 steps that the workflow goes through. A particular process might be at any stage at any point in time (i


MySQL Connection not closing using connection pooling and container managed transaction in GlassFish
by Vytautas in Databases

I am using EclipseLink 2.3.2, GlassFish 3.1, and MySQL 5.1. I have a simple EJB with the following snippet of code:


@PersistenceContext(unitName = "UpdatesPersistence")
private EntityManager em;
@TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)
public void addPhotos(Collection<Photo> photos) {
// Use the em to fetch some data with em.crea

Establishing the connection from Script Task(VB) to OLEDB Connection Manager of SSIS Package
by Baskaran in Programming Languages

How to use the existing OLEDB connection Manager from scripttask Task(VB). i need to execute a SQL statement from "Script Task" Task.


Edit

Attempted the following code but couldn't get the connection with my OLEDB Connectionmanager


Dim MyCM As ConnectionManager = Dts.Connections("MyConnection1")
Dim CS As String = Dts.Connections(MyCM).ConnectionString

ASP.Net MVC Execution of the command requires an open and available connection. The connection's current state is broken
by KCro in Programming Languages

Several of our internal apps are MVC3 and all use Ninject.MVC.


We're running into an issue that affects all the tools at one point. First we get the error:


Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'.

Followed by:


Execution of the command requires an open and availa

Next
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .