473,392 Members | 1,341 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,392 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 2608

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Graham | last post by:
I need a SQL Server or ODBC package for Python. Can anyone help please? Have search the Python packages under Database and there is no reference to either SQL Server or ODBC. Thanks Graham
1
by: puppet_sock | last post by:
Does the breaking of an ODBC connection produce a logoff event? I can't seem to get it to. What I was hoping was to use a trigger to do automatic cleanup of session specific data. But the...
2
by: Martijn Rutte | last post by:
Hi, On one side, I have a Sybase 12.5 32 bits Server running on AIX 5.1 (maintenance level 3). On the other, I've got W2000 5.00.2195 (SP2) with SQL Server Standard Edition, Product Version...
1
by: Ajay | last post by:
Hi all, I am using VC++ DOT NET. The database is Sybase. I have established connectivity through ODBC 12.5 Sybase ASE Driver( its not through DSN). There is problem while reteriving values of...
4
by: Andreas Lauffer | last post by:
Can anyone tell me advantages / disadvantages of DataDirect Server Wire ODBC-driver? Any experiences? What about redistribution? Andreas Lauffer, easySoft. GmbH, Germany
1
by: Paul | last post by:
Hello, I am converting an Access database on our network to a sql 2000 backend and keeping access as the front end. The access database has evolved and been a solution to collect data but now...
0
by: Zlatko Matić | last post by:
Hello. I created a login form that creates connection string (DSN-less) and starts procedure that connects to PostgreSQL server.I didn't know how to connect to server without performing anything...
8
by: Greg Strong | last post by:
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query...
1
by: JustMe | last post by:
Hi all, Although I've got quite a lot of experience with php and (M/My)SQL, I only used both within an online php script. These last few months I bought an option with my webhost to access...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.