Print Page | Close Window

Physical Databse not found

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18087
Printed Date: 31 Mar 2025 at 12:35am


Topic: Physical Databse not found
Posted By: bnd.chan
Subject: Physical Databse not found
Date Posted: 27 Nov 2012 at 5:25pm
Dear all
I am new bee here. My system is 32 bit windows 7, SQL Server 2003, Crystal reports 8.5, VB 6. all my applications run well. i recently upgraded to 64 bit windows 7 where i got errors. i still can connect to SQL server 2003. but when i try to access though crystal viewer error displays "Physical database not found error #2147192191". please suggests.. urgent. many thanks


Replies:
Posted By: hilfy
Date Posted: 28 Nov 2012 at 3:45am
Crystal will only work with 32-bit data sources.  So, even though you're using 64-bit Windows, you need to install the 32-bit database drivers for SQL Server.  Also, if you're using an ODBC connection, it needs to be set up using the 32-bit ODBC Administrator.  To get to this, run the following: 
 
C:\Windows\SysWOW64\odbcad32.exe
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: bnd.chan
Date Posted: 28 Nov 2012 at 4:08pm
Hi thank you Very much Dell. I tried to install 32 bit sql version.failed without a luck. it is not ODBC connection either. i use SQL connection string. i should say i can connect to sql server without a problem and all tables and stuff i can do with SQL 2005. all applications that run with crystal reports 8.5 gives me this error. any idea?

Posted By: hilfy
Date Posted: 29 Nov 2012 at 3:28am
Crystal 8.5 was never designed to run on a 64-bit operating system - it's over 12 years old.  If it will work at all, you have to have the 32-bit database driver.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: bnd.chan
Date Posted: 03 Dec 2012 at 7:48pm
Installed Crystal 64 bit version, SQL 2005 64 bit version. stil no luck, same error continues.

Posted By: hilfy
Date Posted: 04 Dec 2012 at 3:59am
There is no 64-bit version of Crystal 8.5!! Have you tried at all to set up the 32-bit data drivers?
-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: bnd.chan
Date Posted: 04 Dec 2012 at 8:51pm
I installed Crystal 2008 which is 64 bit version. sql 2005 which is also 64 bit. what else i should look?..do i need to manually set/register dll's on SYSWow64 directory?. if so what dll's i shoud look for?. stil no luck

Posted By: hilfy
Date Posted: 05 Dec 2012 at 3:13am
Crystal still needs a 32-bit data connection and, no, Crystal Designer is NOT 64-bit.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window