Issue with tables which contain hyphens in name

Tom Loya

New Member
Pursuant following this KB:

http://knowledgebase.progress.com/articles/Article/P138294

I created a view in Progress. When I go to the Linked Server in SQL Server, I am unable to view the view that was just created. Is there something that I need to do to view the view, or are there some permissions that need set?

Background:
We have an old progress database which we want to access via our .NET app. We have the 10.2B drivers installed. SELECT statements always work. UPDATES will work if I am not using a table or a column with a hyphen in it's name, so I know my syntax is correct. The workaround that progress says to do is to create progress views and simply substitute the hyphens with underscores or get rid of them. We have done that. Now, we cannot see the views from within SQL Server. So, according to progress, we need to add a DefaultSchema=PUB to the registry (http://knowledgebase.progress.com/articles/Article/P2899);

Here is more information on my problem from a stackoverflow I created:
https://stackoverflow.com/questions...server-to-progress-database/28071599#28071599


Thanks,
Tom
 

RealHeavyDude

Well-Known Member
Any chance that you access the database via the OpenEdge AppServer .NET Open Client?

Heavy Regards, RealHeavyDude.
 
Top