Re: Acces To SQL - Exporting To Comp Without SQL - Possible Or Not ?

From: Martin Doherty <martin.doherty_at_oracle.com>
Date: Tue, 09 Jul 2002 09:46:48 -0700
Message-ID: <3D2B1378.4FFEBCDB@oracle.com>

I did see mention in this group a little while ago of a client database from IBM called Cloudscape which might satisfy your requirement of simple all-in-one package installation. Check the IBM website and do a search. Also search the google archives for this newsgroup for 'Cloudscape' to locate the original posting. I don't know if you can legally get a copy for free or not. You could ask your teachers, sometimes vendors supply educational licenses for their products to help students.

By the way, SQL is not a product name. It is an industry standard data query language specification that is used in various forms in many products. To be clearer, you should say "SQL database product" or "SQL DBMS" or "SQL RDBMS".

Martin Doherty

---

To reply, remove the freebeer (you knew there was no such thing, right?

---

Lovely Angel For You wrote:

> Dear Friends
> Hope you all doing great.
>
> I have a query regarding use of SQL in my software.
> I am having a softare in which I use VB as frontend and Access at
> backend. When I create installer package for this project I include
> the dependencies files and drivers required to run Access database.
> This enable me to install my software on any computer whether the
> computer has MS Access installed or not.
> And I am able to run this software easily.
>
> Now I want to use SQL or any other database package instead of Access.
> And I also want that I am able to install it to any computer
> regardless of whether that computer has SQL installed or not. I should
> be able to run the software without installing SQL or any other
> database package. Same as I do with Access project.
>
> But as per my research and knowledge of my teachers it is not
> possible. They say you have to install SQL. One of them say even if I
> am able to run the software without installing SQL and exporting the
> drivers required I still have to create DSN.
>
> I am ready to that provided I dont have to install SQL. But I also
> intend to distribute this software to novice users who doesnt know how
> to create DSN. So I want DSN creation is done at the back from within
> the code while installing so that user doesnt have to do anything and
> user doesnt come to know that I have created a DSN.
>
> This is what the problem is. Any help will be appreciated.
>
> In brief
>
> Proj with MS Access --> Export drivers required with installer -->
> install on on any computer --> run on computer with MS Access.
>
> Proj with SQL --> is whole of the above process possible.
>
> Please let me know of this.
>
> Waiting......
>
> Love
> Lovely
>
> ====================================

Received on Tue Jul 09 2002 - 11:46:48 CDT