Close ADO-connection

[Marc Vanzegbroeck]

Hi,

I allways use in the beginning of my program

Code: Select all  Expand view

oSQL:=CreateObject("ADODB.Connection")
oSQL:ConnectionString:=ADO_SQL_Connectionstring
oSQL:Open()
...
...
 

and at the end

Code: Select all  Expand view

oSQL:close()
oSQL:=nil
 

and that is working very nice.

In a particual program I want to delete the SQLite-database and do

Code: Select all  Expand view

oSQL:close()
oSQL:=nil
ferase('.\myfile.db')

but the ferase() this returns an error -1
This mean that the file is not closed

I now if a only return recordsets, I don't need to open the file like that, but I need to execute some SQL-commands (like creating tables, and other commands)
How can I close the connection completely with ADO?

Thanks

[Enrico Maria Giordano]

Marc,

Code: Select all  Expand view

oSQL:=nil
 

This is not needed.

How can I close the connection completely with ADO?

Code: Select all  Expand view

oSQL:close()

Should be enough. It might be a timing issue. Try to insert a delay between close() and ferase().

EMG

[Colin Haig]

Hi Marc

ferase requires the full path of the filename it may not be a sql issue.

Cheers

Colin

[nageswaragunupudi]

I too confirm the problem.
I could not find a solution yet.

[Marc Vanzegbroeck]

Hi Marc

ferase requires the full path of the filename it may not be a sql issue.

Cheers

Colin

Colin,

This is not the problem, because it's working if I don't open the file before.

[Marc Vanzegbroeck]

Should be enough. It might be a timing issue. Try to insert a delay between close() and ferase().

EMG

Enrico,

A delay between close() and ferase() don't work I even tested it with 10 seconds delay...

[Enrico Maria Giordano]

Marc,

Should be enough. It might be a timing issue. Try to insert a delay between close() and ferase().

EMG

Enrico,

A delay between close() and ferase() don't work I even tested it with 10 seconds delay...

What did you use for the delay?

EMG

[Marc Vanzegbroeck]

What did you use for the delay?

EMG

delay(100)

[Enrico Maria Giordano]

Marc,

What did you use for the delay?

EMG

delay(100)

Try with SysWait().

EMG

[nageswaragunupudi]

Thanks to EMG
SysWait(100) worked for me.

[Marc Vanzegbroeck]

Thanks to EMG
SysWait(100) worked for me.

Also for me

[Enrico Maria Giordano]

NageswaraRao and Marc,

Great!

EMG

[Antonio Linares]

very good!

[James Bott]

I wonder about other users having the database open thus preventing deletion. Is there a way to tell? Or, perhaps this is a temp file only created and used by one user?

[Marc Vanzegbroeck]

I wonder about other users having the database open thus preventing deletion. Is there a way to tell? Or, perhaps this is a temp file only created and used by one user?

I only use SQLite-database on stand-alone programs.
For network-versions I use MySQL. There I don't delete the database-file. Normaly I don't delete any database, but in this paricular program I want the user to be able to delete the SQLite-database, and create an other one...