I/o Error For File Error While Trying To Open File
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Why do I get this error? up vote 1 down vote favorite When ever I try to connect with Firebird SQL I get this error, firebird$ isql-fb 'db.FDB' -u SYSDBA -p
Search Username Password Remember Me? Register Lost Password? facebook google twitter rss Free Web Developer Tools Advanced Search Forum Databases Firebird SQL Development Two application instances - i/o file error on connection.open() Thread: Two application instances - i/o file error on connection.open() Share This Thread Tweet This + 1 this Post To Linkedin Subscribe to this Thread Subscribe to This Thread May 28th, 2010,04:16 AM #1 No Profile Picture inva2k http://dba.stackexchange.com/questions/64403/why-do-i-get-this-error View Profile View Forum Posts Registered User Devshed Newbie (0 - 499 posts) Join Date May 2010 Posts 3 Rep Power 0 Two application instances - i/o file error on connection.open() hey community, I'm struggeling with my Firebird database. We are using the embedded Firebird. Starting two instances of our application http://forums.devshed.com/firebird-sql-development/710482-application-instances-file-error-connection-post2483148.html results in an i/o error of the second instance when we attempt to open a connection from the second instance even if no connection is active from the first instance. Besides the thrown error message: "I/O error for file "C:\database.FDB" Error while trying to open file." I guess I can not open parallel connections to an embedded database?! Maybe I'm not freeing the database connection after using it? I use the following code to connect to the database FbTransaction usedTransaction = null; FbConnection connection = null; // create connection using the connection string defined in the constructor using (connection = new FbConnection(sConnectionString)) { try { connection.Open(); // start a transaction usedTransaction = connection.BeginTransaction(); // do some work .... connection.close(); } catch(){} } Will I have to call the connection's Dispose method manually? I Guess this is done leaving the using() clause. Faq Reply With Quote June 14th, 2010,06:24 AM #2 No Profile Picture inva2k View Profile View F
Good Day All I am accessing an FDB Database with a WCF service. locally it was working fine, but now i want to access the service that https://www.daniweb.com/programming/software-development/threads/367744/i-o-error-during-createfile-open-operation-for-file is stting on a remote location. my Connection string looks like this http://askubuntu.com/questions/360000/create-firebird-database-in-specific-directory
communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Create firebird database in specific directory up vote 2 down vote favorite I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group called 'tracker' and I added my user and the firebird user to that group. firebird@ubuntu:/$ groups firebird firebird tracker I created a main directory called 'tracker' drwxrwx--- 3 me tracker 4096 Oct 16 10:40 tracker Inside the 'tracker' directory I created an 'fdb' directory where I want the firebird DB's to be created. drwxrwx--- 2 firebird firebird 4096 Oct 16 11:35 fdb Now when I try to create the database using the following command: CREATE DATABASE 'localhost:/tracker/fdb/test.fdb' page_size 8192 user 'SYSDBA' password 'foobar' DEFAULT CHARACTER SET UTF8; I get the following error: Statement failed, SQLSTATE = 08001 I/O error during "open O_CREAT" operation for file "/tracker/fdb/test.fdb" -Error while trying to create file -Permission denied If a change the 'tracker' directory to belong to the 'firebird' group then it creates the database, which makes sense, but since the firebird user belongs to the 'tracker' group, it shouldn't have any permission problems. What am I missing here?? I'm using firebird 2.5. Thanks 12.04 permissions mysql database share|improve this question asked Oct 16 '13 at 19:59 jramirez 11114 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote You can try first with firebird user if you can create a file in that directory sudo