p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: connection to ODBC server


Message #1 by "Liz Haskin" <liz@t...> on Fri, 21 Jun 2002 15:39:01
Hi, can anyone advise me.
I am running an access database which has a couple of ODBC linked tables.  
The oracle database which houses the table has recently changed its 
server.  I have changed the name of the server in the 'Microsoft ODBC 
Administrator' on the control panel but the moment I try and open one of 
the linked tables it tries to go to the old server.  I assume that access 
has cached the old server name somewhere but I can't find where to change 
it.
Any ideas?
Liz
Message #2 by "Rogers, Robert (CIT)" <rogers@m...> on Fri, 21 Jun 2002 10:34:54 -0400
Just import the tables again.

Robert Rogers
SQL Database Admin
NIH, Digicon 
xxx-xxx-xxxx

-----Original Message-----
From: Liz Haskin [mailto:liz@t...]
Sent: Friday, June 21, 2002 11:39 AM
To: Access
Subject: [access] connection to ODBC server


Hi, can anyone advise me.
I am running an access database which has a couple of ODBC linked tables.  
The oracle database which houses the table has recently changed its 
server.  I have changed the name of the server in the 'Microsoft ODBC 
Administrator' on the control panel but the moment I try and open one of 
the linked tables it tries to go to the old server.  I assume that access 
has cached the old server name somewhere but I can't find where to change 
it.
Any ideas?
Liz
Message #3 by "Gerald, Rand" <RGerald@u...> on Fri, 21 Jun 2002 09:39:30 -0500
You will have to run the Linked Table Manager to re-configure the link 
to
the new connection.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Liz Haskin [mailto:liz@t...]
Sent: Friday, June 21, 2002 10:39 AM
To: Access
Subject: [access] connection to ODBC server

Hi, can anyone advise me.
I am running an access database which has a couple of ODBC linked 
tables.
The oracle database which houses the table has recently changed its
server.  I have changed the name of the server in the 'Microsoft ODBC
Administrator' on the control panel but the moment I try and open one 
of
the linked tables it tries to go to the old server.  I assume that 
access
has cached the old server name somewhere but I can't find where to 
change
it.
Any ideas?
Liz
Message #4 by "Amy Wyatt" <amyw@c...> on Fri, 21 Jun 2002 15:54:05
The easiest way is to go to  Tools -> Database Utilities -> Linked Table 
Manager.(this is W2K and XP(I think), Access 97 has this in a different 
area).

Select the tables you need to update. MAKE SURE THE 'Always Prompt for New 
Location' box is checked and click OK. When the datasources come up choose 
the new one and do the update. This should correct the problem. 

Hope this helps,

Amy

> Hi, can anyone advise me.
I>  am running an access database which has a couple of ODBC linked 
tables.  
T> he oracle database which houses the table has recently changed its 
s> erver.  I have changed the name of the server in the 'Microsoft ODBC 
A> dministrator' on the control panel but the moment I try and open one of 
t> he linked tables it tries to go to the old server.  I assume that 
access 
h> as cached the old server name somewhere but I can't find where to 
change 
i> t.
A> ny ideas?
L> iz
Message #5 by "Nicola Gilman" <ngilman@s...> on Fri, 21 Jun 2002 10:02:59 -0600
Unlink your table and re-link it.

-----Original Message-----
From: Liz Haskin [mailto:liz@t...]
Sent: Friday, June 21, 2002 3:39 PM
To: Access
Subject: [access] connection to ODBC server


Hi, can anyone advise me.
I am running an access database which has a couple of ODBC linked tables.  
The oracle database which houses the table has recently changed its 
server.  I have changed the name of the server in the 'Microsoft ODBC 
Administrator' on the control panel but the moment I try and open one of 
the linked tables it tries to go to the old server.  I assume that access 
has cached the old server name somewhere but I can't find where to change 
it.
Any ideas?
Liz

Message #6 by PStreeter@C... on Fri, 21 Jun 2002 10:42:10 CST
On Fri, 21 Jun 2002 15:39:01 "Liz Haskin" wrote:

> Hi, can anyone advise me.
> I am running an access database which has a couple of ODBC linked
> tables.  
> The oracle database which houses the table has recently changed its 
> server.  I have changed the name of the server in the 'Microsoft ODBC 
> Administrator' on the control panel but the moment I try and open one of 
> the linked tables it tries to go to the old server.  I assume that access 
> has cached the old server name somewhere but I can't find where to change 
> it.
> Any ideas?
Did the "listener" identity change? This is a layer of the connection 
with Oracle, but I can't say anything more intelligent about than 
that. I think you may have to relink the tables, possibly with a new 
name.

Paul



  Return to Index