|
 |
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
|
|
|
View Cart
