| Author |
Message |
bnd.chan
Newbie
Joined: 27 Nov 2012
Location: Sri Lanka
Online Status: Offline
Posts: 4
|
   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 Logged |
|
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
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 Logged |
|
bnd.chan
Newbie
Joined: 27 Nov 2012
Location: Sri Lanka
Online Status: Offline
Posts: 4
|
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 Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
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 Logged |
|
bnd.chan
Newbie
Joined: 27 Nov 2012
Location: Sri Lanka
Online Status: Offline
Posts: 4
|
Posted: 03 Dec 2012 at 7:48pm |
|
Installed Crystal 64 bit version, SQL 2005 64 bit version. stil no luck, same error continues.
|
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
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 Logged |
|
bnd.chan
Newbie
Joined: 27 Nov 2012
Location: Sri Lanka
Online Status: Offline
Posts: 4
|
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 Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
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 Logged |
|
|
|
