• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Help: SQL_MAX_QUALIFIER_LEN too small?

yong

New Member
#1
Hi, All,

I have set up a linked server from my SQL 2000 to Progress. However, when I tried

select * from ProgressServerName.ABCDEF.SchemaName.TableName

(ABCDEF is a 6 character catalog name)

I received this message:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: [MERANT][ODBC PROGRESS driver]The qualifier 'ABCDEF' was larger than SQL_MAX_QUALIFIER_LEN from SQLGetInfo (0).]

Any suggestions? Thanks.

Yong
 
#2
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.
 
#3
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