Search results

  1. T

    Select top with SQL-92 of Progress 9.1D

    Sorry for the lack of help, but I too have been unable to perform such actions on a Progress database. And I sure cannot use a cursor ;p
  2. T

    Linked Server

    lety3930: I believe he was refering to the user that is connecting to the database must have DBA privileges. On a similar note, I received the same error messages: Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server <<servername>>. In my case, I had...
  3. T

    Help: SQL_MAX_QUALIFIER_LEN too small?

    Just found the answer and decided to provide for future reference. If you were using: "ProgressServerName.ABCDEF.SchemaName.TableName" Use: "ProgressServerName..SchemaName.TableName" Example: sports2000..pub."customers" Progress does not support Catalog Name. See PSDN ID: P105730
  4. T

    Help: SQL_MAX_QUALIFIER_LEN too small?

    I know this is a very old thread, but I am having the same error returned. I'm using SQL Server 2005 and connecting to Progress 10.1A. Any help at all? Thanks.
  5. T

    Null???

    You are correct, ISNULL (To_Char (cc_ctg), 'NONE') is not being translated properly to Progress in the SQL engine. Try: COALESCE(To_Char (cc_ctg), 'NONE') Some programmers even prefer COALESCE to ISNULL I hope it helps.
Top