473,503 Members | 8,784 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Slow odbc connection to AIX DB2

Dear ALL,

I was trying to connect to a remote AIX DB2 database from a Windows
2000 machine in two ways:

1) Use DB2 client in Windows to connect to the cataloged DB

I typed "db2 connect to mydb user myuser using mypassword" in the DB2
command line. The connection is nearly instant.

2) Configured ODBC datasource in Windows

I configured an system ODBC datasource in Windows (Control Panel ->
Administrative Tools -> Data Sources (ODBC)) to point to the remote
database, using "IBM DB2 ODBC Driver". In my own client application, i
clicked connect (which then use this ODBC data source), it requires
more than 1 minute to make the connection. However, subsequent
select/query is nearly instant. It's just only the "connect" requires
significant time.

Any hints?

Thanks.

Nov 12 '05 #1
2 5139
The following link might be of some help.

http://publib.boulder.ibm.com/infoce...n/t0005582.htm

Nov 12 '05 #2
The following link might be of some help.

http://publib.boulder.ibm.com/infoce...n/t0005582.htm

Nov 12 '05 #3

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

Similar topics

5
2097
by: Stuart Mueller | last post by:
I have a mySQL database, called clients it has a single table called client with 2325 records in it. It was originally an Access database but I have exported it to mySQL. I have created a system...
1
455
by: Kevin Vogt | last post by:
When initially loaded, my web application (below) takes ~120000 milliseconds to open its connection. But repeated executions take 0 milliseconds each. But when I wait for approx. 5 minutes and try...
11
17524
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time...
6
8559
by: B B | last post by:
Okay, here is what's happening: I have a reasonably fast laptop (1.4 GHz Mobile M, so comparable to 2.5GHz P4) doing .net development. Running Windows XP pro, SP2 IIS is installed and running...
0
1298
by: richyy | last post by:
Hello together My ODBC-connection has slown down. Does anybody know, if systemvariables have affect to the speed of ODBC! After manipulating with systemvariables my programm slowed down at the...
21
4651
by: lesperancer | last post by:
I've got an access97 reporting mdb that pulls data (77,000 rows) from a sql server table into a local table to run reports if the local table is part of the reporting MDB, the insert statement...
11
16281
by: funky | last post by:
hello, I've got a big problem ad i'm not able to resolve it. We have a server running oracle 10g version 10.1.0. We usually use access as front end and connect database tables for data extraction....
13
3430
by: eighthman11 | last post by:
using Access 2003 and sql server version 8.0 Hey everyone. Created a text box where the user types in an Inventory number and it takes them to that inventory number on the contimuous form. The...
0
1190
by: roger1948 | last post by:
I have a MySQL database on a remote server. when i connect to it using Heidisql it open pretty instantly but.. using an ADO connection string server=xxx.xxx.218.237;db=xxxxx2;driver={MySQL...
0
7070
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7267
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7316
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6976
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7449
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...
0
3160
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3148
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1495
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
372
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.