Simple PostgreSQL CGI connection question
[1/2] from: ralph:abooks at: 24-Feb-2002 9:12
I'm playing with Rebol/Command scripts to access a PostgreSQL database and
run SQL queries using ODBC on Win 2000. The scripts work great from the
console but bomb out when run from the web via CGI, giving the following
error:
** Script Error: Feature not available in this REBOL ** Where: do-boot **
Near: db: open odbc://PostgreSQL books: first
Here's the script:
db: open odbc://PostgreSQL
books: first db
insert books "select title,author,isbn,price from books where topic like
'%Resnick%' order by title;"
a: copy books
print first a
close db
Do I need a newer version of Command (using 2.0) or am I doing something
wrong?
Thanks,
--Ralph Roberts
[2/2] from: petr::krenzelok::trz::cz at: 25-Feb-2002 14:12
Hi,
a typical path problem imo! Your license.key was not found! Try copying it to
the place where your script is placed. Take care though - a security issue
imo. I haven't tried to find out, how to adapt Rebol path environment
variables to look for license.key in the place of rebol executable ... Any
cute unixman to help here?
Cheers,
-pekr-
Ralph Roberts / ALEXANDER BOOKS wrote: