can create connector but can"t access most tables via Excel

can create connector but can"t access most tables via Excel

am 07.03.2008 15:01:19 von Kenn Murrah

------=_Part_20269_11600009.1204898479906
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I'm trying to use Excel to see mysql databases on my Linux server. I've
created an account in mysql, I've installed the odbc driver, I've created a
new datasource on my Windows box, and now I can access one of the tables in
my database, but on all the others, I get an error: "You have an error in
your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to sue near 'paymentech'.'contacts' LIMIT 0' at
line 1" .... but not the others ... what have I done wrong?

Here's how I created the user:

grant all privileges on *.* to 'webdb'@'localhost'
identified by '3402ccit';
grant all privileges on *.* to 'webdb'@'%'
identified by '3402ccit';

so if it works on one table, why doesn't it work on the other tables in the
same database? What have I done wrong?

Any and all advice greatly appreciated.

Thanks.

Kenn

------=_Part_20269_11600009.1204898479906--

Re: can create connector but can"t access most tables via Excel

am 09.03.2008 23:26:51 von Daniel Kasak

On Fri, 2008-03-07 at 08:01 -0600, Kenn Murrah wrote:

> I'm trying to use Excel to see mysql databases on my Linux server.

Hmmmmmm ... Excel isn't exactly the best tool for the job ( take our
current example ). Are you planning on using Excel to manipulate the
data, or are you just using 'whatever is available' to view data?

> I've created an account in mysql, I've installed the odbc driver, I've created a
> new datasource on my Windows box, and now I can access one of the tables in
> my database, but on all the others, I get an error: "You have an error in
> your SQL syntax. Check the manual that corresponds to your MySQL server
> version for the right syntax to sue near 'paymentech'.'contacts' LIMIT 0' at
> line 1" .... but not the others ... what have I done wrong?

You didn't really describe how you got to this point. Do you have the
entire SQL that Excel is sending? Are you using Excel's 'query builder'?

> so if it works on one table, why doesn't it work on the other tables in the
> same database? What have I done wrong?

It's not a permission problem. It's an SQL problem, as the error above
indicates.

Personally I avoid Excel like the plague. If you just want to see / edit
data, try MySQL's query browser & administrator products. What are you
trying to do with your data?

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