Subject | database access for embedded server |
---|---|
Author | ehaerim |
Post date | 2011-05-10T23:35:04Z |
From README_embedded.tx,
2.2. Database access
Client access can be only via the local protocol,
i.e. NOT a TCP/IP connection string that includes
the server name "localhost" or IP address 127.0.0.1.
The embedded server supports only the local connection
to a database file path without a server name.
The database file can be accessed by multiple client
programs. The database consistency in this case is
guaranteed internally (by the shared lock table).
The embedded server acts as a true local server for a single
client accessing databases on a local machine. It can also
act as a remote gateway that redirects all network calls to
other hosts, just as the regular client library does.
Will the following be not acceptable to the embedded server?
"CREATE DATABASE 'localhost:C:/test.fdb' USER 'SYSDBA' PASSWORD
'masterkey' PAGE_SIZE 8192 DEFAULT CHARACTER SET WIN1252"
Instead, should I use as shown below?
"CREATE DATABASE 'C:/test.fdb' USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192 DEFAULT CHARACTER SET WIN1252"
thx
HR
[Non-text portions of this message have been removed]
2.2. Database access
Client access can be only via the local protocol,
i.e. NOT a TCP/IP connection string that includes
the server name "localhost" or IP address 127.0.0.1.
The embedded server supports only the local connection
to a database file path without a server name.
The database file can be accessed by multiple client
programs. The database consistency in this case is
guaranteed internally (by the shared lock table).
The embedded server acts as a true local server for a single
client accessing databases on a local machine. It can also
act as a remote gateway that redirects all network calls to
other hosts, just as the regular client library does.
Will the following be not acceptable to the embedded server?
"CREATE DATABASE 'localhost:C:/test.fdb' USER 'SYSDBA' PASSWORD
'masterkey' PAGE_SIZE 8192 DEFAULT CHARACTER SET WIN1252"
Instead, should I use as shown below?
"CREATE DATABASE 'C:/test.fdb' USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192 DEFAULT CHARACTER SET WIN1252"
thx
HR
[Non-text portions of this message have been removed]