Hi! :-)
On Tue, 1 Feb 2000 at 15:52, Michael Widenius wrote:
>The above should work. Which MySQL version are you using? Are you sure
>that the test_oc exists in the contactmgr database?
I'm using MySQL v3.22.27 (yes, I'm working on upgrading it to 3.22.30
already) on a Linux kernel 2.2.14 machine. MyODBC is 2.50.29.00 on a
Windows 95 4.00.950B machine.
The options used in the connect screen: allow BIG results,
safety. Everything else is unchecked. Basically this is what happens:
DATABASE dbase_test_01
TABLE dbase_test_01.table01
DATABASE dbase_test_02
TABLE dbase_test_02.table02
Sequence of actions:
1. Link both tables using machine DSN name "MySQL".
2. Exit Access.
3. Open Access database.
4. Open link to dbase_test_01.table01, login, all is okay.
5. Open link to dbase_test_02.table02, error because it is trying to
open dbase_test_01.table02 which of course does NOT exist.
Alternate sequence:
...
4. Open link to dbase_test_02.table02, login, all is okay.
5. Open link to dbase_test_01.table01, error because it is trying to open
dbase_test_02.table01 which again, does not exist.
I've worked around this problem by having multiple machine DSNs with
different names. But of course things would be nicer if I could share one
DSN. Hmm ... any other thoughts? Please help. Thanks. :)
-+[ Jijo Sevilla ]+-
jijo@stripped
