I've had the same issues. I have really avoided the dev side of things
for some time so I'm not sure whether there's a way around it. Mainly
just devoting myself to administration. Funny though I'm starting to
write jsp stuff to monitor the databases more effectively.
I agree with you on the MYODBC from unix to windows and vice versa. Shouldn't
be that different.
Dave
On Mon, Sep 24, 2001 at 03:09:50PM -0600, Adam Douglas wrote:
> > What type of schema do mean here ? Because as you know, MySQL doesn't
> > explicitly supports any schema's except the catalogs( in MySQL term
> > 'database'). If you can elaborate what exactly the problem
> > you are facing,
> > then we can provide a rapid solution.
> >
> > Also, as for as I know, when I change something in my table
> > in MySQL server
> > side (including the table structure), it does reflect on the
> > linked tables
> > without any problems, and vice versa too.
>
> I have the following setup...
>
> - MySQL 3.22.32 on OpenBSD v2.9
> - MyODBC on Windows '98 SE
> - MS Access 2000
>
> Now I've found when I do changes to a table schema the changes are not
> entirely at least reflected in a the same table linked in Access. I had once
> case where I changed a data type on one of the columns and that data type
> was not changed on the linked table in Access. I had to remove the link and
> then recreate it. The table type I'm using is MyISAM. From my experience
> with MyODBC it seems that it's not a live link correct? This problem has
> occurred on three machines including mine. Do I have something setup wrong
> then? Is there anything else that you need to know?
>
> Also if I may ask, is there any difference between MyODBC for Unix going to
> Windows to MyODBC for Windows going to Unix? I'm assuming that all the
> difference is the starting point but achieves the same tasks.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
