473,699 Members | 3,180 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can I write an application with no server ?

[cross-posted on .databases.info rmix and .databases.ibm. db2]

Hello

I have an application using an internal database (user doesn't know
about it) and I would like to know if I can use some IBM product with a
run-time that I could emmbed in my app and redistribute, to provide SQL
access to database and possibly to let me create the database on first
run (after my app is installed). All that without the user having to
provide me an working instalation of a server. I would like just some
lite run-time to do the job. That is I am looking for a replacement to
Microsoft JET and MDAC.

Does anyone know an appropriate product from IBM that could do what I need ?

I tried searching IBM sites for DB2 and Informix and found nothing
relevant :(

Thank you
Timothy Madden
Romania
Jan 12 '06 #1
6 1316
Consider HyperSQL http://sourceforge.net/projects/hypersql/ then maybe
IBM Cloudscape
http://www-128.ibm.com/developerwork...es/cloudscape/ that are
very lightweight (with a tiny memory footprint) and "in theory" don't
require administration. AFAIK, HyperSQL may even be embedded in your
application.

Jan 13 '06 #2
Timothy Madden wrote:
[cross-posted on .databases.info rmix and .databases.ibm. db2]

Hello

I have an application using an internal database (user doesn't know
about it) and I would like to know if I can use some IBM product with a
run-time that I could emmbed in my app and redistribute, to provide SQL
access to database and possibly to let me create the database on first
run (after my app is installed). All that without the user having to
provide me an working instalation of a server. I would like just some
lite run-time to do the job. That is I am looking for a replacement to
Microsoft JET and MDAC.

Does anyone know an appropriate product from IBM that could do what I
need ?

I tried searching IBM sites for DB2 and Informix and found nothing
relevant :(


I'm going to commit heresy here and suggest that you look into c-tree Plus
from Faircom. It's an embedded ISAM style database with Relational features
and an available embeddable and stand-alone client server SQL engine and
separate user level SQL interface. You get all of these interfaces with the
same application source and ctree's highly portable source code to boot.
You get the best of both - an embeddable database and the ability to give
your uses an adhoc query tool and to hook them in from many ODBC tools they
may already know like MS Access and other unspeakable abominations.

C-tree was my favorite before I met Informix.

See www.faircom.com/products/ctree

Art S. Kagel

Jan 13 '06 #3
Faircom seems to support C/C++ interface only, what if the application
is java?
Also it's a commercial product whereas HyperSQL and IBM Cloudscape are
freeware (might not be an issue though)

-Eugene

Jan 13 '06 #4
Eugene F wrote:
Faircom seems to support C/C++ interface only, what if the application
is java?
Also it's a commercial product whereas HyperSQL and IBM Cloudscape are
freeware (might not be an issue though)

-Eugene


Thank you all for your suggestions.

My app is C++, but when I will chose a product, I will have to convince
my manager it is ok to switch. So a product with IBM brand on it would
realy help. It's not clear to me as yet if Cloudscape can be emmbeded
and the run-time redistributed with my app. I will have to check that.

What can you tell me about stability ? My is supposed to keep phone
calls in the database for an unlimited period of time (several years),
so I can take no chances to get the databse corrupted. Unfortunatly it
still happens with many, many new and young products :(
Timothy Madden
Romania
Jan 13 '06 #5
Timothy Madden wrote:
[cross-posted on .databases.info rmix and .databases.ibm. db2]

Hello

I have an application using an internal database (user doesn't know
about it) and I would like to know if I can use some IBM product with a
run-time that I could emmbed in my app and redistribute, to provide SQL
access to database and possibly to let me create the database on first
run (after my app is installed). All that without the user having to
provide me an working instalation of a server. I would like just some
lite run-time to do the job. That is I am looking for a replacement to
Microsoft JET and MDAC.

Does anyone know an appropriate product from IBM that could do what I need
?

I tried searching IBM sites for DB2 and Informix and found nothing
relevant :(


There are a number of companies who embed DB2 into their products with the
number growing with each release. The downside is that DB2 is still a
server (even if you turn off remote connections), and that you are still
limited to a single copy of DB2 on the system (i.e., if your customer
wanted to use both your product and to use DB2 normally, on the same
machine, they would have to be the same copy).

The real big upside to using DB2 (or Informix or ...) is the wealth of
experience that their code brings to your product. This can be a real
value-add for larger clients where they may outgrow a single computer and
need to cluster, for example. Or just in the fact that you no longer need
to worry about ACID requirements or backups/restores (you may just need to
provide an interface to the backup/restore functionality if you want to
hide the underlying database).

With DB2 as the example (since I don't know Informix), you can embed DB2 by
using the silent (response-file) install. You may also look into the
db2iprune tool if you're on Windows in order to remove optional components
that you don't want so as to shrink the size of the DB2 image and possibly
fit both your application and DB2 on the same CD if that's how you
distribute your software. (You can do the same on unix/linux, but the tool
is called 'rm' - I'd go into more detail, but I think you're worried only
about Windows.)

In that response file, you can install and set up DB2 for immediate use.
Then you can create any databases and start using the product immediate as
part of your own. I don't think the learning curve to do this is very
large at all - if you can write C++, this should be trivial ;-)

Jan 13 '06 #6
Timothy Madden wrote:
Eugene F wrote:
Faircom seems to support C/C++ interface only, what if the application
is java?
Also it's a commercial product whereas HyperSQL and IBM Cloudscape are
freeware (might not be an issue though)

-Eugene


Thank you all for your suggestions.

My app is C++, but when I will chose a product, I will have to convince
my manager it is ok to switch. So a product with IBM brand on it would
realy help. It's not clear to me as yet if Cloudscape can be emmbeded
and the run-time redistributed with my app. I will have to check that.

What can you tell me about stability ? My is supposed to keep phone
calls in the database for an unlimited period of time (several years),
so I can take no chances to get the databse corrupted. Unfortunatly it
still happens with many, many new and young products :(


C-tree is very stable. Haven't used it myself for years, but I first used
it in 1982 or so and the API and core embedded direct access code has not
changed much since. The whole client-server version is newer (circa 1990)
but still venerable and stable and the API is identical so you can ship with
the embedded DB but offer a client server upgrade and it could be handled by
installing the server and setting a config variable on the clients.

I do agree with Darin that using a true and complete RDBMS like DB2 or
Informix will give you a far more robust product, but your customers will
have to pay licensing fees through you which will boost your sales price or
cut into profits.

Art S. Kagel
Jan 13 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2773
by: Brett | last post by:
We have an application where the iusr_<srvr> has write NTFS permissions to a folder under the wwwroot (i.e. wwwroot\folder) and also there is a SQL Server database where we must give the iusr_<srvr> read and write permissions on the database in order for the application to work. Anonymous access is enabled on the default web site where this web app is located. Because we are using the iusr is there simple exploit code that could allow...
2
13511
by: FrodoBaggins | last post by:
Dear Team, I am running Visual Studio 2003 Version 7.1.3088 on Windows Server 2003. I have written a C# application that must write to the event log. When it attempts to write to the event log, however, I get the following message on the browser shown below in bold text: Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required...
3
7953
by: Angelos Karantzalis | last post by:
Hi y'all, recently I've come across a situation where a web service needs to deal with an exception that might arise, originating from a COM+ component. It then returns an int value (please don't ask me why) indicating that there was something wrong with the requested operation. Assuming that I don't really know all the posible exceptions that might arise from the COM+ layer, and therefore I can't accurately return an int identifying...
0
1525
by: Zed | last post by:
I have a problem with .net writing to a remote server that I need to deploy on. The app works fine on my local machine. But when got access to the server I went to VS.NET and tried to create a project the regular way, I got this message "The web was created successfully, but an error occurred when trying to configure the application root for this web. Web projects may not operate correctly without application root. The returned error was:...
0
926
by: steve | last post by:
Can any body tell my if I can use VB to write a web server side applion? We currently have a e-commerce web application using: Apache Web Server -> Java Servlet -> Sybase. A customer asked us to re-write it with: IIS -> VB 6.0 -> SQL server. I know VB is great tool for front end application. Can it be used to write server side application? Or it can be used but it's very difficult if it is not improssible? How about using .NET +...
11
3107
by: Michael Powe | last post by:
How can I make an XHTML-compliant form of an expression in this format: document.write("<scr"+"ipt type='text/javascript' src='path/to/file.js'>"+"</scr"+"ipt>"); this turns out to be a non-trivial exercise. inserting '&lt;' and '&gt;' causes the browser to write the text to the page as literal text rather than as the intended script element. Using escape codes seemed to work (makes it standard compliant) but the text is not written to...
0
2798
by: ttamilvanan81 | last post by:
Hai, I am doing a Struts application. In this application, i need to read a dbf file(foxpro database file) and it will be write to the SQL Server 2005. The application administrator will be give the dbf dump file, that dump file will be uploaded by owner's(small(updated database) file will be uploaded by administrator at every month). If the dump file was uploaded, Then We go to export the dump file, as Read and write into the SQL...
4
3201
by: Ross | last post by:
Hello, I am trying to Read and Write to a text file on a web server using Microsoft Visual Basic 2005 Express Edition. So far I have managed to complete my testing with a local text file using the StreamReader Class. Is it possible to use this class when trying to read and write to a text file located on a server? If so, could you please provide some examples? I have setup a free web host with www.ifastnet.com and have some connection...
8
1718
by: Mike Silva | last post by:
Hello all, I'm a longtime programmer (embedded with a smattering of desktop stuff as well) who knows very little about web programming. Right now I am developing the prototype of a multi-user application in MSVC++, but I think it would make more sense to redo the app as a web application (which I know almost nothing about, remember). From poking around I see that PHP is a fairly mainstream candidate for me to consider. Now, I will...
3
6938
by: sriram347 | last post by:
Hi I am a newbie to ASP.NET. I developed a web page (project type is web application) and I keep getting this error. B]Error message : "System.AccessViolation Exception attempted to read or write protected memory. this is often an indication that other memory is corrupt.... " These are all the platform info : Visual Studio 2005 (VB.NET) and ASP.NET 2.0.
0
8706
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8633
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9199
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9055
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6552
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5891
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4392
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3076
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2016
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.