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

Firebird and Networkdrives under win32

Discuss Firebird and Networkdrives under win32 in the Firebird SQL Development forum on Dev Shed.
Firebird and Networkdrives under win32 Firebird SQL Development forum discussing administration, Firebird SQL syntax, or other Firebird SQL-related topics. Firebird is the evolution of Borland's Interbase product.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old February 16th, 2005, 02:14 AM
m.heinze m.heinze is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 3 m.heinze User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 3 m 12 sec
Reputation Power: 0
Firebird and Networkdrives under win32
Hello,

i'm trying to connect to a *.gdb/*.fdb on a network mapped drive, but i always get an -902 error.

the configuration:

Firebird 1.5.2 is running on server1
the *.gdb/*.fdb files are store on server2

firebird.conf

ExternalFileAccess = Full

alias.conf

DB = P:\db\test.gdb 'where <P> is a mapped drive

this doesnt work, but why??

any suggestions???

thx 4 any help
max
Reply With Quote
  #2  
Old February 16th, 2005, 02:55 AM
upscene upscene is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 223 upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 7 h 14 m 50 sec
Reputation Power: 8
Mapped drives won't work. Period. That is "as designed". Period.

--

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server
Upscene Productions
http://www.upscene.com
__________________
Martijn Tonies
Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
Upscene Productions
http://www.upscene.com
Reply With Quote
  #3  
Old February 16th, 2005, 03:29 AM
m.heinze m.heinze is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 3 m.heinze User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 3 m 12 sec
Reputation Power: 0
thx for reply

Quote:
Originally Posted by upscene
Mapped drives won't work. Period. That is "as designed". Period.


is there any way to connect to 'external' *.gdb files.

works the linux version with mounted ressources?? for example mount a windows share with samba under /firbird/extdb ??

regards max
Reply With Quote
  #4  
Old February 16th, 2005, 03:43 AM
upscene upscene is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 223 upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 7 h 14 m 50 sec
Reputation Power: 8
With Windows: no.

With Linux and symbolic links, it might work, I don't know. Give it a try.

The reason for this NOT to work, is network latency, no true control over the file etc etc... Seriously, if another Firebird server access the same file (that is, IF you can get it to work), you will experience instant database corruption.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server
Upscene Productions
http://www.upscene.com
Reply With Quote
  #5  
Old February 16th, 2005, 03:58 AM
m.heinze m.heinze is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 3 m.heinze User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 3 m 12 sec
Reputation Power: 0
Hmmm,

the reason is not to setup two firebird server. i hav a fileserver. this stores all kind and any data that where used on network.
so i't would be nice the *.gdb's to. however thx for the help. (a use at own risk option in firebird.conf would be nice )

thx max
Reply With Quote
  #6  
Old February 17th, 2005, 03:23 AM
upscene upscene is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 223 upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 7 h 14 m 50 sec
Reputation Power: 8
A file server <> database servers.

Clients DO NOT NEED direct access to the file.

Backup programs SHOULD NOT create backups of the "gdb" file, but only of backups of the gdb file, created via the Services API or the "gbak" command line tool.

All in all, there's no point in storing the database file on a file server.

Besides, it is much better to have a separate machine as your database server anyway :-)


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server
Upscene Productions
http://www.upscene.com
Reply With Quote
  #7  
Old February 17th, 2005, 04:10 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,907 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 9 h 21 m 6 sec
Reputation Power: 279
And let me add that a file server is not a storage solution, which is an appropriate storage for a database's datafiles, see this (vendor) link for some docs about that.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Firebird and Networkdrives under win32

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
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 5 hosted by Hostway. 
Stay green...Green IT