filemaker

[nota141]

Does anyone out there know of the database software filemaker made by claris and is there a way to make a visual basic frontend.

[asabi]

I have the same question, I am trying to use ODBC with filemaker pro 5.5, I added the ODBC driver, and that part seems fine, but when I try to make the connection, I get an error message.

my code:

<%
dim Aryinfo
strConn = "Driver={FileMaker Pro};DBQ=" & Server.MapPath("fm5db.fp5") & ";"
set objConn = server.createObject("ADODB.CONNECTION")
set ObjRec = server.createObject("ADODB.RECORDSET")
objConn.open strConn
strSQL="select * from fm5db"
set objRec = objConn.execute(strSQL)
if not (objRec.eof) then
Aryinfo=objRec.getrows ()
for counter=0 to ubound (Aryinfo,2)
response.write (Aryinfo (0,counter) & Aryinfo (1,counter))
next
objrec.close
end if
set objrec=nothing
objConn.close
set objconn = nothing
%>

HELP