Re: [firebird-support] Firebird Connection String
Hello Lee, Sunday, July 23, 2017, 5:28:05 AM, you wrote: > Am working on an old VB6 project and need to connect to some Firebird Data. > Having problem Connecting to database when it's a network address. [..] That's because Firebird (by design) does not connect to databases on network drives. The database must be on a drive that is physically connected to the machine that is hosting the Firebird server. > If my data is on network share at \\MyNetShare\data\sprox.gdb then > what value do I use for dbServer and dbFileName? None. From a remote client, use the server's host name or internal IP address with the file path or (better) a database alias that you have created in aliases.conf (pre Fb3) or databases.conf (Fb3 onwards). Here's an example of an alias entry: sampledb = d:\data\sprox.gdb (no quotes) > Tried dbServer="" and dbName="\\MyNetShare\data\sprox.gdb" and it > works but only if running program As Admin (Win10) > Any suggestions??? On Windows, you can use either the Windows networking protocol (WNET) (noisy, outdated) \\hostname\d:\data\sprox.gdb \\hostname\sampledb or TCP/IP (preferred): hostname:d:\data\sprox.gdb hostname:sampledb There are optional elements for more complicated connections, too. You should find them in the Quick Start Guide, in the \doc\ folder of your server installation or in the Documentation library at the Fb we site. Note, there is a setting you can configure in firebird.conf to enable access to network drives but it should never be used to attempt access to a read/write database. It's a recipe for corruption. Kind regards, Helen Borrie
Re: [firebird-support] Firebird Connection String
22.07.2017 19:28, ajc4pyilyfqeryixt3gvm2tqmwze4i33cooea...@yahoo.com [firebird-support] wrote: > Any suggestions??? Read Firebird Quick Start Guide. Everything you do is completely wrong. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Firebird Connection String
Am working on an old VB6 project and need to connect to some Firebird Data. Having problem Connecting to database when it's a network address. Declaration is: Private Declare Function ConnectDatabase Lib "fbdll4vb20.dll" (ByVal servername As String, ByVal dbName As String, ByVal username As String, ByVal password As String) As Boolean Call for database on local machine works fine: (FileName = c:\data\sprox.gdb) Set rs = Myrs.rsOpen(StrSql, "Localhost", FileName, "SYSDBA", "masterkey") Public Function rsOpen(sql As String, dbServer As String, dbName As String, dbUser As String, dbPass As String) As ADOR.Recordset Dim rv As Boolean rv = ConnectDatabase(dbServer, dbName, dbUser, dbPass) . If my data is on network share at \\MyNetShare\data\sprox.gdb then what value do I use for dbServer and dbFileName? Tried dbServer="" and dbName="\\MyNetShare\data\sprox.gdb" and it works but only if running program As Admin (Win10) Any suggestions??? Lee