cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
douglaschong
Level I

How to close database connection after running a New Sql Query?

Steps to reproduce:

 

Run any new sql query:

 

query << Run Foreground(
	OnRunComplete(
		Write( "Number of rows in query result: ", N Rows( queryResult ) )
	)
);

MyRunCompleteFunc = Function( {dt},
	{Default Local},
	Write( "Number of rows in query result: ", N Rows( dt ) )
);
query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );

Next, if you try to delete the database, it will say that jmp is still using the database.

 

Is there a way to close the database connection? The function Close Database Connection() does not seem to do the trick.

 

1 REPLY 1
Gerry_R
Level I

Re: How to close database connection after running a New Sql Query?

I have exactly this same question.  I have a database that does not deal well with non-terminated connections and can't always use Open Database Connection()/Close Database Connection with a DSN name..if I use an ODBC:driver string, I have to use New SQL Query, but I don't see a way to close it when finished.

Recommended Articles