I am havng the following problem after installing oracle 10g on vista machine and running an asp.net application. Rather strange: One 2010 project on the same machine using the same database is able to work but the other that was converted to 2010 recently isnt working on the same machine. The error is : OCIEnvCreate failed with return...
What I want to do: My application has a full connection to a Derby DB, and I want to poke around in the DB (read-only) in parallel (using a different tool). I'm not sure how Derby actually works internally, but I understand that I can have only 1 active connection to a Derby DB. However, since the DB is only consisting of files on my HD...
I'm developing a real-time analytics solution and I need to choose the best database to do it. I believe MongoDB is ideal but I don't have the experience to compare all the other solutions. What's your advice? Thanks ...
Hey guys, I'm migrating from Java to C# now that I've realized I prefer the C# language features over the ones in Java, but I have this small issue. In MySQL Connector/J and JDBC, I believe that one of my applications allowed multiple PreparedStatements to be executed while another one is open, like I could perform a query that returns a...
firstly i am a total newbie for both jsp as well as oracle. i just want to know the steps for connecting an oracle 10g database with a jsp page. ...
Hi there, I'm pretty new to Servlets and JSP and to using databases. At the moment I have a class in the 'model' part of my web app which has lots of methods that I've written to perform database queries and updates. At the moment, in each of those methods I am creating a database connection, doing the SQL stuff, then closing the conne...
I'm currently setting up my website on a new SQL Server 2008 server, however I'm getting the following error: Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately....
I have an excel invoice sheet and I want to write the information from the invoice to a table in an Access file. My following code is: Private Sub Button66_Click() Dim con As New ADODB.Connection Dim connectionString As String Dim sql As String connectionString = "DBQ=c:\Users\Public\Public Desktop\InvoiceRecords.mdb; Driver={Microsof...
I’m researching EF4 for a new in-house application development project using .NET v4, EF4, & SQL Server 2008 R2. To date, our small dev team has done very little .NET development and only demonstration EF applications. Our current applications use DB app-roles for security and that's worked out well for us. From reading and some basic ...
When promoting or deploying a build, I'd like to automate swapping out a single database connection file. This could be done as either a post-build step or as a pre-packaging step before deployment. The file that's being swapped out is a test file; the file being swapped in should have the real database connection configuration. How ca...
I have dependent and independent classes, I need to create database connections in these classes. As I understand from Qt documentation, if I create connections in default way, all of them use same connection. Should I create different database connections for different classes, or should I use same database connection. What are pros an...
I have a column in a table that contains a message and I want this message to be displayed in a label. Here is my code which currently doesn't populate the label. Protected conString As String = ConfigurationManager.AppSettings("sqldirectory") Dim cnn As New SqlConnection(conString) Dim cmd As New SqlCommand("select message from [da...
I have about 4 days to load 4 million rows of data, where the stored procedures appear to take about 500ms/row, so I am suggesting we temporarily repurpose two computers, one as the SQL Server and one to feed it. Each machine is a 4 cpu, 2 core/cpu computer with tons of memory. There are two competing ideas on how to load the data. o...
Hi, I facing problem of database connection in my project in which i used struts. I cant understand that how i manage my database connections. I want my site good in based on accessing becoz it will get million after launch. And also face heap size problem in that . I cant understand that how i will manage my architechture. Plz guide...
If I have a Microsoft Access 2007 database on a network location, is there a limit to the number of client computers that can use the database? The client will not have Access installed and instead will be using the Access Runtime 2007. Will the maximum number of connections be changed if I split the front end from the back end as oppos...
I am working on system where there are huge (2000-5000 records per minute) amount of incoming events which have to be recorded in the database (SQL server 2000). We are using ODBC connection to connect with the database. Currently we open a single connection during the app startup and push the data using the connection since we won't be...
Hi all, In web applications like phpBB, when every time a new page is requested, is a new database connection created? For example when 5 users login using login.php simultaneously, is a new database connection created for each of the five users? ...
I'm developing a website in that, i couldn't create connection string ,i have included all the required namespaces but when i create a string variable to store the connection it wont come in declaring SqlConnection object, but i can able to create connection string in constructor class,why i can't able to create connection outside const...
Hello, I am new with WCF, I am trying to deploy my WCF sample application on IIS, this application works fine in debug mode with VS2008, this application authenticate the WCF messages with following code. I am doing it like this, I have added the resulted .dlls web.config and the Service.svc in the wwwroot directory, and I have also ad...
Hi, I have two servers (virtual machines - I can remotely connect to these) - server 1, and server 2. On server 1 I keep my webpages, and on server 2, I keep the databases. I am currently trying to connect to a database on server 2 from server 1. Here is my php code: <?php $dbhost = 'xxx.xx.xx.xx:xxxx'; $db...