ado.net mysql query returns no rows unless qualifi

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

ado.net mysql query returns no rows unless qualifi

Author

Topic

davidhills2
Starting Member

1 Post

Posted - 2011-10-26 : 07:58:03

Good Morning

I have a odd one here.

A query that returns 4 rows normally, returns nothing when run thru SSIS unless the select statement is qualified with a limit.

select * from mytable returns no rows

but

select * from mytable limit 1000 returns 4 rows.

I am using standard mysql ado.net driver 5.1.3.0

a Data flow task using a data reader source

any ideas?

Thanks

David

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2011-11-06 : 15:48:10

what are you returning the result as

1. xml
2. recodset full
3. one single row?

try to avoid using select *

If you don't have the passion to help people, you have no passion

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources