At 10:02 AM 8/06/2004 +0000, you wrote:

>First of all, thanks for the help sofar. I have solved the problem
>now. The tip about TCP naming conventions gave me an idea. Like I
>said, I also created an ODBC connection after having the IBPhoenix
>ODBC Driver installed on my station (for test purposes, both the db
>and the asp source are on my workstation). In the field where I
>specify the database, I replace the computer name by "localhost".
>That solved the problem. However, solving the problem without
>knowing why it is exactly solved isnt good enough.
>
>Has anyone got any idea of what went wrong and why this works????

Because the "Windows local" connection is not multi-user or
thread-safe. Ideally, you should just pretend it's not there and always
use localhost for connecting *any* local user from an application that you
write. It's a relic from InterBase and old Windows that is to be replaced
with a safer local connection method in Firebird 2.

The localhost server (IP address 127.0.0.1) is present on all
TCP/IP-enabled machines, even if there is no network card. The connection
is called "TCP/IP local loopback server" and the client's network layer
recognises it as a network connection.

It's OK to use Windows local for genuinely local tasks that you do as
sysadmin, with the command-line tools (isql, gstat, gbak, etc.)

/heLen