|
Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Re: Q: Accessing databases through Visual Basic
Re: Q: Accessing databases through Visual Basic
Hello,
Yes
you can do that because I'm actually doing the same thing, Developping
the software with an ODBC connection to Access and then I'm implementing
it with Ingres (it's a Oracle-like database but worst...), I have just
few problems of translation because the ODBC drivers of Ingres are quite
bad... ;) But you just have to take care of making general SQL Query (using
the ODBC syntax, it's a standard SQL like Oracle SQL) not the specific
syntax of Access which can be use with ODBC too but not with other ODBC
connections than the Access one.
And
another thing to think is the permission, I think you have strong access
permission under Oracle (like under Ingres) but they are less under Access
so think of it when doing your program and then you'll not have to correct
it...
Ciao,
Jean-Christophe
Tom Nixon wrote:
Hi
Am I correct in thinking that if I write some VB code to interface
with
an Access database, it should be a minor task to alter the code if
the
implementation of the database changes to Oracle. Basically I want
to
use Access as the development platform then recreate the schema in
Oracle later on. I'm hoping that ODBC hides all of the specifics of
the
database, letting me do this. Any comments would be appreciated.
cheers,
Tom
Received on Tue Jul 20 1999 - 06:22:47 CDT
Original text of this message
