Hi I am running on php. And in my local I am working on windows environment so it was easy to connect to MS Access Database using ODBC connector. But on my live server environment there is Linux so there is a problem regarding the DB connection. So what are the steps to connect to MS Access DB in Linux environment using php. Thanks...
I need to simply edit a very complicate view in phpMyAdmin 3.2.4 but I cannot figure how to do that. Any suggestions? Thanks! ...
Hi.. What are the detailed steps to deploy SymmetricDS to Tomcat and get it working? Thanks ...
I think that the ability of some reflective managed environments (e.g. .NET) to add custom metadata to code entities in the form of attributes is very powerful. Is there any mechanism for doing something similar for databases? Databases obviously already have a fair amount of metadata available; for example, you can get a list of all ta...
I had completed my project Address Book in Java core, in which my data is stored in database (MySql). I am facing a problem that when i run my program on other computer than tere is the requirement of creating the hole data base again. So please tell me any alternative for storing my data without using any database software like mysql,...
Hi whats the difference between the database connection made from a stand alone code and that made from a web application deployed in sun java web server. The code used to connect to the database, when run as separately the db connection is successful. But the same code inside my web application when deployed is not able to make the ...
Many examples out there advocate explicit rollback of database transactions, along the lines of: using (var transaction = ...) { try { // do some reading and/or writing here transaction.Commit(); } catch (SqlException ex) { // explicit rollback transaction.Rollback(); } } Howeve...
I am trying to add a foreign key constraint to a table in my PostgreSQL 8.4 database, but it is failing as the target field, though part of a multi-column primary key, is not in itself unique. The database has the following structure: Table 1 (names of primary IDs): PrimaryType, Name [Primary key = "PrimaryType"] Table 2 (names of c...
I want to enter the data in FoxPro but save the data in .xls format. ...
Hello folks, I'm working on a project where a PHP dialog system is communicating with a Microsoft SQL Server 2008 and I need more speed on the PHP side. After profiling my PHP scripts, I discovered that a call to mssql_connect() needs about 200 milliseconds on that particular system. For some simple dialogs this is about 60% of the who...
Hello, I would like to have several custom fields from a (server) database merged into Word Processing documents, beyond the normal "mail merge" fields. I'm not finding anything like an API out of the box that allows you to do this for custom fields. This seems like it would be pretty common in business software, but I assume that's one...
We have a rather large DB schema that is ocnstantly changing - every application release comprises the app itself, plus a migration script to apply to the live DB as required. Nopw, in parallel we maintain a schema creation script which we can use at any point to build a DB from scratch (for testing purposes). The thing that vexes me s...
Can anyone explain me what is non-serializable in transaction DB. please give me an example. r1(x) r2(x)w1(y) c2 c1 is this non-serializable? ...
I am trying to get some old VB6 code to work with SQL Server Compact. I can connect, open the database and all seems well. I can run insert select commands which work. However the ADODB.Recordset RecordCount property always returns -1 even though I can access the Fields and see the data. Changing the CursorLocation = adUseClient ...
2 tables: owners & cars An owner can have many cars. A car can be marked as usable_offroad, usable_onroad, or both. The cars table has usable offroad and usable_onroad fields which can be set to 0 or 1 (no or yes) Consider the following query: SELECT * FROM owners LEFT JOIN cars on cars.owner_id = owners.id GROUP BY owners.id ORDER ...
Hi does anybody know of a tool that will allow for viewing of database schemas and the data within it? Im using a Mac and need to view a mySQL database. Basically something like phpmyadmin that runs as more of a stand-alone app and can connect to any mySQL db. I have found Aqua Data Studio but it is too expensive. Thanks for any...
I'm aware there are databases for zip codes, but how would I grab the city/state fields based on that? Do these databases contain the city/states or do I have to do some sort of lookup to a webservice? ...
I have different 3 types of users and each type of user can have columns and relationships with tables that another type doesn't, but all of them have login(Unique) and password, how would you do: create a table for each type or create one table for all of them or create a table for all of them only for login and password and separ...
I was having a discussion with a developer at work on the issue of should a table use default values. Is there a hard and fast rule on this or is it a gray area in best practices? ...
I have some tables in my postgres database, and a few of them inherit from each other. For example: CREATE TABLE parent_table(parent_table_id SERIAL PRIMARY KEY, my_col1 VARCHAR(16) NOT NULL, my_timestamp TIMESTAMP WITH TIME ZONE NOT NULL); CREATE TABLE child_table() INHERITS (parent_table); CREATE TABLE step_child_tab...