Re: Switching ODBC Oracle databases
- From: "Lynn Trapp" <ltrapp_NOSPAM@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Feb 2006 14:45:02 -0600
As an Oracle developer, I'm puzzled why you have "10 or more Oracle"
databases. Do you mean tables? If so, why do you need 10 or more Oracle
tables that are structured the same way? Did your Oracle DBA let you create
multiple tables with the same structure?
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
"Paul Hammond" <phammond@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0203AD1C-4934-4664-A6DF-1F7DC54DD147@xxxxxxxxxxxxxxxx
We have 10 or more Oracle db all structured the same way. I want to be
able
to switch between them based on the value in a combo box. I've already
set
up the ODBC connections. Here's the code I am using.
strDB = Me.cboPub.Column(2)
strConnect = "ODBC;DSN=" & strDB &
";UID=MyUID;PWD=MyPassword;LANGUAGE=us_english;" _
& "SERVER=" & strDB
DoCmd.DeleteObject acTable, "ADDR_VW_ADDRESS"
DoCmd.TransferDatabase acLink, "ODBC Database", strConnect, acTable,
"ADDR.VW_ADDRESS", "ADDR_VW_ADDRESS"
This repeats for several more tables.
This fails until I manually connect to each database once. After that I
can switch between all the databases using this code.
How do avoid this manual process. Am I missing something in my connection
string?
The code
--
Can't we all just get along?
.
- Follow-Ups:
- Re: Switching ODBC Oracle databases
- From: Paul Hammond
- Re: Switching ODBC Oracle databases
- Prev by Date: Re: Importing data to changed tables
- Next by Date: Re: Import Word table document into Access
- Previous by thread: Re: Importing data to changed tables
- Next by thread: Re: Switching ODBC Oracle databases
- Index(es):
Relevant Pages
|
