Author |
Message |
Anna #1 / 19
|
 Physical Database not found
I am using VB6 SQl and CR 8.5. I have created package through PDW from VB. Everything runs fine on developer machine. At clients machine when i need to run reports i get Physical Database not found . Any suggestion . Thanks in Advance.
|
Sat, 12 Feb 2005 03:39:41 GMT |
|
 |
David Pop #2 / 19
|
 Physical Database not found
There are quite a few runtime files that need to be distributed with your setup. Go into the runtime help file and make sure you are distributing the correct files. Dave
Quote: > I am using VB6 SQl and CR 8.5. I have created package > through PDW from VB. Everything runs fine on developer > machine. At clients machine when i need to run reports i > get Physical Database not found . Any suggestion . > Thanks in Advance.
|
Sat, 12 Feb 2005 06:48:28 GMT |
|
 |
Anna #3 / 19
|
 Physical Database not found
Runtime files in Crystal ? Where can i find that file ? Quote: >-----Original Message----- >There are quite a few runtime files that need to be
distributed with your Quote: >setup. Go into the runtime help file and make sure you
are distributing the Quote: >correct files. >Dave
>> I am using VB6 SQl and CR 8.5. I have created package >> through PDW from VB. Everything runs fine on developer >> machine. At clients machine when i need to run reports i >> get Physical Database not found . Any suggestion . >> Thanks in Advance. >.
|
Sat, 12 Feb 2005 20:20:20 GMT |
|
 |
sjp #4 / 19
|
 Physical Database not found
Anna, How are connecting to SQL in VB6(odbc or oledb)?
Quote: > Runtime files in Crystal ? Where can i find that file ? > >-----Original Message----- > >There are quite a few runtime files that need to be > distributed with your > >setup. Go into the runtime help file and make sure you > are distributing the > >correct files. > >Dave
> >> I am using VB6 SQl and CR 8.5. I have created package > >> through PDW from VB. Everything runs fine on developer > >> machine. At clients machine when i need to run reports i > >> get Physical Database not found . Any suggestion . > >> Thanks in Advance. > >.
|
Sat, 12 Feb 2005 20:45:57 GMT |
|
 |
anna #5 / 19
|
 Physical Database not found
Through ODBC Quote: >-----Original Message----- >Anna, >How are connecting to SQL in VB6(odbc or oledb)?
>> Runtime files in Crystal ? Where can i find that file ? >> >-----Original Message----- >> >There are quite a few runtime files that need to be >> distributed with your >> >setup. Go into the runtime help file and make sure you >> are distributing the >> >correct files. >> >Dave
>> >> I am using VB6 SQl and CR 8.5. I have created package >> >> through PDW from VB. Everything runs fine on developer >> >> machine. At clients machine when i need to run reports i >> >> get Physical Database not found . Any suggestion . >> >> Thanks in Advance. >> >. >.
|
Sat, 12 Feb 2005 21:17:38 GMT |
|
 |
Rikesh Pate #6 / 19
|
 Physical Database not found
have you included the DLL PS2ODBC?
Quote: > Through ODBC > >-----Original Message----- > >Anna, > >How are connecting to SQL in VB6(odbc or oledb)?
> >> Runtime files in Crystal ? Where can i find that file ? > >> >-----Original Message----- > >> >There are quite a few runtime files that need to be > >> distributed with your > >> >setup. Go into the runtime help file and make sure you > >> are distributing the > >> >correct files. > >> >Dave
> >> >> I am using VB6 SQl and CR 8.5. I have created package > >> >> through PDW from VB. Everything runs fine on > developer > >> >> machine. At clients machine when i need to run > reports i > >> >> get Physical Database not found . Any suggestion . > >> >> Thanks in Advance. > >> >. > >.
|
Sat, 12 Feb 2005 21:34:26 GMT |
|
 |
sjp #7 / 19
|
 Physical Database not found
Anna, Check if you have set up ODBC exactly like your development machine.
Quote: > have you included the DLL PS2ODBC?
> > Through ODBC > > >-----Original Message----- > > >Anna, > > >How are connecting to SQL in VB6(odbc or oledb)?
> > >> Runtime files in Crystal ? Where can i find that file ? > > >> >-----Original Message----- > > >> >There are quite a few runtime files that need to be > > >> distributed with your > > >> >setup. Go into the runtime help file and make sure you > > >> are distributing the > > >> >correct files. > > >> >Dave
> > >> >> I am using VB6 SQl and CR 8.5. I have created package > > >> >> through PDW from VB. Everything runs fine on > > developer > > >> >> machine. At clients machine when i need to run > > reports i > > >> >> get Physical Database not found . Any suggestion . > > >> >> Thanks in Advance. > > >> >. > > >.
|
Sat, 12 Feb 2005 21:34:59 GMT |
|
 |
Anna #8 / 19
|
 Physical Database not found
I check my ODBC Setup , everything is same. I have p2smon.dll in my package . I dont have ps2ODBC . Quote: >-----Original Message----- >have you included the DLL PS2ODBC?
>> Through ODBC >> >-----Original Message----- >> >Anna, >> >How are connecting to SQL in VB6(odbc or oledb)?
>> >> Runtime files in Crystal ? Where can i find that file ? >> >> >-----Original Message----- >> >> >There are quite a few runtime files that need to be >> >> distributed with your >> >> >setup. Go into the runtime help file and make sure you >> >> are distributing the >> >> >correct files. >> >> >Dave
>> >> >> I am using VB6 SQl and CR 8.5. I have created package >> >> >> through PDW from VB. Everything runs fine on >> developer >> >> >> machine. At clients machine when i need to run >> reports i >> >> >> get Physical Database not found . Any suggestion . >> >> >> Thanks in Advance. >> >> >. >> >. >.
|
Sat, 12 Feb 2005 21:44:53 GMT |
|
 |
anna #9 / 19
|
 Physical Database not found
Thanks , I will after adding this DLL . Quote: >-----Original Message----- >Please find attached the Crystal ODBC driver!
>> I check my ODBC Setup , everything is same. I have >> p2smon.dll in my package . I dont have ps2ODBC . >> >-----Original Message----- >> >have you included the DLL PS2ODBC?
>> >> Through ODBC >> >> >-----Original Message----- >> >> >Anna, >> >> >How are connecting to SQL in VB6(odbc or oledb)?
>> >> >> Runtime files in Crystal ? Where can i find that >> file ? >> >> >> >-----Original Message----- >> >> >> >There are quite a few runtime files that need to be >> >> >> distributed with your >> >> >> >setup. Go into the runtime help file and make sure >> you >> >> >> are distributing the >> >> >> >correct files. >> >> >> >Dave
Quote: >> >> >> >> I am using VB6 SQl and CR 8.5. I have created >> package >> >> >> >> through PDW from VB. Everything runs fine on >> >> developer >> >> >> >> machine. At clients machine when i need to run >> >> reports i >> >> >> >> get Physical Database not found . Any suggestion . >> >> >> >> Thanks in Advance. >> >> >> >. >> >> >. >> >.
|
Sat, 12 Feb 2005 23:05:15 GMT |
|
 |
Neil Hoskin #10 / 19
|
 Physical Database not found
Anna, We have a folder with all the required Crystal files, it's a 6Mb ZIP file, let me know if you want it. We use it all the time to ensure all Crystal files are bang up to date using the latest updates on Seagate's web site (cr85main, cr85dev, cr85olap, dbexdrvr, actxview etc). NEIL.
Quote: > I am using VB6 SQl and CR 8.5. I have created package > through PDW from VB. Everything runs fine on developer > machine. At clients machine when i need to run reports i > get Physical Database not found . Any suggestion . > Thanks in Advance.
|
Sun, 13 Feb 2005 00:02:10 GMT |
|
 |
anna #11 / 19
|
 Physical Database not found
Do i have to buy ? I tried adding ps2odbc.dll but still its not working :( I really need this thing to start working Quote: >-----Original Message----- >Anna, >We have a folder with all the required Crystal files,
it's a 6Mb ZIP file, Quote: >let me know if you want it. We use it all the time to ensure all Crystal >files are bang up to date using the latest updates on Seagate's web site >(cr85main, cr85dev, cr85olap, dbexdrvr, actxview etc). >NEIL.
>> I am using VB6 SQl and CR 8.5. I have created package >> through PDW from VB. Everything runs fine on developer >> machine. At clients machine when i need to run reports i >> get Physical Database not found . Any suggestion . >> Thanks in Advance. >.
|
Sun, 13 Feb 2005 02:11:51 GMT |
|
 |
Rikesh Pate #12 / 19
|
 Physical Database not found
Just put all the P2*.dll's on your client machine and see what happens.
Quote: > Do i have to buy ? I tried adding ps2odbc.dll but still > its not working :( I really need this thing to start > working > >-----Original Message----- > >Anna, > >We have a folder with all the required Crystal files, > it's a 6Mb ZIP file, > >let me know if you want it. We use it all the time to > ensure all Crystal > >files are bang up to date using the latest updates on > Seagate's web site > >(cr85main, cr85dev, cr85olap, dbexdrvr, actxview etc). > >NEIL.
> >> I am using VB6 SQl and CR 8.5. I have created package > >> through PDW from VB. Everything runs fine on developer > >> machine. At clients machine when i need to run reports i > >> get Physical Database not found . Any suggestion . > >> Thanks in Advance. > >.
|
Sun, 13 Feb 2005 15:25:44 GMT |
|
 |
Al Emer #13 / 19
|
 Physical Database not found
PMFJI, but I'm having the same problem. Using VB5 SP3 and Crystal Reports 8.0. Connecting to an Access 7 database using OLEDB. The VB
display the report using the CRViewer. <<There are quite a few runtime files that need to be distributed with your setup. Go into the runtime help file and make sure you are distributing the correct files.>> BTDT. Here are the files that I've copied to the Windows System folder on the client machine. All DLLs were registered manually with REGSVR32.EXE. craxdrt.dll Crpaig80.dll crviewer.dll mfc42.dll msvcrt.dll p2bdao.dll p2bxbse.dll p2ctdao.dll p2irdao.dll p2ixbse.dll P2ldb2.dll p2lodbc.dll p2sdb2.dll p2sfs.dll P2smon.dll p2sodbc.dll p2soledb.dll sscsdk80.dll In addition, MDAC 2.5 SP2 was installed on the client machine. Any clues? TIA, Al Quote:
> There are quite a few runtime files that need to be distributed with your > setup. Go into the runtime help file and make sure you are distributing the > correct files. > Dave
> > I am using VB6 SQl and CR 8.5. I have created package > > through PDW from VB. Everything runs fine on developer > > machine. At clients machine when i need to run reports i > > get Physical Database not found . Any suggestion . > > Thanks in Advance.
|
Wed, 02 Mar 2005 01:12:00 GMT |
|
 |
CW #14 / 19
|
 Physical Database not found
(1) It's better you use PDW or MSI to distribute runtime files. You could easily miss things doing things by hand. (2) I take that your application works on your development box, but not on client box. (3) Can the client access the ACCESS file, with the same path? If not, then you need to change Access file location, as well as AddOLEDBSource method.
Quote: > PMFJI, but I'm having the same problem. Using VB5 SP3 and Crystal > Reports 8.0. Connecting to an Access 7 database using OLEDB. The VB
> display the report using the CRViewer. > <<There are quite a few runtime files that need to be distributed with > your setup. Go into the runtime help file and make sure you are > distributing the correct files.>> > BTDT. Here are the files that I've copied to the Windows System folder > on the client machine. All DLLs were registered manually with > REGSVR32.EXE. > craxdrt.dll > Crpaig80.dll > crviewer.dll > mfc42.dll > msvcrt.dll > p2bdao.dll > p2bxbse.dll > p2ctdao.dll > p2irdao.dll > p2ixbse.dll > P2ldb2.dll > p2lodbc.dll > p2sdb2.dll > p2sfs.dll > P2smon.dll > p2sodbc.dll > p2soledb.dll > sscsdk80.dll > In addition, MDAC 2.5 SP2 was installed on the client machine. > Any clues? > TIA, > Al
> > There are quite a few runtime files that need to be distributed with your > > setup. Go into the runtime help file and make sure you are distributing the > > correct files. > > Dave
> > > I am using VB6 SQl and CR 8.5. I have created package > > > through PDW from VB. Everything runs fine on developer > > > machine. At clients machine when i need to run reports i > > > get Physical Database not found . Any suggestion . > > > Thanks in Advance.
|
Wed, 02 Mar 2005 08:01:40 GMT |
|
 |
Al Emer #15 / 19
|
 Physical Database not found
Thanks for the reply, CW. 1) It's better you use PDW or MSI to distribute runtime files. You could easily miss things doing things by hand. What are PDW and MSI? I'm guessing that they're install programs. I used the VB5 Application Setup Wizard to distribute the app., put it didn't pick up a lot of the files that the app. needs. (2) I take that your application works on your development box, but not on client box. The app. works fine on the client box, it's just the reports that are giving me problems. (3) Can the client access the ACCESS file, with the same path? If not, then you need to change Access file location, as well as AddOLEDBSource method. The application, report files and database all reside in the same folder. Al Quote:
> (1) It's better you use PDW or MSI to distribute runtime files. You could > easily miss things doing things by hand. > (2) I take that your application works on your development box, but not on > client box. > (3) Can the client access the ACCESS file, with the same path? If not, then > you need to change Access file location, as well as AddOLEDBSource method.
> > PMFJI, but I'm having the same problem. Using VB5 SP3 and Crystal > > Reports 8.0. Connecting to an Access 7 database using OLEDB. The VB
> > display the report using the CRViewer. > > <<There are quite a few runtime files that need to be distributed with > > your setup. Go into the runtime help file and make sure you are > > distributing the correct files.>> > > BTDT. Here are the files that I've copied to the Windows System folder > > on the client machine. All DLLs were registered manually with > > REGSVR32.EXE. > > craxdrt.dll > > Crpaig80.dll > > crviewer.dll > > mfc42.dll > > msvcrt.dll > > p2bdao.dll > > p2bxbse.dll > > p2ctdao.dll > > p2irdao.dll > > p2ixbse.dll > > P2ldb2.dll > > p2lodbc.dll > > p2sdb2.dll > > p2sfs.dll > > P2smon.dll > > p2sodbc.dll > > p2soledb.dll > > sscsdk80.dll > > In addition, MDAC 2.5 SP2 was installed on the client machine. > > Any clues? > > TIA, > > Al
> > > There are quite a few runtime files that need to be distributed with > your > > > setup. Go into the runtime help file and make sure you are distributing > the > > > correct files. > > > Dave
> > > > I am using VB6 SQl and CR 8.5. I have created package > > > > through PDW from VB. Everything runs fine on developer > > > > machine. At clients machine when i need to run reports i > > > > get Physical Database not found . Any suggestion . > > > > Thanks in Advance.
|
Fri, 04 Mar 2005 22:32:34 GMT |
|
|