On 16/5/03 12:43 pm, in article
b76de68d.0305160343.4b683560[at]posting.google.com, "Robert Staflin"
<robert.staflin[at]macademic.se> wrote:

I am in exactly the same state as Robert duplicated below. I see many
threads on the subject from 6 months ago. Is there no improvement in the
situation?

Similarly I installed MS Query on SR1 and also installed
CompleteMySQL-4.0.13.dmg from Server Logistics. Odbctest works and yet I get
"ODBC is not installed on this system."

Is Microsoft still not aware of what it is asking people to do.

> I've just installed MS Query for MS Office v. X SR1, and I can get to
> the menu object "Data|Get External Data|New Database Query...".
> However, I get the message "ODBC is not installed on this system.",
> which incidentally it is.
>
> I saw an earlier post about this and FileMaker Pro access, but no
> answer. Myself, I need to get data from a MySQL database through ODBC.
> For this, I have installed the MyODBC driver for MySQL, and have
> verified that it works.
>
> 1. Do I really need ODBC drivers for Excel too? I only want to get
> data into Excel, not out of it.
>
> 2. The erroneous message that ODBC is not installed - how do I get
> around that?
>
> 3. Is there a way to avoid using MS Query, getting data through VBA
> directly?
>
> Thanks for any input!
>
> /Robert Staflin

Hi

It might make a difference concerning the order of installation. Try running
the Office 1.2 update again then repair permissions.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------
In article <BB25F16E.1231D%nigel.king[at]orthogonsystems.com>, Nigel King
<nigel.king[at]orthogonsystems.com> wrote:


>
> On 16/5/03 12:43 pm, in article
> b76de68d.0305160343.4b683560[at]posting.google.com, "Robert Staflin"
> <robert.staflin[at]macademic.se> wrote:
>
> I am in exactly the same state as Robert duplicated below. I see many
> threads on the subject from 6 months ago. Is there no improvement in the
> situation?
>
> Similarly I installed MS Query on SR1 and also installed
> CompleteMySQL-4.0.13.dmg from Server Logistics. Odbctest works and yet I get
> "ODBC is not installed on this system."
>
> Is Microsoft still not aware of what it is asking people to do.
>
>> I've just installed MS Query for MS Office v. X SR1, and I can get to
>> the menu object "Data|Get External Data|New Database Query...".
>> However, I get the message "ODBC is not installed on this system.",
>> which incidentally it is.
>>
>> I saw an earlier post about this and FileMaker Pro access, but no
>> answer. Myself, I need to get data from a MySQL database through ODBC.
>> For this, I have installed the MyODBC driver for MySQL, and have
>> verified that it works.
>>
>> 1. Do I really need ODBC drivers for Excel too? I only want to get
>> data into Excel, not out of it.
>>
>> 2. The erroneous message that ODBC is not installed - how do I get
>> around that?
>>
>> 3. Is there a way to avoid using MS Query, getting data through VBA
>> directly?
>>
>> Thanks for any input!
>>
>> /Robert Staflin
>
>

"Nigel King" <nigel.king[at]orthogonsystems.com> wrote in message
news:BB25F16E.1231D%nigel.king[at]orthogonsystems.com...
> I am in exactly the same state as Robert duplicated below. I see many
> threads on the subject from 6 months ago. Is there no improvement in the
> situation?

Nigel,

If you can, please try with Openlink's free trial version of their MySQL
ODBC driver. It's available at http://www.openlinksw.com

It that works for you, we can probably narrow it down to an incompatibility
between Excel and MyODBC.

> It that works for you, we can probably narrow it down to an incompatibility
> between Excel and MyODBC.

I don't think it's an incompatibility between Excel and MySQL/MyODBC
because I just got it to work. I found this article helpful -
http://www.macdevcenter.com/pub/a/mac/2003/06/20/odbc.html

now here's my question ... now that I can get this working on one
machine, do I need to set-up MyODBC drivers, DSNs, etc. on every
client machine to get them to be able to use Microsoft query?