At 11:50 AM 02-10-01 +0000, Eddy POULLET wrote:

>Hi Hellen,
>
> > >*The file name specified may contains a server name.
> > >*some operations may not work correctly
>
>In fact, the error is a warning.
>
> > I don't use IB Console - but if it has separate fields for entering
>the server name and the path, then the path should be just the
>physical path as seen by the server. If you have Windows networking
>on your client machine, either delete it or push it down the protocol
>stack so that it is at the bottom. Delete the Novell protocol
>(IPX/SX) altogether if it is there.
>
>In IBConsole, there is only one field for the server name and the
>path. THere is an another field for the alias
>
> > This indicates that you (or the client program) are trying to do a
>query that isn't supported for the dialect or database version you
>are connecting to; or possibly that you have the wrong client
>program (gds32.dll) installed on the client, for the server version
>you have.
>
>I have changed the dialect at the connection but it doesn't change
>anything. And the version that I use is coming from the
>downloaded file "Firebird-1.0.0.338-Beta2-Win32-Setup.zip" (that
>contains server and client and IBConsole).
>I have also tried to connect with IBconsole on the server doing
>a remote connection. I have the same errors.

Try using a different tool for connecting. It is possibly IBConsole that is the cause of your problems. Two recommended free tools are IBQuery http://www.torry.net/apps/utilities/database/mitecibquery.zip

and IB_SQL http://www.ibobjects.com/ibo_IB_SQL.html

Both of these are very straightforward for connecting and you don't have to "register" databases in order for the tools to remember them.

Do you realise that the database (.gdb) file must be on the same physical machine as the server program? Also, a Win share or a mapped drive (even if it is located on the server machine) is NOT valid.

I was going to say "run the diagnostics program" (comdlg.exe) but I notice that it's not actually included in the FB 1.0.0 beta2 distribution. But at least try to ping the server by the name you have given it in your HOSTS file.

I suggest that, for your test, you take a look at connecting to one of the sample databases in the \samples directory of your Firebird root.

rgds,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________