Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Nov 29, 2011 11:18 PM

Currently Being Moderated

I'm creating a new report using Crystal 2011 connecting to a Progress 10.1.C DB through an ODBC Connection. When I connect to the db and select the tables I want on my report it's placing a 1 after the table name when creating a new report (v_table1). In crystal XI the 1 at the end of the table name meant it was an alias. This is a new report so there are no existing tables on the report. Is there a reason why it's doing this? I have tried renaming the table from v_table1 to v_table but I get the following error: "The alias requested "v_table", contains a combination of characters which is not considered to be valid." Does anyone know why this is or how I can fix/get around this?

Thanks!

Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Don Williams Nov 30, 2011 5:48 AM (in response to Kelly Pfliger)

Currently Being Moderated

Hello,

According to the Product [Platform guide|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/10df8fed-5cc6-2e10-93a8-99c15c6de338&overridelayout=true] CR only supports 10.1b.

Typically CR will Alias all table names as of CR 2008.

For more info see this [kbase: 1216864 - Support information for Progress Database Software|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_bi/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333233313336333833363334%7D.do]

Is there a reason why you don't want to use the Alias?

Don
Report Abuse

Like (0)
Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Nov 30, 2011 8:13 PM (in response to Kelly Pfliger)

Currently Being Moderated

I get the same problem/error when using Progress 10B.

The reason we don't want to use an alias is that it confuses our customers who work with our tables. There should be no reason that we have to use alias.

I also have a problem where I can't set the datasource location on an existing report that was created with Crystal XI, when I do I get a message saying "Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables." I then click ok and find the matching table in my new datascoure location and try to update the datasource location and nothing happens. it's not updating to use the new datasouce location so I'm unable to run the report using the new datasource location. Is there a fix for this?

I was hoping the problem would have been fixed with Crystal 2011, we didn't upgrade to Crystal 2008 because of this reason.
Report Abuse

Like (0)
Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Nov 30, 2011 8:59 PM (in response to Kelly Pfliger)

Currently Being Moderated

When I try clicking on your link of For more info see this kbase: 1216864 - Support information for Progress Database Software

I can't access that page.

403
The requested operation is forbidden for this resource. You do not have the permissions required to access this resource.
Report Abuse

Like (0)
- Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
  
  Don Williams Nov 30, 2011 9:41 PM (in response to Kelly Pfliger)
  
  Currently Being Moderated
  
  Go to this page: http://www.sdn.sap.com/irj/scn/advancedsearch?query=boj
  
  And search on the kbase number.
  
  Don
  
  Report Abuse
  
  Like (0)
Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Nov 30, 2011 10:45 PM (in response to Kelly Pfliger)

Currently Being Moderated

I have gone to the link you provided and searched on the Kbase number and I get zero results when doing so.
Report Abuse

Like (0)
- Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
  
  Don Williams Nov 30, 2011 11:07 PM (in response to Kelly Pfliger)
  
  Currently Being Moderated
  
  Hello,
  
  I know I've seen this before but I could not remember where or when... I did a search in our bug tracking system and I believe the reason why is two fold and I recall now the reasons...
  
  First it's due to the "_" in your table names, when CR comes across Shifted character CR aliases the table names for compatibility which is why it always appends the number 1 onto your table name, because CR replaces the Shifted character with an underscore which you are using it appends the 1. Work around is to not use any of the shifted ( top row of the keyboard ) in your table or field names.
  
  This is true for ALL DB sources.
  
  Second the track I found refers to 10.1.b is no longer supported so it was updated to include 10.1C, platforms has not got the update.
  
  ADAPT01515094 - Set Location Error caused by Aliases with Progress OpenEdge 10.1b ODBC Driver
  
  It was fixed in SP2 which you can get from here:
  
  https://www.sdn.sap.com/downloads/BusinessObjects/cr2011_sp2.exe
  
  Test again and see if that helps?
  
  Then update your post with the results and either mark as answered or well keep going depending on the results.
  
  Thanks again
  Don
  
  Report Abuse
  
  Like (0)
Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Dec 1, 2011 11:38 PM (in response to Kelly Pfliger)

Currently Being Moderated

I have downloaded and installed SP2, this did not fix the problem. I'm still getting the same error(s).
Report Abuse

Like (0)
Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Dec 6, 2011 7:55 PM (in response to Kelly Pfliger)

Currently Being Moderated

Is there anything else I can try to get this to work?

I can't remove the "_" from our table and field names as this is how our company has setup the tables and field names.
Report Abuse

Like (0)
- Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
  
  Don Williams Dec 6, 2011 11:24 PM (in response to Kelly Pfliger)
  
  Currently Being Moderated
  
  Hello,
  
  Sorry I should have read more details.
  
  There is a registry key you need to create We Introduced due to OpenEdge's ODBC API said it can't have same name for Alias with table name, but from testing, it can.
  
  [HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\ODBC]
  "UseTableNameAsAlias"="PGPRO1019.DLL, PGOE1022.DLL"
  
  If your client dll is other than listed above then simply use that name.
  
  Thanks again
  Don
  
  Report Abuse
  
  Like (0)
Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Dec 13, 2011 11:27 PM (in response to Kelly Pfliger)

Currently Being Moderated

I have created a registry key as suggested, this doesn't work either. I still get the same error/errors. Is there anything I need to try?
Report Abuse

Like (0)
- Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
  
  Don Williams Dec 14, 2011 10:35 PM (in response to Kelly Pfliger)
  
  Currently Being Moderated
  
  Hello,
  
  James tracked this and got it fixed. It should work, I've let James know it's not working for and he'll update the post shortly....
  
  Thanks
  Don
  
  Report Abuse
  
  Like (0)
Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Dec 20, 2011 3:14 PM (in response to Kelly Pfliger)

Currently Being Moderated

When can I expect a response on this? Thanks,
Report Abuse

Like (0)
- Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
  
  Don Williams Dec 20, 2011 8:42 PM (in response to Kelly Pfliger)
  
  Currently Being Moderated
  
  Hi,
  
  It may be tough now due to holidays and all...
  
  Can you download ProcessMonitor from Microsoft and run CR and filter on crw32.exe. Then look to see if that registry key is being looked for and read? May be the patch was not installed completely or something else was missed...
  
  If you need to you can always log a case, if you have a support contract or purchase a single case and Rep can work with you to debug the issue...
  
  Don
  
  Report Abuse
  
  Like (0)
Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection

Kelly Pfliger Mar 7, 2012 6:57 PM (in response to Kelly Pfliger)

Currently Being Moderated

Hi,

Back in December it was said that James had a fix for the problem of connecting to a Progress 10.1.C db using an ODBC Conncetion. Has that soultion been posted?

Per Don:

Hello,

James tracked this and got it fixed. It should work, I've let James know it's not working for and he'll update the post shortly....

Thanks
Don
Report Abuse

Like (0)
- Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
  
  James Anderson Mar 8, 2012 9:15 PM (in response to Kelly Pfliger)
  
  Currently Being Moderated
  
  Hi,
  
  apologies for the delay in my response.
  
  I worked with another Customer on this issue and they were successful in doing Set Location using CR2011 SP02 on a report created in CR XI with the steps documented in the knowledge base article "1618336 - Error setting location on a Crystal Reports XI report using the Progress OpenEdge ODBC Driver"
  
  The steps outlined in the knowledge base are:
  1) Upgrade CR2011 to Support Pack 02 which contains the modified crdb_odbc.dll
  2) Edit the registry on the CR2011 machine to add key HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\ODBC and under that key add string UseTableNameAsAlias and set it to PGPRO1019.DLL, PGOE1022.DLL
  3) Use CR2011 SP02 to Set Location on the CR XI report
  
  Please verify the ODBC driver dll in use by checking the Drivers tab of the ODBC Administrator as it may not be PGPRO1019.DLL or PGOE1022.DLL which will require a different value be placed in the UseTableNameAsAlias string in the registry.
  
  thanks
  
  James Anderson
  Support Architect
  AGS Primary Support
  Global Support Center Canada
  SAP Canada Inc.
  
  Edited by: James Anderson on Mar 8, 2012 12:15 PM
  
  Report Abuse
  
  Like (0)
  - Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
    
    Kelly Pfliger Mar 29, 2012 4:33 PM (in response to James Anderson)
    
    Currently Being Moderated
    
    I have gone though the steps listed above and I'm still not able to set the location on my crystal reports. I get the below errors when trying to do a set location. Is there anything else I can try? Thanks
    
    Report Abuse
    
    Like (0)
    - Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
      
      James Anderson Apr 17, 2012 11:41 PM (in response to Kelly Pfliger)
      
      Currently Being Moderated
      
      Hi Kelly,
      
      please confirm the following info:
      version of Crystal Reports from Help | About SAP Crystal Reports...
      version of CRDB_ODBC.DLL loaded from Help | About SAP Crystal Reports...> More Info...
      ODBC Driver DLL from ODBC Data Source Administrator | Drivers tab > File column
      Values in HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\ODBC for UseTableNameAsAlias
      thanks
      
      James
      
      Report Abuse
      
      Like (0)
      - Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
        
        Kelly Pfliger Apr 19, 2012 8:08 PM (in response to James Anderson)
        
        Currently Being Moderated
        
        Hi James,
        Here is the following info you have requested. Please let me know if you need anything else.
        Thanks,
        Kelly
        1. Version of Crystal 14.0.2.364 RTM
        2. Version of CRDB_odbc.Dll,
        3. ODBC Driver PGOE1023.dll
        4.
        
        Report Abuse
        
        Like (0)
        
        Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
        
        James Anderson Apr 20, 2012 5:59 PM (in response to Kelly Pfliger)
        
        Currently Being Moderated
        
        Hi Kelly,
        
        the config looks correct from the info you have provided. I have contacted IMS Development to look at this thread and see if they can see what I am missing.
        
        In the meantime there is one unlikely thing you can try. Try putting PGOE1023.DLL all in capitals in the registry. I don't think this will make a different and I want to be sure.
        
        thanks
        
        James
        
        Report Abuse
        
        Like (0)
        
        Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
        
        Tony Fang Apr 23, 2012 7:06 AM (in response to James Anderson)
        
        Currently Being Moderated
        
        Hi Kelly
        
        Are you using 64 bit OS? If yes, would you try using the following key:
        “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP
        BusinessObjects\Suite XI 4.0\Crystal Reports\Database\ODBC”
        "UseTableNameAsAlias"="PGPRO1022.DLL, PGOE1023.DLL"
        
        Thanks
        Tony
        
        Report Abuse
        
        Like (0)
        
        Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
        
        Kelly Pfliger Apr 23, 2012 6:04 PM (in response to Tony Fang)
        
        Currently Being Moderated
        
        Hi Tony,
        
        I have tried your suggestion and it works great!
        
        Thank you for your help!
        
        Kelly
        
        Report Abuse
        
        Like (0)
        
        Re: Problems when connecting to a Progress 10.1.C db using an ODBC Connection
        
        Don Williams Apr 23, 2012 11:23 PM (in response to Kelly Pfliger)
        
        Currently Being Moderated
        
        Thanks Kelly for verifying the solution.
        
        For all others James update our Kbase to reflect the above info:
        
        1618336 - Error setting location on a Crystal Reports XI report using the Progress OpenEdge ODBC Driver
        
        This true for XI and above.
        
        Thanks again
        Don
        
        Report Abuse
        
        Like (0)

Go to original post

Actions

Incoming Links

Re: Connectivity to Progress DB 10.2B???