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

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
>
> ====================================

If you are thinking that Oracle can be thrown around like M$ Access you are misunderstanding what the product is and I strongly urge you to forget the entire idea.

Daniel Morgan Received on Thu Jul 04 2002 - 15:01:04 CDT