Oracle and Vb

[kovan]

i need to write a application that will automate the process of copying information from oracle server to access db..

anyone have a good tutorial, site, project.. that shows how to connect to a oracle server using vb..
thank you

Kovan -
I always create a pass-thru query in Access that works, then
use it as a model for writing pass-thru on the fly. You have
to set up the connection string through the ODBC manager.
Naturally, this will work only on the machines that have the
link set up in the same manner.

Hope this helps
DerFarm

[kovan]

here is a more detailed of what i am looking for..

our oracle database is on on a machine in the network...

the name of the server is CISDEV
there is one table called METER
some fields in that table are meternum, serviceid, metertype

on my machine, i have no oracle installed..
using ADO, how can i access that table and retrieve information from this table..
either doing this DNS connection or DNS-LESS connection
if anyone could give me code, i would greatly appreciated..

as long as i can make a connection to the server successfully, that would be great

thanks

You can't connect to an Oracle Database without the Net-Client from Oracle, because you have to create a TnsNames.ora

[kovan]

ok
so it cant be done without oracle?

we have a machine that has oracle 8 on it..

so now how do i go about connecting to db
(this machine that has oracle on it.. access the server using odbc, however i dont want want to use odbc, i want to use ado...)

Sure it can be done. In the ODBC manager (on my maching
its called the ODBC Data Sources (32 bit)), you can set up
a path to the Oracle database. Once the path is setup, the
Oracle database should show up under Files->GetExternalData-
>Link->ODBC Databases.

We have a very similar set-up on a RAID machine. I assure
you that I do not have Oracle on my machine.

I'll look today to see if I can find the documentation on
the process. Maybe I can give you the name of the book.


Good Luck
DerFarm