June 17, 200223 yr Newbies 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
Create an account or sign in to comment