FileMaker and ASP

[endofline]

I need for ASP pages to connect to FileMaker using ODBC. Here is the code I have:

Set fmConn = Server.CreateObject("ADODB.Connection")

Set fmRS = Server.CreateObject("ADODB.RecordSet")

fmConn.Open "Driver={FileMaker Pro}"

fmRS.Open "SELECT * FROM mainTableName", fmConn

Calling Open on fmConn does not cause an error but calling Open on fmRS does. Here is the error:

-2147467259, [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed

I have enabled LDAC, sharing, and created a group "ALL" under Access Privileges. I am also keeping the file open.

Just for testing, I have successfully linked the file into Access and I am able to see its table.

ANY help with this is most appreciated!

Jean Bresse