BIGGERPLUM wrote:
> Hi,
>
> We have recently upgraded our oracle server to 10g Release 2 from 9i,
>
> We had MS Access project setup up with linked tables using the 9i ODBC
> driver, Having upgraded the server to 10g we decided to upgrade the
> clients as the 9i clients didnt seem to work with the 10g server.
> Having created a 10g connection with exactly the same name as the 9i
> connection was we thought the Access project should work fine , But we
> have found that when you start the project you get an error saying
> Prod9i unavailible even though when you test the connection under the
> ODBC connections in control panel it comes back successful.
>
> We have found that if you relink the tables when you start up the
> project it does work, However this doesnt seem to save and you have to
> repeat this process every time you start up the MS access project.
>
>
> If anyone could shed any light on this problem i would be very
> grateful!
>
> Adrian
>
> Oracle 10g release 2
> MS Access 2003
> Windows XP
> Oracle 10g is on Windows 2003
Likely the usual with Microsoft refusing to support the currently
released version of Oracle. Whose ODBC driver and did you get a version
supported by Oracle?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jan 24 2007 - 15:45:45 CST
