Hi,



I'm not sure if this is a known issue or not. I have not been able to find any existing similar postings so far.



I am running Firebird 1.5.0.4306 (Final Release - SuperServer). (Just upgraded from FB 1.0.0)

My application connects to an external table (.RAW file) in order to import some records.

If the import is run from a client (connecting over TCP/IP), then it works! (Even though I have not allowed this in the Firebird.conf file)

If I try to do the same from the server, then I get an error:



Access to external file "D:\xxxxx\xxxx\External File.raw" is denied by server administrator.



On one of the servers, if I change the connection to use TCP/IP, then the error goes away.

On another server, changing to TCP/IP has no effect. So far I have been unable to see what the difference is.

Both machines have 2 hard drives, with the external tables no the additional drives; one an E: drive, and the other a D:\ drive. (Both non c:\ )



Some questions:

If I were to connect to the external table using a read-only transaction, would I still be denied access?



I also have code that uses a TIBOutputDelimitedFile and a TIBInputDelimitedFile for export/import purposes.

So far, I have not experienced the same problem. I am wondering whether, instead of allowing access to external tables in Firebird.conf, I should rather just be changing the existing external table code to use these classes instead.

Although, these classes may also be using external tables, and are only working due to the possible bug mentioned above...



Regards

Maya



PS. The speed improvement from FB1.0 to FB1.5 is phenomenal!







[Non-text portions of this message have been removed]