why I have to put limit in the query

I have MS  SQL 2008 and visual studio. I have MySQl query run in Visual studio by MySQl connector. For whatever reason, when I put "limit 2000000" in the MySQL query, it returns correct records. But, when I remove "limit 2000000" in the MySQL query, it returns null. I don't understand why. I want to remove "limit 2000000"

When I use MySQL editor from MySQL front to run the query without limit set, it returns the same records. I don't understand why in Visual Studio connecting to MySQL, I have to put a limit set in query???

Here is the query structure

select ...
from table
where...
limit 2000000
wasabi3689Asked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
I don't know about the limit problem.  All the MySQL connectors come from MySQL including the .NET which is on version 6.6.4 now.  You might try the newer version and see if it works better for you.  http://www.mysql.com/products/connector/
0
 
Dave BaldwinFixer of ProblemsCommented:
Many times the drivers enforce their own conditions.  Are you using the same driver for both Visual Studio and MySQL editor?
0
 
wasabi3689Author Commented:
I don't think the same driver. But I want to use VS driver. Is there any way I remove the limit set to be able to populate the data?

I am using following connector

MySql.Data.MySqlClient.MySqlConnection, MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
wasabi3689Author Commented:
I see all download for 32-bit OS. I have 64-bit OS. Where to find the download link?
0
 
Dave BaldwinFixer of ProblemsCommented:
If you click on the dropdown and select ".NET and Mono", it will show a 'Architecture Independent' download.
0
 
wasabi3689Author Commented:
After I downloaded ".NET and Mono", I don't see .exe. file? How do I configure it into VS ADO.net
0
 
Dave BaldwinFixer of ProblemsCommented:
I don't know.  That download does include a bunch of DLLs and a CHM Help File that contains information and programming instructions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.