Thanks for you suggestions. I will try to put it as a procedure or as a varchar and see how I fare.
Thanks again. Ajay "MikeB" <[email protected]> Sent by: [email protected] 11/01/2009 12:44 PM Please respond to [email protected] To [email protected] (RBASE-L Mailing List) cc Subject [RBASE-L] - Re: Rbase with PHP Also, Ajay can put TEST.ASC in the DB as a VarChar and use the great RUN SELECT which will negate all those problems with disk files. ----- Original Message ----- From: "A. Razzak Memon" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Sunday, November 01, 2009 12:29 PM Subject: [RBASE-L] - Re: Rbase with PHP > At 11:51 AM 11/1/2009, [email protected] wrote: > >>I am a novice at PHP. Any Help is greatly appreciated. Here I go ! >> >>I am using PHP to insert a row in a Rbase Table which has an ON INSERT >>TRIGGER defined. >>The trigger in turn runs a externally saved command file named TEST.ASC. >>When I execute >>the PHP program it correctly inserts a row in the Rbase Table which fires >>the trigger >>but then I get the following error. (I am using Apache 2.2 as my web >>server) >> >>Warning: odbc_exec() >>[<http://localhost/BerjeTest/function.odbc-exec>function.odbc-exec]: SQL >>error: [RBTI][Oterro ODBC Driver] >>[BDWeb]-ERROR- Unable to open file: test.asc (2583), SQL state HY000 in >>SQLExecDirect in C:\Apache2.2\htdocs\BerjeTest\Insert.php on line 33 >> >>The database, the PHP program and the command file TEST.ASC are all in the >>same folder under >>htdocs folder. >> >>I am assuming it is a security issue that prevents TEST.ASC from being >>accessed but have no >>idea what I am missing. > > > Ajay, > > You will need to define the absolute path in your stored procedure to run > the > appropriate file (test.asc) in correct folder if the file is not in the > same > folder with the database. > > Currently, the stored procedure is looking for the test.asc in the folder > with > the database files. > > So, either you place the test.asc file in the same folder with the > database, > or define the absolute path in the Stored Procedure. > > Hope that helps! > > Very Best R:egards, > > Razzak. > > P Please consider the environment before printing this e-mail. Thank you.
