By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

ODBC connection to Sybase DB not closing

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.