>We have a system that sends a passthrough SQL statement (INSERT..)
>using SQLSTRINGCONNECT() function.
>If the SQL Server is down, the record is saved in a off line table
>in the local disk. When Server turn back, I sycronize the database.
>
>The problem is that I can't hide the messagebox from TCP/IP Sockets
>or Named Pipes.
>
>Using a connection in DBC I can hide the login prompt,
>but not the error message, even with ON ERROR.
>
>I want the SQLSTRINGCONNECT() returns just '-1' without displaying the messagebox.
>
>Thanks in advance,
>
>Paulo Barros

Hi there,

What is the messagebox? Is is a login prompt? An error message?

We had a similar problem with SQL Server 7 and it turned out it was because we had the ODBC driver set to use the SQL Server login admin, instead ot logging in with the NT authentication.