|
-
Jul 18th, 2001, 06:51 PM
#1
Thread Starter
Hyperactive Member
filemaker and ASP
I am trying to connect to a filemaker 5.5 DB using ODBC.
It is a very simple database (id,name,phone) the name of the file is fm5db.fp5, it is in the same directory as the ASP page.
The ODBC driver is installed, and
I did share the DataBase with LDAC.
But I keep getting an error message ..
The error message is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed
/fm5/index.asp, line 17
(line 17 is: "set objRec = objConn.execute(strSQL)")
my code:
<%
dim Aryinfo
strConn = "Driver={FileMaker Pro};DBQ=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
%>
Please advice
Thanks
In the beginning the universe was created. This has made a lot of people very angry and is generally regarded as a bad idea.
- Douglas Adams
The Hitchhiker's Guide to the Galaxy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|