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

lovely_angel_for_you_at_yahoo.com (Lovely Angel For You) wrote in message news:<55295a7e.0207041004.35535a80_at_posting.google.com>...
> 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
>
> ====================================

You are posting in wrong newsgroup. Oracle database *Cannot* be created and saved on 3 1/2 floppy drive to be installed "Easily" on another machine. i.e Unless you spin on your head for few hours -:)

I suggest you should post in comp.databases.ms-access or comp.databases.ms-sqlserver.

//Rauf Sarwar Received on Thu Jul 04 2002 - 19:56:08 CDT