I never tried but I would have thought you would type a normal table name in
your SELECT statement. It looks like your writing SQL statements meant for
MS SQL and not mysql.
----- Original Message -----
From: "Aaron Weiker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 5:54
Subject: Microsoft SQL Server linking to MySQL
> I'm trying to set up a link to MySQL through Microsoft SQL.
>
> I set up a ODBC DSN using MyODBC and I told Microsoft SQL to link through
an
> ODBC Datasource. Everything seems to work except I can't query anything.
>
> This is a statement I try.
>
> SELECT * FROM [MySQL].mysql.db
>
> This is the error message I get
>
> Invalid object name 'MySQL.mysql.db'.
>
>
> Has anyone done a similar thing and/or have ideas.
>
> Aaron Weiker
> Programmer
> CISP - Changing Internet Speed & Performance
>
> Phone: 419.724.5351 [EMAIL PROTECTED]
> Pager: 419.218.0013 http://www.cisp.cc
> Cell: 419.304.0323 web search:
> http://www.allthesites.com
>
---------------------------------------------------------------------
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
