Subject | Re: Can't connect with my ODBC driver |
---|---|
Author | lysander_fb |
Post date | 2005-05-31T16:45:45Z |
--- In firebird-support@yahoogroups.com, "mona yazbeck"
<mona.yazbeck@h...> wrote:
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é
<mona.yazbeck@h...> wrote:
> Database: G:\Jurinet\FireBird\JURIMAITRE.FDB (Using BROWSE)Hello,
> 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.
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é