| Subject | Re: External table weirdness |
|---|---|
| Author | roar4711 |
| Post date | 2009-04-10T20:47:27Z |
--- In firebird-support@yahoogroups.com, "Anderson Farias" <peixedragao@...> wrote:
I've also made the tests on two occasions more since the last post, this time moving the whole thing out "program files" and into another disk, with the same result. Long file paths in the external table makes the insert operation fail, while a short path works.
>The application is running as administrator.
> Hi,
>
> >I can not find any other difference, tests are done one the same machine
> >(Windows 2008 x86),
> >same application binary, same data.
>
> AFAIK, Windows Server 2008 'protects' anything inside <program files> dir
> ... so -- I'm only guessing here -- but the problem may be access privileges
> when you move your app inside <program files>.
>
> Running the app "as administrator" may solve the problem. Another solution
> would be changing app folder privileges.
I've also made the tests on two occasions more since the last post, this time moving the whole thing out "program files" and into another disk, with the same result. Long file paths in the external table makes the insert operation fail, while a short path works.