Crystal Reports MySQL RunTime Connection

[Atif]

Hi All

My problem is not related with this group BUT i have got a clue from
here that's why i am posting this question over here.

I am using Crystal Reports 9 with MySQL and SQL Server.
Situation: User can select anyone of these databases and the Report
should work fine[which is not the case]

I am using following connection strings to connect with databases

[SQL Server]
"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=PizzaHut;Data Source=(local)"

[MySQL]
"Provider=MSDASQL.1;Extended Properties=DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=DBName;UID=root; PWD=;OPTION=3"

These connection strings are working fine with my application but not
with Crystal Reports.

i have created the Report with SQL Server and it worked fine but when
i tried to connect with MySQL at runtime using the above connection
string, it gave me the "login failure" error while user ROOT have all
permisions, but when i used following connection string

Report.DiscardSavedData
Report.Databases.Tables(1).ConnectBufferString =
"Provider=MySQLProv;SERVER=localhost;DB=DBName;UID =root;PWD=;"

[Refrence: http://groups.google.com/groups?hl=e...Bruntime%2522]

it got connected but not showing any result i.e. a blank report.

WHY?
Thanks
Regards