|
Sir/Madam
I am Final Year Engineering student. I want to get information about connection of computers at different cites.
Actually if I want to computerize a department of any company which have its offices at several cities then what steps I should follow.
Means how I can connect that no of computers in appropriate manner to get desired output.
I want to make it just like railway reservation system through in which if I enter data at same time then database must be able to prioritize data in sequence to enter in database.
Which database & platform or language I should use to code this kind of project.
Thank You
Ashish Porwal
|
|
|
|
|
|
I've used an Access database for this purpose. The windows operating system will most likely already have the Jet database engine (which access uses) installed. If not you can require users to download MDAC in your program's setup/install package which is a small download compared to MSSQL, SQL Express or other full database engines. The downside is that Access is a relatively small database with not as much capability as other engines. But the projects I was doing were quite small.
Hope this helps.
|
|
|
|
|
That is really helpful. So what you are saying is when i need to distribute my program, i would not need to install a database engine on the clients computer?
|
|
|
|
|
Correct. You will only need to make sure that they have MDAC installed and if not, then install it. But the install is under 6 MB and most computers will already have it installed. Windows XP SP2 already has it, for example. I can't remember what service pack Windows 2000 has it.
In any case, it is pretty easy to require MDAC when you are creating an install program with Visual Studio 2005. You just right click on the project icon in the Solution Explorer. Select Properties. Click the Prerequisites button. And make sure that Microsoft Data Access Components 2.8 is checked in the list. And if you want the user to be able to just install the MDAC without having to go to Microsoft's website I would recommend selecting the "Download prerequisites from the same location as my application" option.
Also, remember that if a user happens to have microsoft access on their computer, they can access your database through that. So you may want to put a password on it to make sure they don't change things/mess up your schema.
Hope this helps.
|
|
|
|
|
Yes, your help is much appreciated.
Somebody else suggested programs like Microsoft Visual Fox Pro, but I had doubts about the availability of them, well from the users perspective at least.
Once again thank you very much for your help.
|
|
|
|
|
|
if it's SQL Server you can use:
<br />
select table_name<br />
from<br />
information_schema.tables<br />
if it's Oracle you can use the meta data views, like:
<br />
select *<br />
from<br />
user_tables;<br />
-- modified at 14:16 Monday 15th January, 2007
Uri
|
|
|
|
|
Thank you ,very much.
In Ms Access database,how to do?
|
|
|
|
|
Hi....
Please tel me how to fetch dates from a date column in which interval between 2 subsequent dates should be 7 weeks... I have trued a lot but i m not able to build query for this...
Plz help me out..
Thanx.
Gurudatta B. Shelke
|
|
|
|
|
You would add 49 days to the first date to get the second date. I'm not being funny here about the syntax, because the exact syntax differs between databases.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
i want to design a feedback form n which i have kept a multiline textbox for putting comments of the user and then hit the submit button to submit the comment into the database. but when i want to retrive those comments from the database & view them in a grid,i just got the continious lines of data...my requirement is i want to view the data in that manner and style in which i have enterd it during the submission process with the same style and manner...can anybody help me in this regard how to do it or can give me any link regarding this..(like paragraph,heading...etc..)
thanks in advance..
pradip kishore
|
|
|
|
|
Pradip Kishore wrote: but when i want to retrive those comments from the database & view them in a grid,i just got the continious lines of data
Actually you don't. You get the data exactly as it was put in to the database. Multiple lines and all. The problem is the way browsers render HTML. They view your text as HTML and in HTML a carriage return or newline character does not signify a new line. You must replace the newlines with <br/> in order to be formatted properly in the web page.
So, this becomes an ASP.NET problem, not a database problem.
|
|
|
|
|
what is the difference between Layred Arctitecture and Non Layred Arctitecture?
ashu
|
|
|
|
|
Ashutosh Kumar Gupta wrote: what is the difference between Layred Arctitecture and Non Layred Arctitecture?
A layered architecute separates the database from the business logic from the presentation of the information.
A non-layered architecture is sometimes pejoratively called the giant ball of mud architecture. And for good reason, in all but the smallest of projects the code in a non-layered architecture will event resemble a giant ball of mud. Finding anything in that ball of mud becomes increasingly difficult.
|
|
|
|
|
|
create querry to drop a row from table
pradeep kulkarni
|
|
|
|
|
pradeep kulkarni wrote: create querry to drop a row from table
You DROP objects, you DELETE rows.
DELETE FROM MyTable
WHERE primaryKey = 123
|
|
|
|
|
drop table table name;
fuhgldfugyfdkjdluikhusjgh
|
|
|
|
|
|
How can i copy a column from one table to another (data and schema) at runtime in vs 2005?
the data and schema are read from xml files
-- modified at 8:44 Sunday 14th January, 2007
rzvme
|
|
|
|
|
Write an sp, that will do that and call it from your code.
The sp (for SQL server) will look something like this:
INSERT INTO [InsertDB].[dbo].[InsertTable]<br />
( [ColumnName1],[ColumnName2] )<br />
SELECT [ColumnName1],[ColumnName2]<br />
FROM [SourceDB].[dbo].[SourceTable]
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
how to create table in SQL, give one example
pradeep kulkarni
|
|
|
|
|
pra47 wrote: how to create table in SQL, give one example
Look up the SQL syntax for the CREATE TABLE statement in Google or in a reference book. You will need to supply, at a minimum, the field name and field type for each field that you want the table to contain.
HTH
|
|
|
|
|
I have a table Named 'Roles' which contains 'ID' and 'ParentID' fields.
Some Sample Data is
ID ,Name ,ParentID
1 ,Admin ,0
2 ,Manager ,1
3 ,Front Office User ,1
4 ,Supervisor ,2
5 ,Inventory User ,0
6 ,Human Resource User ,4
I would like to extract data of Parent and all children.
SELECT b.[ID] as 'Parent', a.[ID] as 'Role'
FROM Roles a
INNER JOIN Roles b
ON a.ParentID = b.[ID] and a.ParentID=1
which can return only.
ID ,ParentID
1 ,2
1 ,3
My wanted form is
ParentID ,ID
1 ,2
1 ,3
2 ,4
4 ,6
Like an organization tree, the top parent level can access all lower level nodes.
Sql 2005 support that feature.
How can I access them in Sql2000 recursive function or store procedure?
Thanks
May Thu San.
|
|
|
|