Terminate a connection

G

Gou

Hi,

To import a table from an SQL Server to an Access database
I use the "TransferDatabase" action. The import runs well
at the exception that there's a "sleeping" connection
remaining on the SQL server. Is there a way to terminate
this connection ?

I try to use a "Workspace" with an "OpenConnection" and
composing a "QueryDef" but then my problem is to copy the
selection of a QueryDef into an Access table without
having all the fields name from the SQL Server.

From an ODBC apprentice...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top