I created an app which is need to run in linux started by crontab. An error happened when it tried to connect oracle database: it returned SQLO_INVALID_DB_HANDLE. But if started it manually everything is okay. I bet there are no path-related mistakes here, because everything goes well except the connection to the Oracle database. O...
I was in search of a SQL Script , in order to determine , if there is any data(row count ideally) in any of the tables in a given database. The idea was to re incarnate the database , in case if there are any rows existing(in any of the database) . The database being spoken of is SQLSERVER. Could Someone suggest a sample script.? th...
Hi i have stored the images in mysql using the varchar datatype and i am storing the path of that and i want to retrive that images in the gridview of asp.net ...
I am using mysql as a db. Is there any formula for determining the cache size needed to cache the results? Thanks ...
I have a Windows application written in C# that works with an Access database file. Furthermore, I use some DataSets in my project that work with this Access database. Arising from this, I have two questions: How can I convert the Access database file into an SQL Server database, and How can I convert the project code (using Access Da...
I have developed a fully functional ruby-on-rails application which utilizes numerous mysql tables. I would like to turn this into a subscription based service but I have some general, probably basic, conceptual questions: In a setup such as Basecamp does each user have access to her/his own (as in unique) db tables or are the tables s...
I want to add the new tables to dbml file dynamically from another database Thank you ...
I have a page where a user can insert some order about some product. In that page there are also live statistics which is being refreshed every 20 seconds to reflect the current price of a product using asp.net timer. This live panel fetching these prices from a database. When sometimes an order is being inserted, I get an exception say...
I've recently started reading up on Rails and while getting my development environment ready on Windows, I kept running into problems. So I opted to just work on the server space I have with asmallorange.com. Everything went smoothly until I tried created my database. When running rake db:create I get a response saying that it coul...
I'm currently tearing my hair out trying to persist authentication via a database bases session. I've set Zend_Session to use a database, and on inspection, Zend is writing values to the database. However, the ID for those sessions doesn't appear to match the PHPSESSID - yet when I get Zend_Session to return the id - it returns a matchi...
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'm new to rails and need some help with DB design. It is basically category, product, quantity, price...type of tables. I have 4 categories: CatA CatB CatC CatD Each category above will have multiple products in them: CatA - ProductA1, ProductA2, ProductA3 CatB - ProductB1, ProductB2, ProductB3 CatC - ProductC1, ProductC2, ProductC...
We have a set of views (quite a few) that we're trying to implement in the Entity Framework with their relationships. These views have primary keys defined but for some reason when I create an Entity model for them I received the message: The table/view 'vwFoo' does not have a primary key defined. The key has been inferred and th...
I have been looking for a database solution to allow user defined fields and values (allowing an unlimited number). At first glance, EAV seemed like the right fit, but after some reading I am not sure anymore. What are the pros and cons of EAV? Is there an alternative database method to allow user defined attributes/fields and values?...
I'm not sure if my question was at all clear or not, so let me just dive in and give you the long version: Someone said recently, when discussing high-volume web applications, that "disk is the new tape". Website administrators use huge clusters of memcache servers to make disk I/O-free round trips between the client and the server. In ...
I am new to designing apps and have a basic understand of Ob-C and how everything works. What I would like to do is have two tabs, one is a home screen that displays numbers and percentages that are entered on the second tab. The user will be able to store that information and refer back to it and update it. What is the best way to co...
I am designing a database in PostgreSQL on a dedicated server. I want certain complex queries to be run often, and the results to be accessible with ODBC/JDBC clients such as MS-Access or reporting software. As I see it, I have the option to either define a VIEW within PostgreSQL and import it using ODBC, or to define the query within t...
I am looking for how to build a relational mysql database, and I would like to follow a tutorial. I need one that shows how to make multiple tables, and link those together using an id. Which I can later use to grab relational data from the different tables. This is probably easy stuff, but I am just learning about databases. Thank...
I'm considering undertaking a project to migrate a very large MS Access application to a new system based on SQL Server. The existing system is essentially an ERP application with a couple of dozen users, all sharing the Access database over the network. The database has around 300 tables and lots of messy VBA code. This system is beginn...
Is there a way to insert into MySQL database using PHP PDO and return its id? Or I will just have to search fot its id after insertion? ...