how to drop database correctly with sdac ?

[[email protected]]

Hello,
with ADO I can do this:
.
//some work with database "test" connected here and then I can do this
adocon.Execute('use master');
adocon.Execute('drop database test');
//database test dropped correctly

with sdac:
//some work with database "test" here and then
sdaccon.ExecSQL('use master');
sdaccon.ExecSQL('drop database test');<--- exception here :"cannot drop database test because database in use..."
//of course database test is not connected with other connection.
// how to drop database with sdac here ?
- i tried disconnect and then connect before, but without succes:
- I tried set property sdaccon.multipleconnection to false, without success

I'm sorry for maybe stupid questions, just getting started with sdac,

thank you.

[[email protected]]

I found a problem, i apologize to sdac, problem causes ADO, if property adoconnection.keepconnection is set to true, then adoconnection holds database for many seconds after call adoconnection.close. the problem was due to testing ADO+SDAC within one program. So it It's my fault. sorry..

[Stellar]

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.