Board index » delphi » Dont't able to connect with example table employee.fdb (Firebird2.0)

2007-04-09 07:18:27 PM
delphi110
Hello!
I'm a complete newbie in SQL and client server issues.
Now I have downloaded and installed Firebird 2.0, running as an
service on Windows XP and want to see what's in the example table
employee.fdb.
I have established the connection via sysdba and ISQL comandline tool
with the following statement:
connect c:\programfiler\firebird\firebird_2_0\examples\empbuild
\employee.fdb user sysdba password masterkey;
It responds with
database: c:\programfiler\firebird\firebird_2_0\examples\empbuild
\employee.fdb,
user: sysdba
The problem is that when I try to read the table with:
select "*" from "c:\programfiler\firebird\firebird_2_0\examples
\empbuild\employee.fdb";
firebird responds with:
Statement failed, SQLCODE = -204
Dynamic SQL error
- Table unknown.
How can it be unknown when it is connected and I give it the full path
to the table?
Thanks in advance.
:)
Kai Inge
 

On Apr 9, 6:18 am, "KIB" <XXXX@XXXXX.COM>writes:
Try:
Select * From "c:\programfiler\firebird\firebird_2_0\examples\empbuild
\employee";
You sould not use the extension "fdb" when you use "selects".
Regards.
 

On 9 Apr, 17:03, XXXX@XXXXX.COM writes:
Tried your suggestion, but got exactly the same result.
I can,t see why it dont recognize the table, hope for more answers on
this.
:)
Kai Inge