471,092 Members | 1,009 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

ODBC connection to Sybase DB not closing

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
0 2496

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Graham | last post: by
1 post views Thread by puppet_sock | last post: by
1 post views Thread by Ajay | last post: by
4 posts views Thread by Andreas Lauffer | last post: by
reply views Thread by Zlatko Matić | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.