MyODBC through Access front-end : no connexion anymore

Hi everyone,

I'm using MySQL 4.1.12 (with innodb) with MyODBC 3.51.11-2.
MS Acces is used as a front-end.
I just added some fields in the DB using phpmyadmin.
For an unknown reason I am not able to link the tables anymore through
"Access Linked Table Manager" : it's like the connexion hangs or
freeze completely. I must kill the application.
I cannot import tables anymore : nothing happens.
Using the same DSN I can run the application though. But no other user
can run it.
For the weirdest reason, only one other user can do both : link the
tables and run the application.
I had this kind of problem before MyODBC 3.51.11-2 was released : if
one user linked the tables, other users couldn't connect anymore. But
other users were able to link the tables on their side. Now the
problem is deeper because nobody except one user (with restricted
privileges) can do that. I need several user because of of DB
privileges.
I tried on older tables and on older versions of the front-end : the
problem is the same.
I even reinstalled MySQL.
I'm not sure I explained my problem very clearely, but it is so
difficult because so weird.
Does anyone have an idea of the problem and its solution ? I'd be glad
to give you more details if needed.
Thanks in advance.

C.N.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: MyODBC through Access front-end : no connexion anymore

christophe nauwelaers wrote:

>Hi everyone,
>
>I'm using MySQL 4.1.12 (with innodb) with MyODBC 3.51.11-2.
>MS Acces is used as a front-end.
>I just added some fields in the DB using phpmyadmin.
>For an unknown reason I am not able to link the tables anymore through
>"Access Linked Table Manager" : it's like the connexion hangs or
>freeze completely. I must kill the application.
>
>I cannot import tables anymore : nothing happens.
>

This sounds like the same issue as Enrico Nicolis had earlier ( see
previous post: Access crash ).
There is some discussion of it at http://bugs.mysql.com/bug.php?id=9932

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC through Access front-end : no connexion anymore

Hi,

Thanks, I'll check this discussion to see if something matches my problem.
I must say that I partly solved it : I copied the front-end on my
computer at home and tried to link the tables again (through a VPN
connection to access the DB - ok, it is not the easiest way ;-) ). And
it worked ! And it's ok for all users now.
I still don't know what happened.
One thing I noticed : when I tried previously to link the tables in MS
Access, I had only a DSN name but no database name to link to. I believe
that's the reason why Access crashes, although the setup of my DSN was ok.

Thanks again.

C.N.

Daniel Kasak a écrit :

> christophe nauwelaers wrote:
>
>> Hi everyone,
>>
>> I'm using MySQL 4.1.12 (with innodb) with MyODBC 3.51.11-2.
>> MS Acces is used as a front-end.
>> I just added some fields in the DB using phpmyadmin.
>> For an unknown reason I am not able to link the tables anymore through
>> "Access Linked Table Manager" : it's like the connexion hangs or
>> freeze completely. I must kill the application.
>>
>> I cannot import tables anymore : nothing happens.
>>
>
> This sounds like the same issue as Enrico Nicolis had earlier ( see
> previous post: Access crash ).
> There is some discussion of it at http://bugs.mysql.com/bug.php?id=9932
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org