topic Re: How to check if "Create Database Connection" is successful? in Discussions

How to check if "Create Database Connection" is successful?

miguello — Wed, 04 Sep 2019 19:33:09 GMT

Many of my scripts connect to a DB as soon as they are started. DB is in intranet, so users need to:

1. Be connected to internal network OR have VPN on

2. Have ODBC source set up correctly

Sometimes they don't.

I want to warn users that the DB is not available instead of script erroring on them. What would be a correct way of checking if "Create Database Connection" was successful and returned a valid handle?

Thanks,

Re: How to check if "Create Database Connection" is successful?

miguello — Wed, 04 Sep 2019 19:53:00 GMT

Is Scriptable(dbc);

works just fine, anybody has a code snippet with modal window that would just close the whole AddIn in case it evaluates "0"?

Thanks,

Re: How to check if "Create Database Connection" is successful?

pmroz — Thu, 05 Sep 2019 15:40:38 GMT

You could try logic like this:

my_dbc = create database connection("foobar");

if (isempty(my_dbc) | is missing(my_dbc),
	_nw = new window("Create DBC: Empty Value", << modal,
		textbox("Error: The database connection is empty."),
		);
		throw("Empty database connection string");
);