Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 8 / 9 / 2013 / 2014 / 2015 (Premium Edition) » GM Crystal Reports 11 Runtime on Windows 64bit platforms
Post new topic  Reply to topic View previous topic :: View next topic 
GM Crystal Reports 11 Runtime on Windows 64bit platforms
PostPosted: Fri Aug 20, 2010 12:09 pm Points: 1 Reply with quote
cdohmen
Cuckoo for GoldMine Puffs
Joined: 06 Mar 2009
Posts: 255
Location: Pittsburgh, PA




FYI

If anyone intends to run Crystal Reports 11 templates within GMPE 9.0 on a Windows 64bit platform then make sure to use the 32bit version of the ODBC Administrator program (odbcad32.exe) located in the following directory on the server or client.

%systemdrive%\Windows\SysWOW64

Yes that's typed right.....

Be aware that the ODBC Administrator available under the Administrative Tools >> Data Sources (ODBC) is a 64bit version of the (odbcad32.exe) program and it creates 64 bit System DSN that is NOT compatible with GMPE 9.0. Believe it or not the 64bit odbcad32.exe is located in the following folder:

%systemdrive%\Windows\System32

Typical Microsoft .........32bit apps in a folder named SysWOW64 and a 64bit apps in a folder named System32 with both executables named exactly the same way.

CD
View user's profile Send private message

PostPosted: Sat Aug 21, 2010 8:16 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Thanks so very much for sharing.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Wed Oct 06, 2010 4:39 am Points: 0 Reply with quote
dgiles
n00b
Joined: 06 Oct 2010
Posts: 1
Location: Oklahoma City, OK




Is there some type of procedure that you have to perform to get Crystal Reports 11 to run with GMPE 9.0? I have both and just installed Crystal Reports last week and would like to start using them.

_________________
Don Giles
View user's profile Send private message

PostPosted: Tue Oct 12, 2010 12:09 pm Points: 0 Reply with quote
cdohmen
Cuckoo for GoldMine Puffs
Joined: 06 Mar 2009
Posts: 255
Location: Pittsburgh, PA




This is what works for me:

1. Don't bother installing Crystal Reports v11 Designer on the server. always design your reports from a workstation. I'm pretty sure that Crystall 11 will not install on windows Server 2003 anyway.

2. Install the FrontRange supplied Crystal 11 Runtime on every workation that will execute a Crystal report from within the GMPE 9.x interface.

3. Setup an ODBC connection aka System DSN on each workstation preferrably using the SQL Native client drivers (SQL Server driver may not retuirn all records). Use the Windows ODBC Administrator utility located in the Control Panel under Administrative Tools.

NOTE: 64-bit workstations should use the instructions listed in the first posting of this thread.

Other items to remember:

- FRS changed the Notes fields in several of the tables to Image Field Types.. Crystal can not process this data correctly without converting it to text. This can be done several ways.

a.) create Crystal SQL expressions
b.) create a SQL View

Either method would use a formula such as this in the Crystal SQL expression or in the MS SQL View itself:

cast(cast(cal.notes as varbinary(max))as varchar(max)) or

cast(cast(conthist.notes as varbinary(max))as varchar(max)) or

- Always apply the most recent Crystal reports service packs
View user's profile Send private message

PostPosted: Tue Jun 14, 2011 3:42 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




Thanks! This one helped me out with a client today!

Helps if I read my own forums, eh?

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Wed Jun 15, 2011 6:48 am Points: 0 Reply with quote
cdohmen
Cuckoo for GoldMine Puffs
Joined: 06 Mar 2009
Posts: 255
Location: Pittsburgh, PA




Doug

No problem. This is the place to come to get the best feedback from everyone. Thanks for establishing this in the first place.

CD
View user's profile Send private message

PostPosted: Wed Jun 15, 2011 9:12 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




CD - I appreciate your comments. They have been very helpful.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Mon Nov 28, 2011 10:52 am Points: 0 Reply with quote
cdohmen
Cuckoo for GoldMine Puffs
Joined: 06 Mar 2009
Posts: 255
Location: Pittsburgh, PA




FYI:

I noticed today that there is an icon labled ODBC (32-bit) in the Windows 7 SP1 Control Panel.

Although it's labeled 32-bit it actually is pointing to the 64-bit executable.

The only easy way to tell which ODBC Admin program is which is to make note of the drivers list. The 32-bit ODBC Admin program will list 15 - 20 drivers and the 64-bit ODBC Admin will list 2.
View user's profile Send private message

PostPosted: Wed Feb 22, 2012 4:13 pm Points: 0 Reply with quote
MS
n00b
Joined: 22 Feb 2012
Posts: 1




This KB article proved quite helpful in explaining what was going on and exactly what to do

http://support.microsoft.com/kb/942976

Thanks guys!
View user's profile Send private message

GM Crystal Reports 11 Runtime on Windows 64bit platforms
  ContactReview Forum Index » GoldMine 8 / 9 / 2013 / 2014 / 2015 (Premium Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin