PROBLEM: SQL query using ODBC and ASP

We are connecting through ASP to an FM DB over ODBC, no problem:

var oRS=Server.CreateObject(“ADODB.Recordset” ;

oRS.Open(“myFMDB.fp5, “DSN=myDSNname” ;

However, how can you do an SQL Query?

This wont work:

oRS.Open(“SELECT * FROM myFMDB.fp5”, “DSN=myDSNname” ;

Thanks in advance.

This problem is now solved. Thankyou.

What did you do to fix?

It seems that most of the regular users on this forum will bad mouth other programming languages and say that ODBC is slow, but no one will shed light on how to do it.

IMO, FileMaker messed up again by claiming to support ODBC, but it really doesn't not.

RE: ODBC is slow

In FileMaker yes, it is slow...

Do you have "Local Data Access Companion" and/or "Remote Data Access Companion" enabled in the FM Plug-Ins preference?

If not, this will prevent FM returning data to ODBC queries.

Garry