Hey guys, I've developed some software that uses a database. Is there any way I can somehow put a file onto any pc that acts as the database file and can be modified by the user without having to have SQL on every computer?
2007-09-20 10:45:26 · 6 answers · asked by austin 2 in Computers & Internet ➔ Programming & Design
Of-course you can do it...
What you've asked is just a Client-server architecture is all about.
Well, I am Java programmer so i would say things in that context.
In java ,you can do it with remote method invocation(RMI) which is analogous to RPC in closed source tech.
That is what any network/web application is all about.
Well in java/jsp you got JDBC API for that...your job can be done by all 4types of drivers.
Type 4 and type 3 kinda drivers dont need client side having those installed.That is most suited for your needs.I am pretty sure Microsoft must have something in c# or Asp too...
See.microsoft provide ODBC(Open database connectivity) drivers.
That drivers can be invoked via JDBC or any Native(C/C++) codes.
You got to have knowledge of those drivers n programming..for accessing sql files.
I am sorry about friend who just deny that SQL server/Rdbms cant be modified on network...in fact SQL Server is Relational database designed for those purposes.
hope this helps
Cheers:)
2007-09-20 11:32:57 · answer #1 · answered by Neeraj Yadav♥ 6 · 1⤊ 0⤋
The simple answer to your question is 'no'. First off, SQL stands for 'Structured Query Language', and it is used by almost all databases, including MS Access, SQL Server, Oracle, etc. I am thinking that when you ask about having SQL on each computer, you are really wondering if the users can somehow modify database tables/rows without having an actual databse on their computer, and the answer to that - notwithstanding the web based solution another poster referred to, or some kind of specialty app that connects to one over a network - is 'no' as well. I would suggest using either MS Access, which ships with Office, so most computers already have it, or MySQL (a free alternative) for the database. It would help to know what your true objective is. There are other things that could be done, like creating a thin client that connects to a database over a network, etc. More details would be helpful.
2007-09-20 18:20:45 · answer #2 · answered by Anonymous · 0⤊ 1⤋
You need an SQL server in the machine to use the database file. SQL is a language of DB, and you need software to "read" it. Thats what the server does. To develop "portable" databases, u d better try to use XML, in case its a Web related project. In other case.... i think you cant use a database file without a server... well, u can program a "reader and writer" of the file... but...
Aniway, u could develop your project and make him remote connect to a SQL server in a central server. Thats usually what u do.
GL
2007-09-20 18:30:27 · answer #3 · answered by Severo1980 2 · 0⤊ 0⤋
You could make an application that includes JDBC, ODBC, etc... to support an interface that allows editing the data. If of course you are using more advanced SQL or want to allow more than just a single table with a few editable columns, check out some web based SQL solutions. Oracle 10g (not sure what level includes) Enterprise Edition includes an iSQL*Plus option to let users perform most SQL queries in their browser. The one limitation that I've seen that is only a minor problem is when I have wanted to use the SPOOL command, but for that I just telnet over to my database host system.
2007-09-20 17:54:33 · answer #4 · answered by Jim Maryland 7 · 1⤊ 1⤋
SQL is "Structured Query Language" and many databases support it. ... "SQL Server" is a database.
If you want to use SQL-the-language to query and alter data, but you want that data to live in a text file, you would have to write LOTS of sophisticated code to parse the file, analyze it and interpret the SQL commands. You would also have to invent a way to represent the relationship of the data. It's really not practical.
Consider whether XML might be a better way to store the data.
If you really need a database, you can explore some of the embedded databases that are available. Some are open source and some support SQL.
2007-09-20 17:57:43 · answer #5 · answered by christnp 7 · 0⤊ 2⤋
What kind of database is it? If it's just Access, then sure, you can. If it's SQL Server, then no, you cannot.
2007-09-20 17:54:17 · answer #6 · answered by kryzchek79 5 · 0⤊ 1⤋