Databases Forum

Hi, I need an exampls program in java to store image datatype in ms-sql database.i am writing a jsp file in that i wanted attach a file.in oracle i wriiten like this,but i need in ms-sql.i required urgently.pls help me. code in java using oracle. i need it in ms-sql. …

Hi, i'm making a database on mysql for a uni assignment. In the write up of the report i've been told to put in a logical model which can be done by identifying the relationships from a conceptual model. I know what a conceptual model is and have identified the …

Hi Friends , Theres a database name 'Trial' . Thro' Enterprise manager , I hv generated SQL Script for 'Trial' db. And I need to copy that 'Trial' db files ( all datas & tables etc ) into another Database 'Trial -1 ' db. which is in another remote Server …

Hello I am making a shopping cart where database I like to use is oracle but there are other projects which are already made with sqlserver2000 database & maybe I have to link from shopping cart to sqlserver2000 database where lots of contents are stored so what happens if I …

When upgrading these boards from phpBB to vBulletin, I encountered a few errors in the posts. One of these is that the old style stores quotes as " and it is printed out verbatim in the posts. Is there a find and replace SQL statement to traverse through a record …

Help. I'm trying to write a database for vehicle reservations and I can't figure something out. All vehicle reservations are going to have reservation dates (obviously). I have a table set up to list vehicles by USN # (like a VIN #), vehicle body type (pick-up, suburban, etc.), and a …

[size=2]By: Jeff Johnston MySQL is set to announce some exciting new features at its User Conference in Orlando April 14-16 ([url]http://www.mysql.com/[/url]). The wildly popular free database server is expanding its functionality in attempts to keep up with the competition, PostgreSQL, and Firebird. The two new features are MySQL Cluster and …

Hi, i will appreciate alot if any one can help me and give me a detailed answered and references. cause i realy need a help, and thank you . Actualy im doing my final project which is a small e-commerce website using ASP technology and SQL for database. The site …

Does anyone know anything about the Rebus HR database system, particularly what system (if any) it is based on? It sounds like a pretty obscure system in itself so I can't imagine they've developed it completely from scratch. Thanks!

Hi! Can anyone please provide me with a little bit of information regarding this subject? I think I've heard from a lecturer that there is a command to auto-update the entries of a table. For example, when a new record is inserted, the salary column would be auto-inserted with (rough_salary …

Hi, I'm having a problem of starting mySQL.. well I'm actually forgot what did I do a long time ago that mess the mySQL up in my server. Well now when I'm trying to execute this command from the terminal such as: /etc/init.d/mysql start .. instead of starting the terminal …

Well, if you haven't noticed already, some to most of the internet is down! This is due to an exploit in Microsoft SQL Server SP2 and lower. A buffer overrun can allow hackers to run code on the SQL Server. This worm, infects an SQL Server and then that SQL …

[url]http://staging.infoworld.com/articles/hn/xml/02/10/21/021021hnnovellmysql.xml?Template=/storypages/printfriendly.html[/url]

I just read about this. New free enterprise db server that has many features that other free dbs don't offer. It's compatible with a lot of OS's. Definitely something to try out. [url]http://www.sapdb.org/[/url]

The Next Wave: "Visual Studio for Yukon" [url]http://msdn.microsoft.com/vstudio/productinfo/roadmap.asp#section4[/url]

Okay, so this forum uses PHP with MySQL... I have access to PHPMyAdmin on a remote server. I have been making periodic back-ups (dumps of the tables) but I'm always afraid that when I need them most, they'll fail on me. There isn't by any chance an easier way to …

[url]http://builder.com.com/article.jhtml?id=u00320020624gcn01.htm[/url] From article: [ When to use MySQL] Why would you use MySQL over PostgreSQL? First, we need to consider the needs of the applications in terms of database requirements. If I want to create a Web application and performance is an issue, MySQL will be my choice because it

This is a great tool to use when creating DBs in MySQL. Better than the one it comes with. If you're about to embark on an app using MySQL, I recommend it. [url]http://www.anse.de/mysqlfront/[/url]

Hmm... i've been looking for monitors at [url]www.dell.com[/url] (the accessories section) and i noticed in the shopping cart area, they have a feature called save. What i think this does is that it adds something to their database (probably MS SQL Server). My question is, would each new account need …

I'm currently working on my project. I use Vertrigo as my virtual server. However recently i always see this message when i use it.... MySQL database server does not work correctly. Check whether other applications use the important port (3306)... i'd no clue at all but then i reconfigure my …

I have a database that I use in VB. As records update there is a lot of useless info in there because access doesn't reuse the same spots. So that information has to be removed. Before I would use compact & repair and access 2000 and it would correct this. …

getting syntax error into insert i don't know why :( Private Sub Button1_Click(By Val sender As System.Object, By Val e As System.EventArgs) Handles Button1.Click If txtContact.Text.Trim.Length = 0 Then MessageBox.Show("Enter Contact Number.", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox1.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) …

Hi i need a validation rule for MS Access so that only a time can be entered that is between 18:00 and 23:00 The validation rules must allow for the above numbers inclsuively Please Help

The database that I'm working for has been suddenly corrupted. Fortunately, I performed a backup on it and save to a backup tape. Therefore, I reinstalled SQL Server and I tried to restore those backup. However, it failed and I suspect that maybe the backup is corrupted too as well. …

hi friends! From my Microsoft Access form I would like to hyperlink to a pdf document. At present each record contains a document name and a full file path to where the document is stored. I would like to open adobe Reader and view the specified document. please give me …

SQL> DESC TOPPING; Name Null? Type ----------------------------------------- -------- ---------------------------- TOPPINGID NOT NULL NUMBER TOPPING VARCHAR2(10) TOPPINGTYPE VARCHAR2(5) TOPPINGCOST NUMBER(4,2) SQL> DESC PIZZATOPPING; Name Null? Type ----------------------------------------- -------- ---------------------------- PIZZAID NOT NULL NUMBER TOPPINGID NOT NULL NUMBER SQL> DESC PIZZA; Name Null? Type ----------------------------------------- -------- ---------------------------- PIZZAID NOT NULL NUMBER PIZZANAME …

I have made a web service to insert product details the web method is as follows [code] using System; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data.SqlClient; using System.Data; using System.Configuration; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // …

When I execute the code below I am getting unknown column 'total' in 'field list' error. [CODE] DELIMITER$$ CREATE PROCEDURE setAuthentication(IN uname varchar(12), IN oldpws VARCHAR(12), IN newpws VARCHAR(12), OUT status INT) BEGIN call getAuthentication(uname,oldpws,@total,@pwsval); IF(total=1 AND pwsval IS NOT NULL) THEN UPDATE authentication SET password = newpws WHERE loginId=uname …

without 'joining'

<?php ob_start(); include("sys.php"); session_start();//when nid use session nid put tis ?> <html> <title></title><head></head> <script type="text/javascript"> function addRowToTable() { var tbl = document.getElementById('tblSample'); var lastRow = tbl.rows.length; // if there's no header row in the table, then iteration = lastRow + 1 var iteration = lastRow; var row = tbl.insertRow(lastRow); var …

I know this is probably a stupid post but I cannot think of how to accomplish this. How do you do the equivilent to an autonumber in a SQL Server table? Please let me know my project is very close to deadline Thanks in advance

Hey Guys, I was wondering if I could get some feedback on this E-R diagram I am doing for a project. Not looking for a straight up answer, just pushes in the right direction if something is amiss. This is the problem as given to me, and I've attached what …

I have a poor background in database design. i have only heard of distributed database once now i am meant to write a project on it(managing distributed database system) and also to create a sample application that manages a database for an organisation with distributed branches (making use of distributed …

Hello, I'm having an issue with a MySQL/PHP site I'm working on. I'm new to both. I've seen several posts that were similar or same but was unable to derive a solution based on my code. I have a form that will submit HTML code to a database. I know …

I have a INSERT, UPDATE trigger on a table, it works great and helps me from firing a stored procedure from all the (think it's over 50places) where it is needed. But I have one batch update to this table, that doesn’t require the trigger procedure; the trigger is very …

Hello, I am new to Crystal Reports with Oracle. I am trying to create a report ( in Crystal Reports) from an existing Oracle Database. The problem I am having is that I can get the tables but when I do a "browse Data" within the table, there are these …

I am going to work on the sales and purchase module of an ERP.I am facing problem while designing the database.I want to do sales and purchase with respect to bedspread. Kindly give me a general design with respect to tables and their attributes

A project that I've been working on (and getting help on [URL=http://www.daniweb.com/techtalkforums/thread10421.html]here[/URL]) is just about complete, but I've had to develop it locally on MySQL 4.1 for it's support of nested queries - I'm [B]rubbish[/B] with joined queries. However, the project is going to be running on my host, who …

pls help me creat database for computer hardware shop by letting me knw the attributes

HI Can you please let me know the ER/EER diagram and relationship mapping of the foloowing case study.It has extracted from internet but i cannot find the link. If someone can finnd please give me the link. Lloyds Incorporated: A case study Lloyds Incorporated is a manufacturing company with several …

I keep on seeing Oracle as I delve into the world of IT. And apparently, by the looks, they no own Sun MicroSystems - IS that correct/true. So what do they do, there history, everything please. Thankyou very much fro your help.

Hello friends, i m trying to input user : scott and pass : tiger also trying user : system pass : manager but even though its not going to start. i m getting following error [QUOTE]SQL*Plus: Release 3.3.4.0.0 ERROR: ORA-12154: TNS:could not resolve service name Enter user-name: Enter password: ERROR: …

1. Display student id, student first name, student last name, the students’s faculty advisor id, advisor last name, advisor location and phone number. You will join uc_student and uc_faculty 2. Write a SELECT statement that will return the faculty last name, faculty first name and the room for faculty whose …

hey all im new here... well as u know people are joining here are all usually having trouble or problem... just same like me... im having trouble in doing my project.. i wish somebody would please help me... here im in the mean time doing my project on DBMS.. so …