0

When ever I try to create a database with SQI Tools for firebird I receive this error...

SQL> create database 'C:\Remake'
CON> user 'sysdba' password 'masterkey';
Statement failed, SQLSTATE = 08001
I/O error during "CreateFile (create)" operation for file "C:\REMAKE"
-Error while trying to create file
-Access is denied.
SQL>

I went to the C:\Program Files\Firebird\Firebird_3_0 directory in CMD by using the cd command and then typed isql. I have also tried this when running cmd as the Administrator. I have googled this issue many times and all I get back is responses for Linux to do with the terminal, can anyone help me with Windows?

I am a first time firebird user, can anyone help me with this?

1

By default you are not allowed - by Windows - to create files into the C:\ drive root, except when running as Administrator. Make sure you create a folder and create the database file there. Also note that it is customary (but not required) to give Firebird databases the extension .fdb.

Also make sure that C:\Remake does not already exist as a folder (directory), see also https://stackoverflow.com/questions/42280679/firebird-permission-denied

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.