Re: Access to Oracle - a weird problem of connectivity

<chrisbrady_at_my-deja.com> wrote in message news:91ap1b$s4s$1_at_nnrp1.deja.com...
> Access to Oracle - a weird problem of connectivity
 ...
> So why is it that on identically set up servers with identically
> replicated tables I can read, append, update and delete records to both
> tables when I logon to the servers directly. But when I use Access to
> link to QQ03 I can also can read, append, update and delete records to
> both tables. But when I use Access to link to QQ40 I can only read,
> append, update and delete records to one table, whilst the other
> becomes read only?

#1 How many Oracle homes does the the client have? ( HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\HOME_COUNTER ) #2 What is the driver (
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\dsn_name\Driver ) for both DSNs?

My wild guess is that #1 is a value greater than 1. That, the values for #2 for each is different. And, that if you drop the two DSN, create two new ones, you'll experience identical behavior (both good or both bad). Upgrading Oracle 8x ODBC drivers does NOT necessarily upgrade the existing DSNs. Just an idea.

--
Michael O'Neill
mjoneill_at_email.com