How to prevent the popup of alert window ("Microsoft SQL Server Login") when SQL connection failed

[#1]

Try(
	batch interactive(1);
	dbc = Create Database Connection("Driver={SQL Server};Server=xx.xxx.x.xx;Database=testDB;UID=test;PWD=test;");
	batch interactive(0);
);

If the SQL DB connection through JSL code fails (due to the network issue), the following window appears and exposing the server address to users.

 

 

I encrypt the JSL code before deploying it since I don't want the server address to be exposed to users. However, if I cannot hide that window, encrypting the code becomes pointless :(

[#2 · Accepted solution]

These dialogs are coming from the ODBC driver manager / SQL Server interaction, and are out of JMP's control.  You might try searching on SQL Server connection parameters to see if these can be suppressed.  There is one article that suggests adding the following to the SQL Server connection string, but this is typically more for password prompts than error messages.

ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'

Brian Corcoran

JMP Development