I am running 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.
CODE:
Dim netdbs As ADODB.Connection
Set netdbs = CurrentProject.AccessConnection
SQLTransD = "INSERT INTO TransDetail SELECT
transaction_detail.trans_no AS
TicketD FROM TRANSACTION_DETAIL IN '' [ODBC;DSN=OverDriveIN;];"
netdbs.Execute SQLTrans
netdbs.Close
Set netdbs = Nothing
Environment:
Client PC:
Access 2002
XP OS
Adaptive Server Anywhere 7.0 Driver installed
ODBC DSN(s) set and tested for all 3 servers
ServerPC:
Sybase SQL Anywhere Studio Adaptive Server Anywhere 7.0 running on
Win2000
Router/Modem: Netopia R3100-U