Hi all,
I'm using PERL and a PERL module called DBI and a sub module called
DBD::ODBC
I'm using Windows 2000 Server, and FileMaker Pro 5 v3
Under the command prompt (logged in as myself) I can connect and pull
and print data out on the DOS shell. However, when I run the script
under the web it stalls. According to the error logs it looks like it
connects to
the FileMaker ODBC driver, but it fails when the "prepare"command is issued.
The SQL that the prepare functions is passing looks pretty standard.
$sth = $dbh->prepare("SELECT * FROM \"$table\"")
or die "Can not prepare SQL statement: \"$table\": $DBI::errstr\n";
I have the database opened, I made sure the file permissions are as loose as
can be(Access to all, a real free for all).
Questions:
Does this look like a FileMaker ODBC problem?
or
Does this look like a Windows 2000 problem where there are "Behind the
scenes" permissions
that I have to mess with? (As far as I can tell I have all the permissions
set, and FileMaker doesn't
require any username and pass)
How can I remedy this?
What does "SQL-S1000" refer to?
Thanks a bunch, be safe out there
-Matias
PS Below are my errors that I'm receiving
DBD::ODBC::db prepare failed: [FileMaker][ODBC FileMaker Pro
driver][FileMaker Pro]Connect failed (SQL-S1000)(DBD: st_prepare/SQLPrepare
err=-1) at C:\www.scfad.gps.caltech.edu\public_html\cgi-bin\search.pl line
20. Can not prepare SQL statement: "Fault County": [FileMaker][ODBC
FileMaker Pro driver][FileMaker Pro]Connect failed (SQL-S1000)(DBD:
st_prepare/SQLPrepare err=-1)
--------------------------------------------------------------------------
Matias Silva
Database Administrator
Earthquake Hazards Team
U.S Geological Survey - Pasadena Field Office
525 S. Wilson Ave.
Pasadena, CA
91106
Phone: 626 583-6798 Fax:626 583-7827
Pager: 714 324-1087 or 818-372-6460
Email: [EMAIL PROTECTED]
--------------------------------------------------------------------------
Warning: All federal email is permanently archived
