Public strsql As New ADODB.Recordset
strquery = "select fraction from stuinfo"
strsql.Open strquery, sqlconn, adOpenKeyset With MSChart1
.ShowLegend = True
Set .DataSource = strsql
End With
MSChart1.Title.Text = "学生成绩图表"
With MSChart1.Title.VtFont
.Name = "Algerian"
.Style = VtFontStyleBold
.Effect = VtFontEffectUnderline
.Size = 14
.VtColor.Set 255, 0, 255
End With
报错:odbc驱动程序不支持所需的属性
我用ado连接数据库
怎么解决
strquery = "select fraction from stuinfo"
strsql.Open strquery, sqlconn, adOpenKeyset With MSChart1
.ShowLegend = True
Set .DataSource = strsql
End With
MSChart1.Title.Text = "学生成绩图表"
With MSChart1.Title.VtFont
.Name = "Algerian"
.Style = VtFontStyleBold
.Effect = VtFontEffectUnderline
.Size = 14
.VtColor.Set 255, 0, 255
End With
报错:odbc驱动程序不支持所需的属性
我用ado连接数据库
怎么解决
把sqlconn写的详细些