Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

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

From: Howard J. Rogers <>
Date: Fri, 5 Jul 2002 13:02:28 +1000
Message-ID: <ag32ag$laf$>

"Lovely Angel For You" <> wrote in message
> I got the idea.

Really? The rest of your post gives me cause to doubt that statement.

> Now one more thing. I am was creating a type of address book database,
> for birthdays and anniversaries. I was using Access. I thought of
> submitting this as my final year project.
> In the guidlines they wrote you dont have to use Access. SO I wanted
> to shift to any other database. Now we all use Windows Address Book.
> Even if have no database software installed. How does it control the
> database.

How does what control the database? And what is "it" and what is "the database"?

The Windows Address Book isn't a database, unless you stretch the term "database" to mean anything that stores anything. It's a program. It doesn't control anything. It just receives text input, stores it in a proprietary format, and can display the contents of that proprietary file when you run the program.

If you are contemplating creating something that somehow 'attaches' to the Windows Address Book and lets you edit the data it contains, I have a couple of comments. (1) why are you posting to an Oracle newsgroup? (2) forget it. WAB is a proprietary format. You are going to have to start knocking up some serious C code to be able to work with it. And (3) even if you managed to do all of that, you wouldn't be working with a database.

I would have hoped that some time during your final year, they would have taught you what a database actually is. Minor things like serialization, read consistency, roll forward and roll backward, transactional control and so on. None of which WAB has. A lot of which Access has. All of which Oracle has.

> My requirement is accessing a database without installing the whole
> software

Come off it. You can't expect to access a database without *something* at the front end. Access databases require Access to be installed. Excell spreadsheets require Excel to be installed. The Windows Address Book requires Windows to be installed.

You want to talk to a non-Access database? You have to install something. In the case of Oracle (and I presume that's why you are posting to an Oracle newsgroup) you have to install the Oracle client software. That's not the "whole software", because it doesn't include the 1Gb+ of software required to actually create and run a database. But it's the minimum you need to make connections to an Oracle database hosted elsewhere.

If you truly want no client software at all, then you are going to have to go down the road of using the Internet Explorer browser talking to an Application Server, which talks to an Oracle backend database, and program the lot in Java. That is highly advanced stuff, and a tad more complex than the Windows Address Book.

>and if required creating a DSN without user knowing it.

I've told you how to do that already. *You* have to know how to do it, even if your users don't. DSNs don't just invent themselves.

> Any ideas.
> Waiting.....
> Love
> Lovely
> =================================================
> "Howard J. Rogers" <> wrote in message
> > Forgive Daniel. He hates Access, hence his terse reply.
> >
> > It is entirely possible to develop an Access front-end to talk to an
> > (or other major database) on a different machine (a server). But your
> > teachers are correct that Access forms need to get their data from
> > *somewhere*, which means setting up a link from the PC running Access to
> > server running Oracle. That link is most easily an ODBC one.
> >
> > ODBC links for an Access form or query can be specified programmatically
> > using code like the following:
> >
> > Dim dbsCurrent As Database
> > Dim qdfPassThrough As QueryDef
> > Dim qdfLocal As QueryDef
> > Dim rstTopFive As Recordset
> > Dim strMessage As String
> >
> > Set dbsCurrent = CurrentDb
> > Set qdfPassThrough = dbsCurrent.CreateQueryDef("qryAreas")
> > qdfPassThrough.Connect =
> >

> >

> > DI=F;CSR=F;FWC=F;PFC=10;TLO=0;"
> > qdfPassThrough.SQL = "select * from composer.areas order by
> > qdfPassThrough.ReturnsRecords = True
> > dbsCurrent.Close
> >
> > This is a bit of code I use to create a pass-through query on a table
> > "Areas". Once the query has been created, I can then build an Access
form on
> > that query. Unfortunately, pass-through queries are read-only, so
> > the data can't use this method (hint: you have a form which isn't bound
> > anything, let the user enter appropriate data, and when they click a
> > RECORD" button, you gather all the entries as variables and construct a
> > pass-through query that reads 'insert into areas...' or 'update
> >
> > The key bit there is the 'qdfPassThrough.Connect' reference (which will
> > doubt wrap like crazy when you read this, but is in fact all on one
> > It tells Access to use ODBC, to look for a database called DB9, to
> > to that database as user COMPOSER, password "UNKNOWN". You can read up
> > all the other bits and pieces mean elsewhere.
> >
> > The trouble with this approach is the ODBC link. You must use an Oracle
> > driver to make that connection, and that *requires* you to install the
> > Oracle client (not the complete database, just the client software -but
> > that's still several hundred megabytes of install).
> >
> > When you use Access like this you have to have a mental gear change. The
> > application code belongs in the backend Oracle database as triggers or
> > procedures -it runs faster and more reliably that way. What you code in
> > Access should be very lightweight stuff to do with screen handling
> > error messages, trapping server errors and converting them to something
> > friendly, and so on. That means you need to start learning PL/SQL or
> > (conceivably) Java, since these are the languages of the backend.
> >
> > In short, what you want to do is entirely possible, but it does require
> > client PC installation, and a change in development practice from what
> > are probably used to.
> >
> > Regards
> > HJR
> >
> >
> >
> > "Lovely Angel For You" <> wrote in message
> >
> > > 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 - 22:02:28 CDT

Original text of this message