Digital Workshop

Hi

I have set up a connection to an Access database. However the database connection stays open until the Opus publication is closed.

I have tried a number of SQL commands including DISCONNECT, but none seem to work.

Is there a command for closing an open database connection, while the publication is still running.

Thanks

If you have a connection as follows:

var myDB = new Database(“DSN=catalogue.dsn;”)
var dbConn = myDB.Connect(“JSmith”, password)


Try using

dbConn.Close
Set dbConn = Nothing

Hi Andy

Thanks for the reply, I shall give it a try.