Home » Infrastructure » Windows » Problem with ODBC slow connect to Oracle 10G
Problem with ODBC slow connect to Oracle 10G [message #171628] Wed, 10 May 2006 12:58
cgoulet
Messages: 3
Registered: March 2006
Junior Member
Hi,

I have a SAS application which was connecting by ODBC to Oracle Database 8i. Since we upgraded to Oracle 10G, the connection time (even before doing any queries) is very, very long. I realize that since I upgraded to 10G, I got a lot more "objects" (synonyms, views, etc) appearing in my list. I have about 41000 objects "available" and I think the problem is linked to that change in the database. Is there a way to limit the number of objects returned by the ODBC driver? I tried different drivers (Oracle, Microsoft, DataDirect) and although some driver are faster than others, the time it takes is much too long.
Thanks.
Previous Topic: Sharepoint Server
Next Topic: oo4o Oracle session
Goto Forum:
  


Current Time: Thu Mar 28 15:00:17 CDT 2024