My SQL and Crystal report# Database - 数据库
e*c
1 楼
Now I try to migrate my Visual Basic Application from MS SQL to My SQL, but i
met problem when i use crystalreport which connects My SQL . Below is my code:
CrystalReport1.Connect = "DSN=TestDB;uid=amy;pwd="
CrystalReport1.Destination = 0 ' 0-window 1-printer
CrystalReport1.ReportFileName = CrystalReportDir &
"\CrystalReport\Tracking\test.rpt"
sql = "select * from Score"
CrystalReport1.SQLQuery = sql
CrystalReport1.Action = 1
When this program execute the last line of code, following error
met problem when i use crystalreport which connects My SQL . Below is my code:
CrystalReport1.Connect = "DSN=TestDB;uid=amy;pwd="
CrystalReport1.Destination = 0 ' 0-window 1-printer
CrystalReport1.ReportFileName = CrystalReportDir &
"\CrystalReport\Tracking\test.rpt"
sql = "select * from Score"
CrystalReport1.SQLQuery = sql
CrystalReport1.Action = 1
When this program execute the last line of code, following error