Hello, I am using "Execute INSERT INTO" queries using ODBC connections to grab data from 3 different Sybase servers. 2 of these servers are remote and use an ISDN on demand connection to connect. My queries work fine but my connections are not terminating. I "Close" the ADODB.Connection and set it to "Nothing". Only terminating Access will release the connection.
This is a problem because the connection being open keeps the ISDN modem tied up and when I go to retrieve data from the second remote location it fails because the ISDN modem is still connected to the first location.