Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently December 22nd, 2024, 1:50 pm

All times are UTC [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Closing an Access Database Connection
PostPosted: May 31st, 2005, 10:16 am 
Offline

Joined: November 16th, 2004, 9:40 pm
Posts: 19
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


For this message kenkofi has been thanked by : mackavi


Top
 Profile  
 
 Post subject:
PostPosted: June 2nd, 2005, 2:15 pm 
Offline

Joined: November 9th, 2004, 10:35 am
Posts: 49
Location: Canterbury UK
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

_________________
Andy
Hayward Design
E: andy@hayward-design.co.uk
T: 01227 721864

Opus Professional Version v6.00
Build Date Jun 18 2007 15:01:07
Windows XP Professional - Build 2600 Service Pack 2
Total Memory 1024 Mb
DirectX Version 9.0 or better
AMD Athlon


For this message Andy Piddock has been thanked by : mackavi


Top
 Profile Visit website  
 
 Post subject: Closing an Access Database Connection
PostPosted: June 4th, 2005, 12:43 pm 
Offline

Joined: November 16th, 2004, 9:40 pm
Posts: 19
Hi Andy

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


For this message kenkofi has been thanked by : mackavi


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 28 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group