Subject Re: Can't connect with my ODBC driver
Author lysander_fb
--- In firebird-support@yahoogroups.com, "mona yazbeck"
<mona.yazbeck@h...> wrote:

> Database: G:\Jurinet\FireBird\JURIMAITRE.FDB (Using BROWSE)
> Client:
> Database account: SYSDBA
> password: masterkey
> Role:
> Character Set: NONE
> Dialect 3
> Quoted identifier
>
> And "G:" is a network driver. Yes I am connecting to a remote server.
> FireBird is started on the server to.


Hello,
BROWSING is not such a good idea in this case. It will deliver the
wrong string.

try the following connection:
<servername>:<drive>:<path>\jurimaitre.fdb

where <servername> must be the name of the server in your network,
<drive> must be the drive-letter relative to the server, NOT the
client, <path> must be also relative to the server.

If your server would have a name of "DBServer" and it would on it's
own hard-disks have a partition "D:" where is located your database in
the folder "Jurinet\FireBird\Jurimaitre.fdb", your connection string
would be:
"DBServer:D:\Jurinet\FireBird\Jurimaitre.fdb"

also consider the following:
- use the aliases-conf of the server. That way you would just need
"DBServer:Jurimaitre"
- change the SYSDBA-password as soon as possible
- think long and deep about really using quoted identifiers. This can
mean a lot of extra-work

ciao,
André