Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old April 11th, 2005, 07:23 AM
patdenim patdenim is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2005
Posts: 2 patdenim User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 55 m 24 sec
Reputation Power: 0
Run embedded Firbird from a CD

I have made a program in VB.NET connected to an embedded firebird database. Now I want the program to be able to run directly from a CD.
The problem is when i connect to the db running from a CD I get this error message:
"No permission for read-write access to database..."
I guess that because firebird want's to lock the database when viewing and that not possible on a CD.
So is there a way to open the db in read only mode or something so it will be possible to run directly from a cd.
Thanks!
/Patrik

Reply With Quote
  #2  
Old April 11th, 2005, 09:01 AM
fikret fikret is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Location: Sarajevo, Bosnia
Posts: 111 fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 5 h 17 m 43 sec
Reputation Power: 8
Quote:
Originally Posted by patdenim
I have made a program in VB.NET connected to an embedded firebird database. Now I want the program to be able to run directly from a CD.
The problem is when i connect to the db running from a CD I get this error message:
"No permission for read-write access to database..."
I guess that because firebird want's to lock the database when viewing and that not possible on a CD.
So is there a way to open the db in read only mode or something so it will be possible to run directly from a cd.
Thanks!
Patrik


Just restore your database as Read only using gbak before burning cd
Here is syntax for gbak:
http://www.volny.cz/iprenosil/inter...ak_switches.htm


--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
USAID TAMP Senior Programmer
* FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
http://jedivcs.sourceforge.net/
* Firebird and Fyracle news
http://www.fyracle.org/shownews.php

Reply With Quote
  #3  
Old April 11th, 2005, 10:19 AM
patdenim patdenim is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2005
Posts: 2 patdenim User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 55 m 24 sec
Reputation Power: 0
I've tried that but I cant get gbak to work. I only get error: unavailable database

i used this syntax:
gbak -mod read_only c:\temp\db.fdb c:\db.fdb

Reply With Quote
  #4  
Old April 12th, 2005, 03:38 AM
SilverDB's Avatar
SilverDB SilverDB is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Location: Romania
Posts: 173 SilverDB User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 45 m 53 sec
Reputation Power: 4
Send a message via Yahoo to SilverDB
Have you checked the file attributes for db.fdb (not read only) ?

Reply With Quote
  #5  
Old April 12th, 2005, 03:49 AM
fikret fikret is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Location: Sarajevo, Bosnia
Posts: 111 fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 5 h 17 m 43 sec
Reputation Power: 8
Quote:
Originally Posted by patdenim
I've tried that but I cant get gbak to work. I only get error: unavailable database

i used this syntax:
gbak -mod read_only c:\temp\db.fdb c:\db.fdb


No, you have to create backup first (if you don't have one).
And this is not correct syntax: you have specified 2 db's, it should be somethig like:
(if you have backup of your database in c:\temp)
gbak -mod read_only c:\temp\db.fbk c:\db.fdb. And don't forget to supply user name and password.

--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
USAID TAMP Senior Programmer
* FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
http://jedivcs.sourceforge.net/
* Firebird and Fyracle news
http://www.fyracle.org/shownews.php

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > Run embedded Firbird from a CD


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway