Search Results

Search found 32492 results on 1300 pages for 'reporting database'.

Page 543/1300 | < Previous Page | 539 540 541 542 543 544 545 546 547 548 549 550  | Next Page >

• Oracle Enterprise Server SOAP/Servlet/SoapRouter

  - by JACK

  Does anyone know any sample Oracle SOAP XML requests that that queries the database? For example, the url: http://myoracle:7778/oracle/soap/soaprouter/ I'd like to program xml requests and get return xml database. But I have no idea on the Oracle SOAP format. Please provide an example.

  Read the article

• file handling in vb.net

  - by Indranil Mutsuddy

  Hello there I have developed an application in vb.net2008 and database sqlserver. Now i want to ignore the database(it has 1 table as customer(name,password,hour,minute)) as i dont want my client to install sqlserver separately or other overheads. I am planning to do the whole using file handling in vb.net(manipulating the data in files itself eg change username, password etc). As I am new i dont actually know the proper way and of course need assistance. Kindly help out. Regards Indranil

  Read the article

• DB Designer creates compound primary key

  - by Jon Winstanley

  When adding relationships to a database model in DB Designer 4, a composite primary key is being created every time. So every foreign key I add, I get an extra key added to a composite primary key. I think I must have changed a setting as I don't remember it doing this in the past. Does anyone know how to turn off this feature as I prefer to use a single surrogate primary keys in my database tables?

  Read the article

• Load the information in Grid View from SQL

  - by Sivakumar

  Hi friends, I need to load the database values into the grid view by checking the attrinute "id". If the id value which I entered s equal to database, then it'll load in d grid view. Help me to do tat

  Read the article

• Default Value or Binding in "Transfer SQL Server Object Task"

  - by Kronass

  Hi, I want to move 500 table from Database to other with their data and constraints all the tables have column who has default value, I used SSIS using "Transfer SQL Server Object Task" and I choose to copy all tables, copy data and primary keys, it copies the table except the default bindings I tried in SQL Server 2008 CopyAllDRIObjects Property but still the same result. How can I copy all tables from database to other with their data and maintaining their constraints.

  Read the article

• SQL Server 2005 Users & Roles

  - by koumides

  All, I am trying to script out a database in SQL Server Management Studio 2005. In my database users belong to different roles. Unfortunately I can't find how to script out the relationship between users and roles. Thanks, M

  Read the article

• Zero Downtime with Hibernate

  - by Stephan Schmidt

  What changes to a database (MySQL in this case) does Hibernate survive (data, schema, ...)? I ask this because of zero downtime with Hibernate. Change database, split app servers into two clusters, redeploy the application on one of the clusters and switch application. Thanks Stephan

  Read the article

• MS SQL Error: Primary file group is full

  - by aximili

  I have a very large table in my database and I am starting to get this error Could not allocate a new page for database 'mydatabase' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. How do you fix this error? I don't understand the suggestions there.

  Read the article

• Loading SQL dump before running Django tests

  - by knutin

  I have a fairly complex Django project which makes it hard/impossible to use fixtures for loading data. What I would like to do is to load a database dump from the production database server after all tables has bene created by the testrunner and before the actual tests start running. I've tried various "magic" in MyTestCase.setUp(), but with no luck. Any suggestions would be most welcome. Thanks.

  Read the article

• What is the best scripting language to embed in a C# desktop application.

  - by Ewan Makepeace

  We are writing a complex rich desktop application and need to offer flexibility in reporting formats so we thought we would just expose our object model to a scripting langauge. Time was when that meant VBA (which is still an option), but the managed code derivative VSTA (I think) seems to have withered on the vine. What is now the best choice for an embedded scripting language on Windows .NET?

  Read the article

• Unique Constraint Nhibernate.

  - by Will

  I have a object with a Nhibernate mapping that has a surrogate ID and a natual ID. Since of cource the natural ID is uniquely constrained a insert query will fail if the object is already in the database with the same natural ID. My solution for this has been to manually check to see if natural IDs are in the database before trying to insert. Is there a way to specify Nhibernate to do a select before insert on natural Id's/Unique Constraints?

  Read the article

• Set of Tools to optimize the performance in general of SQL Server

  - by Dave

  Hi, I know there are things out there to help to optimize queries, ect... but is there anything else, something like a full package that can scan your database and highlight all the performance issues, naming conventions, tables not properly normalized, etc? I know this is the job of a DBA and if the DBA is good, he shouldn't need a tool like that, but sometimes you start a new job, you get in charge of an existing database and the DB is a mess, so you don't know where to start... Thanks to everyone Dave

  Read the article

• Is it possible to restore Sql Server 2008 backup in sql server 2005

  - by AvidProgrammer

  Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005? I need to work on an sample application for which database backup is in sql server 2008. But I'll not be able to install 2008. So is it possible to restore that back up in 2005?

  Read the article

• Why do multiline cells in my CSV file appear with a question mark at the end of each line in Excel?

  - by Chris Lindsay

  I'm currently working on a project where we'd like to allow a user to export their data to CSV. Some of the data we present has multiple values for a single cell, and so we use the standard CSV method of putting each value on its own line: Column A, Column B, Column C Value A, "Value B1 Value B2", Value C Most of the time this works fine, but some people are reporting seeing a small question mark in a box character appear at the end of each line when they load the file in Excel. Why is this happening?

  Read the article

• SQL programming

  - by Prince

  How can I update a table (MyTable) from a aprticular database (DB1) by equating the said MyTable from a different database (DB2) but it has the same tablename with the one I need to update. I tried putting alias to my program but it doesn't work. Need Help

  Read the article

• Paypal IPN for Amazon?

  - by Webnet

  Is there any kind of Paypal IPN system for amazon? I'm looking through all of the stuff and am only seeing automated reporting and stuff that is after-the-fact.

  Read the article

• Recommendations for project management software for Scrum

  - by Mendokusai

  We're using Scrum on our current project and we're very happy using our agile board and cards but reporting, burndown charts etc. are somewhat cumbersome to maintain. So, we're looking for good agile software to use instead. I'm keeping requirements deliberately vague but does anyone have any recommendations? The software would need to run on Windows.

  Read the article

• Connect to Mongodb in python

  - by SpawnCxy

  I'm a little confused by the document when I tried to connect to the Mongodb.And I find it's different from mysql.I want to create a new database named "mydb" and insert some posts into it.The follows is what I'm trying. from pymongo.connection import Connection import datetime host = 'localhost' port = 27017 user = 'ucenter' passwd = '123' connection = Connection(host,port) db = connection['mydb'] post = {'author':'mike', 'text':'my first blog post!', 'tags':['mongodb','python','pymongo'], 'date':datetime.datetime.utcnow()} posts = db.posts posts.insert(post) #print str(db.collection_names()) And I got an error as pymongo.errors.OperationFailure: database error: unauthorized.How can I do the authorizing part?Thanks.

  Read the article

• DB comparison tools

  - by Dimi Toulakis

  Has someone experience with database comparison tools? Which one you would recommend? We are currently using "SQLCompare" from Redgate, but I am curious to know if there are better tools on the market. The main requirement is that they should be able to compare scripts folder against a live database. Thanks, Dimi

  Read the article

• Unit of Work Pattern in .Net

  - by Jazza

  Does anyone have any concrete examples of a simple Unit of Work pattern in C# or Visual Basic that would handle the following scenario? I'm writing a WinForms application in which a customer can have multiple addresses associated with it. The user can add, edit and delete addresses belonging to the customer before the customer is saved back to the database. Therefore, at the time of saving, all the original addresses need to be deleted from the database and the new addresses added in a single transaction.

  Read the article

• Registration Form check PostgreSQL is username is already taken

  - by MrEnder

  Hey I'm really new to PHP and PostgreSQP or any database in that matter. So I'm at a loss how to do this. I need an if statement that says. If(the username user just typed in is already in database) { my code here } the variable the username that the user just typed in is $userNameSignup how would I do that with PHP for PostgreSQL? also how might I redirect people to a new page once they have completed the form properly? Thanks Shelby

  Read the article

• JPA - How to truncate tables between unit tests

  - by Theo

  I want to cleanup the database after every test case without rolling back the transaction. I have tried DBUnit's DatabaseOperation.DELETE_ALL, but it does not work if a deletion violates a foreign key constraint. I know that I can disable foreign key checks, but that would also disable the checks for the tests (which I want to prevent). I'm using JUnit 4, JPA 2.0 (Eclipselink), and Derby's in-memory database. Any ideas? Thanks, Theo

  Read the article

• How do I handle Memcached::ServerIsMarkedDead error with Rails?

  - by Kevin

  Hi, In my Rails app, I changed my model's find method to search into the cache before looking into the database, but I sometime get this error: Memcached::ServerIsMarkedDead While waiting for Memcached server to be up again, how should I handle this error and force Rails to search into the database? Thank you, Kevin

  Read the article

• Visual Studio 2005 doesn't support Sql Server 2008

  - by Erez

  I'm developing Reporting services on VS2005 and have to connect to SQL Server 2008. The following Error occurs: "This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later." I found on the net a patch for it, but it doesn't work (link to patch) "The upgrade patch cannot be installed by the Windows Installer Service because the program to be upgraded is missing, or the upgrade patch may update a different version of the program." what else can I do ? :(

  Read the article

• how does a sql query work?

  - by Anand

  Hi, How does a sql query work ? how does it get compiled ? Is the from clause complied first to see if the table exists ? How does it actually retrieve data from the database ? How and in what format are the tables stored in a database ? I am using phpmyadmin is there anyway I can peek into the files where data is stored ??

  Read the article

< Previous Page | 539 540 541 542 543 544 545 546 547 548 549 550  | Next Page >