Mysql, crystal reports XI

zero_sequence

New member
Joined
Apr 7, 2010
Messages
1
Programming Experience
Beginner
Hi to all,

i am trying to set the logon data for crystal reports that i have created. in crystal report builder i manage to connect to mysql by the jdbc driver downloaded from the official site of mysql.
[link=http://www.eakes.org/80/connecting-to-mysql-with-crystal-reports-xi/][/link]

but i want to change the ip of the mysql database ex instead of 127.0.0.1 a want to connect to a remote pc where mysql is intalled...
i tried this but
VB.NET:
  Dim Logoninfo As New TableLogOnInfo()
        Logoninfo.ConnectionInfo.ServerName = "127.0.0.1"
        Logoninfo.ConnectionInfo.DatabaseName = "db"
        Logoninfo.ConnectionInfo.UserID = "root"
        Logoninfo.ConnectionInfo.Password = "test"

        cryRpt.Database.Tables().Item(0).ApplyLogOnInfo(Logoninfo)

        cryRpt.VerifyDatabase()
i always get logon failed although everything is correct(i use it with 127.0.0.1) moreover i want to use recordselectionformula but again no luck

PLZ HELP ME
 
Back
Top