[dba-Tech] Access/Oracle

Erwin Craps - IT Helps Erwin.Craps at ithelps.be
Wed Jan 25 15:59:39 CST 2006


You can link Oracle tables but you can also access with ADO.
I'm not an Oracle specialist but for one customer I'm dooing this for
several years now.

You need to install, using the Oracle installer, a softwareaddition to
the Orcale client thats is called Office OLE something support. That way
you can use ODBC connections and link a table. I'm not really sure is
this is sufficiant but I believe so.
The use of ADO from VBA is by default supported, but I believe from
Orcale 8 or 9 on.


Ofcourse your Oracle client must already be instaleld and properly
configures (TNS).

Erwin 



-----Oorspronkelijk bericht-----
Van: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] Namens MartyConnelly
Verzonden: woensdag 25 januari 2006 22:34
Aan: Discussion of Hardware and Software issues
Onderwerp: Re: [dba-Tech] Access/Oracle

This might help too.
ADO Data Type mapping Table between Visual Basic, Access, SQL Server,
Oracle,
http://www.carlprothman.net/Technology/DataTypeMapping/tabid/97/Default.
aspx

And you might look at acquiring TOAD for Oracle, the IT guys might
appreciate it.

http://www.quest.com/toad/app_sqldeveloper.asp

Tesiny, Ed wrote:

>To access our agency's data we have to use this %$#@& Oracle tool 
>called Discoverer.  Could one access Oracle tables using Access as a 
>front end through an ODBC connection.  If so, would it be a big deal to

>set this up.  The last time I asked, the IT answer was we can't do 
>that.  Never got a why we can't do that???  Anyway, that person is now 
>gone and I'm wondering if I should give it another try.
>Any thoughts/advice appreciated.
>Ed
> 
>Edward P. Tesiny
>Assistant Director for Evaluation
>Bureau of Evaluation and Practice Improvement New York State OASAS 1450

>Western Ave.
>Albany, New York  12203-3526
>Phone:  (518) 485-7189
>Fax:  (518) 485-5769
>Email: EdTesiny at oasas.state.ny.us
> 
>_______________________________________________
>dba-Tech mailing list
>dba-Tech at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-tech
>Website: http://www.databaseadvisors.com
>
>
>  
>

--
Marty Connelly
Victoria, B.C.
Canada



_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com



More information about the dba-Tech mailing list