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...
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
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.