At the moment i'm busy to implement a website, database and software which will fill this database. The website is placed at an external hosting company, the software is running at out local netwerk. The website needs to read the information in the database, the local software will put its results (these data) in the database. Question:...
I have code that in the connection setup selects the database using mysql_select_db(). $link = mysql_connect('localhost', 'user', 'pass'); mysql_select_db("database1"); Can I later run a query against two databases such as: SELECT database1.row, database2.row FROM database1.table, database2.table WHERE database1.row = database2.oth...
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 correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Ser...
Hi, I have a Database that has the following relations: Transaction->Purchase->Item->Schedule Transaction - self explanitory Purchase - any purchase info that relates to the item being purchased (quantity, if the user purchases more than one item). A given Transaction can have more than one Purchase_ID tied to it. Item - Stores Item ...
When using Team Foundation Server & Visual Studio - you can export data from the TFS database to excel, modify the values, and click "publish" to send the new values back to the database. So, excel becomes a way to view and modify your database table. The feature works surprisingly well and I'd like to use for other databases we have. ...
I have a .IB file which I'd like to access using a Java Application. Where can I find the drivers for Interbase. My OS is Mac OS X ...
I'm designing an application that relies heavily on a database. I need my application to be resilient to short losses of connectivity to the database (network going down for a few seconds for example). What is the usual patterns that people use for these kind of problems. Is there something that I can do on the database access layer to h...
Hi all, i'm running an Apache Tomcat 6.0.20 / MySQL 5.1.37-lubuntu / sun-java6-jdk /sun-java6-jre / sun-java6-bin on my local machine using Ubuntu 9.10 as OS. I'm trying to get a simple DB-query example running for 2 days now, but i still get this Exception: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.serv...
I want to map DbConnection to an un-opened SqlConnection using Ninject. This is what I've done: string constr = @"Server=.\SQLEXPRESS; Trusted_Connection=True; Database=TestDB"; Bind<DbConnection>().To<SqlConnection>() .Using<OnePerRequestBehavior>() .WithConstructorArgument("connectionString", constr); However, when trying t...
Well, The question explains all, Using DB2mon tool, Is there a way to tell which client is connecting using which type of connection (type 2 jdbc or type 4 jdbc connection)? All of the connections are showing as db2jcc process which is the common driver for both type 2 and type 4. Also if there is a way to find out whether is connection...
I am creating a window application in C# and was thinking of setting up a password on mdb file of MS-Access so that no one can open that file other than my window application or who so ever knows password of that file. I managed to make that file password protected but unfortunately I was not able to access that file through my applica...
I m creating a window application using MS-Access as my database since data volume is not large. I want to create it in accdb format i.e office 2007 then will it work with my application on any machine where there is no MS Office as mdb works on any machine. ...
Is there a way to display the connection properties dialog for connection string browsing(for database) in run time? As I want the user to be able to connect to various database using the GUI. The same one as we get in visual studio connection properties dialog. Thanks in Advance ...
How can I create a class in oo php wherein that class will be the one that will manage the DB connection? Sample codes or sites will do. Im using MySQL Command Client by the way. Main problem: How can I connect to the DB so that I can insert new records, retrieve records, update records? Thank you! ...
I am getting a little confused, I was reading the below from http://en.wikipedia.org/wiki/Java_Database_Connectivity Connection conn = DriverManager.getConnection( "jdbc:somejdbcvendor:other data needed by some jdbc vendor", "myLogin", "myPassword" ); Statement stmt = conn.createStatement(); try { stmt.executeUpdate...
hi i have build my project in C#, i add DataSet.xsd, and connect him to Oracle DataBase in my computer - work Excellent !!!! when i installed on the customer computer (that connect to his Oracle DataBase) - it crushed. i need to change the connection string on the DataSet.xsd file - but how to do it ? is there any xml file ? or co...
I'm in the process of testing an application and it's database and for this I want to restart my testing each time completely clean. This application loads a large amount of data from Twitter. Therefore, before I start, I delete all data from the database and kill any processes from my web account associated with this application. When I...
I've some huge text files to process and make sense out of the data. Part of the task is to save this data into a database. I want to use Ruby, with postgres or mysql, postgres being the first choice. What libraries should I include? There is no model, its going to be plain SQL statements. How to do this without rails? ...
I am not used to work with SQL Server(usually I just use express). I run it on windows server 2008, iis7. I have attached the database to my sql server. I made a web site in iis7 but I get this error message. Cannot open database "Phaeton.mdf" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK S...
We are having some connectivity issues from a client application connecting to a remote SQL Server 2005 (named instance). What are some ways to test connectivity from the client machine (Windows XP) that doesn't have SSMS or Query analyzer installed? I would like to see if the issue is related to the specific application or is it a mor...