Hi Mike,

> Any help appreciated - thanks
>
> I'm attempting to create my first ever firebird (1.5.2.4731-0 ) database
> in SuSE 9.1 ...
>
> - in a directory which is in mode 777
> - I'm logged in as root
> - the directory owner and group is root
>
> and isql is reporting ...
>
> SQL> CREATE DATABASE '/root/samba_share/fbclimate/prd.fdb' user 'sysdba'
> password 'yg53dd&0';
> Statement failed, SQLCODE = -902
>
> I/O error for file "/root/samba_share/fbclimate/prd.fdb"
> -Error while trying to create file
> -Permission denied
> SQL>

Does the Firebird server process have access to that area?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com