MSPJGrid control

[Snake]

I am trying to make a connection to an access DB, I can fill the recordset but when i bind the recordset to the grid no rows are shown.

This is the javascript code I am using:

var cnn = new ActiveXObject("ADODB.Connection");
var rs = new ActiveXObject("ADODB.Recordset");

var strSQL = "SELECT Project, ProjectUniqueId FROM PROJECTS";
cnn.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\projects.mdb");
rs = cnn.Execute(strSQL);

MSPJGrid.Binding = rs;

MSPJGrid.FieldList = "Project<100>,ProjectUniqueID";
MSPJGrid.Outlining = false;
MSPJGrid.GanttView = false;
MSPJGrid.Refresh();

All the html code I use is from a sample on the microsoft site.
What am I doing wrong?

Best regards,

Lieven

 

[Mike Glen]

Hi Snake,

Try posting on the developer newsgroup, as this one is closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://www.mvps.org/project/.

Mike Glen
Project MVP

I am trying to make a connection to an access DB, I can fill the recordset

but when i bind the recordset to the grid no rows are shown.