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
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