470,602 Members | 1,538 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,602 developers. It's quick & easy.

Invalid query syntax with mySQL in database project


I'm using visual studio .NET 2003 enterprise and MySQL
5.0. I've created a database project in wich I like to
create scripts for stored procedures and queries.

I've created a connection using MyODBC 3.5.1 drivers and
microsoft OLE DB provider for ODBC drivers as well as an
OLE driver specificly for MySQL.

The connection is set up fine in both cases. I can run
view data, run scripts, etc. The only (big) problem is
that the query builder does not function properly.

The query builder created incorrect syntax for joins. For
instance, instead of using inner join is creates a where
case. Outer join's are places within '{}' braces. This
syntax is not accepted for mysql.

When using microsoft OLE DB provider for ODBC drivers to
connect to an Access database the syntax is fine.

I've (possibly) traced the problem to the (detected) type
of the connect, which in the case of Access states 'Access
Database', but in the case of mysql mearly
states 'Database'.

Has anyone used mysql and vs.net database project or does
anyone know how to affect the syntax created.

Much thanks,
Jul 21 '05 #1
0 1286

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Xenophobe | last post: by
5 posts views Thread by Roman Mashak | last post: by
9 posts views Thread by JT | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.