mac / excel / odbc

I am having trouble getting the mysql mac ODBC connector to work in=20
excel for OS X. works fine under windows but mac excel doesnt list it=20
at all.

the connector is installed fine and i have set up the dsn and tested=20
the connection and thats ok its just that excel can seem to find it.

do i need a special connector for excel?

cheers

Dan
------------------------------------------------------------ -------------=
--------------

The contents of this e-mail (including any files transmitted with it) =
are confidential to the ordinary user of the e-mail address to which it =
was addressed and may also be privileged. It may be read, copied and =
used only by the intended recipient. =20
It is not to be relied upon by any person other than the addressee =
except with our prior written approval. If no such approval is given, =
we will not accept any liability (in negligence or otherwise) arising =
from any third party acting, or refraining from acting, on such =
information. =20
If you receive this message in error, please immediately delete it, =
destroy all copies of it and notify the sender. You must not use or =
disclose any part of this message if you are not the intended recipient. =
We may monitor all E-mail communication through our networks.
If you contact us by E-mail, we may store your name and address to =
facilitate communication.
Any views expressed in this message are those of the individual sender, =
except where the message states otherwise.
We take reasonable precautions to ensure our E-mails are virus free, =
however, we cannot accept responsibility for any virus transmitted by us =
and recommend that you subject any incoming E-mail to your own virus =
checking procedures.Thank you. =20
Conference Administration Services Ltd, Bridge House, 4 Borough High =
Street, London SE1 9QZ, United Kingdom. Tel: + 44 (0) 20 7403 1700 Fax: =
+ 44 (0) 20 7378 6691


--
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: mac / excel / odbc

On 18/3/05 11:27 am, Daniel Griffiths wrote:

> I am having trouble getting the mysql mac ODBC connector to work in
> excel for OS X. works fine under windows but mac excel doesnt list it
> at all.
>
> the connector is installed fine and i have set up the dsn and tested
> the connection and thats ok its just that excel can seem to find it.
>
> do i need a special connector for excel?

I haven't tried with Excel 2004, but Excel v.X required a CFM bridge,
because although the OS's ODBC driver is a Mach-O library, and the MyODBC
driver is a Mach-O library, Excel is not a Mach-O application. (Mach-O and
CFM are different kinds of executable format. CFM is deprecated by Apple.)

If you google a bit on the subject, you ought to find a good article at
www.macdevcenter.com about this, which should link to www.openlinksw.com who
have the CFM bridge.

> The contents of this e-mail (including any files transmitted with it) are
> confidential to the ordinary user of the e-mail address to which it was
> addressed and may also be privileged. It may be read, copied and used only by
> the intended recipient.
> It is not to be relied upon by any person other than the addressee except with
> our prior written approval. If no such approval is given, we will not accept
> any liability (in negligence or otherwise) arising from any third party
> acting, or refraining from acting, on such information.
> If you receive this message in error, please immediately delete it, destroy
> all copies of it and notify the sender. You must not use or disclose any part
> of this message if you are not the intended recipient. We may monitor all
> E-mail communication through our networks.
> If you contact us by E-mail, we may store your name and address to facilitate
> communication.
> Any views expressed in this message are those of the individual sender, except
> where the message states otherwise.
> We take reasonable precautions to ensure our E-mails are virus free, however,
> we cannot accept responsibility for any virus transmitted by us and recommend
> that you subject any incoming E-mail to your own virus checking
> procedures.Thank you.
> Conference Administration Services Ltd, Bridge House, 4 Borough High Street,
> London SE1 9QZ, United Kingdom. Tel: + 44 (0) 20 7403 1700 Fax: + 44 (0) 20
> 7378 6691

I'm sorry, but sending this amount of "disclaimer" on an email to a public
mailing list, is Just Not On. Please give your email admins a clue-by-four.

Cheers,

Chris



--
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