Use VB to generate recordset in Filemaker

[JimCooke]

We have an application that grabs records from Filemaker and creates an ADO recordset using VB and ODBC. The application has been working for about 3 years. We are using a Filemaker host.

We are just migrating to Filemaker 7.0, and when I attempt to open the filemaker database using VB I am getting the message telling me I should be using the hosted version of the database. I did create a dummy database with a script that will open the hosted version. Should I be able to run SQL statements against that open database to write to my SQL tables?

Jim