Recent content by dnova

  1. D

    ODBC Queries VERY slow

    Hello, thanks for the reply! I run the query from SQL Explorer (the Progress one that is) and it can take as little as 30 second or as long as 10 minutes to run. I get the same speed from my code. Now there are about 100 people using the database. I am mainly working on two tables right...
  2. D

    ODBC Queries VERY slow

    Hello, I am working with Progress 9.1D and accessing from Merant 3.60 ODBC driver from C#, things go quite quickly most of the time, but I often find specific queries (both single table and 2 table join) can take horrifically long times to run. I decided to take out this post after waiting 20...
  3. D

    Which database name progress in ODBC DataSource

    Use a System DSN with the Merant PROGRESS ODBC Driver (this should be under your drivers list on the Progress Server). Then use it like any ODBC connection. MSDN has much information on ODBC and Data Access Application Blocks. The important thing for Progress is your Port Number, mine have...
  4. D

    Progress 9.1C ODBC from .NET

    .NET Progress Hi, Yes, I connect to progress 9.1D using DataDirect-Technologies 3.60 SQL92 driver from C#. It actually works quite well, most of the time. I am getting the same error right now on a system that has been running fine. Here are the most common causes I find (I am running this...
Top