Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-24 : 08:43:49
|
| Efrain writes "Please help.Why I can't plot a Graph from a SQL recordset as I can do it with MSAccess?Here is the code:Dim conn As New ADODB.ConnectionDim rs As New ADODB.RecordsetDim sqlstr As Stringconn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DB-NAME;Data Source=SERVER-NAME"conn.Opensqlstr = "select * from TABLE-NAME where FIELD='VALUE'"rs.Open sqlstr, conn, adOpenKeyset, adLockOptimisticSet MSChart1.DataSource = rsIf copy and paste it and try it with MSACCESS (Connection and table) will work.SQL SERVER 2000 8.00.194VB 6MDAC 2.8or if you experience the same (no good), any suggestions will be appreciated!Thanks,Efrain." |
|
|
|
|
|
Charts