Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Physical Databse not found Post Reply Post New Topic
Author Message
bnd.chan
Newbie
Newbie
Avatar

Joined: 27 Nov 2012
Location: Sri Lanka
Online Status: Offline
Posts: 4
Quote bnd.chan Replybullet Topic: Physical Databse not found
    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


IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
bnd.chan
Newbie
Newbie
Avatar

Joined: 27 Nov 2012
Location: Sri Lanka
Online Status: Offline
Posts: 4
Quote bnd.chan Replybullet 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?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
bnd.chan
Newbie
Newbie
Avatar

Joined: 27 Nov 2012
Location: Sri Lanka
Online Status: Offline
Posts: 4
Quote bnd.chan Replybullet Posted: 03 Dec 2012 at 7:48pm
Installed Crystal 64 bit version, SQL 2005 64 bit version. stil no luck, same error continues.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
bnd.chan
Newbie
Newbie
Avatar

Joined: 27 Nov 2012
Location: Sri Lanka
Online Status: Offline
Posts: 4
Quote bnd.chan Replybullet 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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 05 Dec 2012 at 3:13am
Crystal still needs a 32-bit data connection and, no, Crystal Designer is NOT 64-bit.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.