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=SQLOL EDB.1;Integrate d Security=SSPI;P ersist Security
Info=False;Init ial Catalog=PizzaHu t;Data Source=(local)"
[MySQL]
"Provider=MSDAS QL.1;Extended Properties=DRIV ER={MySQL ODBC 3.51
Driver};SERVER= localhost;DATAB ASE=DBName;UID= root;PWD=;OPTIO N=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.DiscardS avedData
Report.Database s.Tables(1).Con nectBufferStrin g =
"Provider=MySQL Prov;SERVER=loc alhost;DB=DBNam e;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