Re: Linking to Oracle

Thanks for the info. The oracle client is on each machine already, I will
look into automating the ODBC installation and create the link on the front
end.

Do you have a sample code of how to create the odbc connection and
incorporate the password so the users dont have to do that?

"Clifford Bass via AccessMonster.com" wrote:

Hi,

Since the Oracle client installation is complicated, it is probably best
to do that manually on each machine. Or provide the Oracle installation
program(s) and explicit instructions for your situation. You could create a .
REG file with the Oracle ODBC registry settings to simplify things somewhat.
The user would simply double-click it and the Oracle ODBC settings would be
imported into the registry. Installation program wizards may simplify things
further.

Once you create the linked table manually in the front end, whenever
someone attempts to use it for the first time after opening the Access FE
database, it will automatically prompt for the Oracle logon credentials. So,
no need to do the connection in code. Or, if it is using generic creditials
set up for just this purpose, you could tell Access to save the password when
creating the linked table.

Hope that helps,

Clifford Bass

lcox400w wrote:
I have a split database we have been using for about a year. I want to add a
new feature to the application that will query a table in our oracle DB to
retreive some information to reduce duplicate data entry. I know how to link
to the oracle database manually but I'm not sure how to proceed with doing
this in VBA.

None of my client machines have the ODBC Connection on them. So my first
questions are, do I create the link manually on the front end of the app and
then install the ODBC on each client machine? Or is there a better/easier
method of doing this?

My second question is, I'm not sure how to use VBA to open the database
table I want so I can then run the query. Since the database is not part of
my tables, I have never opened a second database through VBA before if
someone can help point me in the right direction with a sample?

thanks in advance.

--
Message posted via http://www.accessmonster.com

.

.

Relevant Pages

  • Re: Asp.net / iis / oracle problem - never mind , i think i found
    ... Installed Oracle Client software on Server ... My DBA had to create synonyms for the account used to access the database to ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Asp.net / iis / oracle problem
    ... It is more than the libraries necessary for the Oracle SQL ... Oracle client and networking components were not found. ... later client software installation. ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Oracle Client and ADO.NET
    ... I was reading thru some documents and it seems that an oracle client ... installation, Rapid App Dev Installation, etc... ... Of course I can use OLEDB/ODBC providers instead if this doesn't ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle ODBC connection problem
    ... This has to be one of the most pathetic problem I've ever run into. ... I am trying to connect to my local ORACLE instance using ... >> trying to use ODBC on the same computer. ... > available under the menu 'Oracle installation products' ...
    (microsoft.public.data.odbc)
  • Asp.net / iis / oracle problem
    ... box does not think that the Oracle Client is not installed... ... Oracle client and networking components were not found. ... later client software installation. ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.dotnet.framework.aspnet)