Instead of hand coding the connection and the recordset, use Dreamweaver to create them on your page so that the recordset will be a format recognized by Pro Maps.
to create the connection, go to Window -> Databases in the databases panel, click the plus button to create a new connection.
once a connection is made, go to the server behaviors panel and click the plus button and select recordset.