Hi Larry,

> I am attempting to recreate our Firebird database in SQL Server
> including all data. I have contemplated using external tables to
> export from FB and then BULK INSERT into SQL Server. However, I get
> the following error:
>
> Cannot commit transaction:
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements.
> Access to external file "C:\EXT\TAX.SDF" is denied by server
> administrator.
>
> Everyone has rights to the C:\EXT\ directory and all files created
> within that folder. OS if WinXP Pro, Firebird 1.5.2. Any suggestions?

Access to external files are disabled per default in Firebird 1.5.x.
Check out the ExternalFileAccess parameter in firebird.conf.

> Anyone tried this? What are the limitations? Is this the fastest
> technique?

<shameless_plug>
Usually, converting a Firebird database to MSSQL (and vice versa) might
be some mouse-clicks in Database Workbench. http://www.upscene.com
</shameless_plug>

;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com