Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Acces To SQL - Exporting To Comp Without SQL - Possible Or Not ?

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

From: Lovely Angel For You <lovely_angel_for_you_at_yahoo.com>
Date: 4 Jul 2002 11:04:10 -0700
Message-ID: <55295a7e.0207041004.35535a80@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


Received on Thu Jul 04 2002 - 13:04:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US