Hello,
I've been stumped trying to resolve the following error when running Crystal Reports on a new server I'm setting up:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
------------------------
Technical Information (for support personnel)
Error Type:
Seagate Crystal Reports ActiveX Designer (0x80043AC6)
Access denied.
/OrbitRpt/Crystal/AlwaysRequiredSteps.asp, line 57
I'm running a Win2K server (service pack 4) with Crystal Reports 8. I've tried setting the security to "Everyone - Full Control" on all folders but I'm still getting the "Access denied" error. Has anyone seen this before? Any info would be greatly appreciated. Thanks!The following changes fixed my problem:
To properly set up your System Environment Variables:
1. Create the directory "C:\Temp" if it is not already created.
2. Right-click on "My Computer" on the server machine, and choose "Properties".
3. Go to the "Environment" tab.
4. Under "User Variables", select "TEMP", and then click "Remove". Repeat for the variable "TMP".
5. Select any variable under "System Variables".
6. Change the value for "Variable" to "TEMP" (no quotes).
7. Change the value for "Value" to "C:\Temp" (no quotes).
8. Click "Set".
9. Change the value for "Variable" to "TMP" (no quotes).
10. Change the value for "Value" to "C:\Temp" (no quotes).
11. Click "Set".
12. Click "OK".
Be sure to give "Read" and "Delete" access to this TEMP folder so that the Crystal Reports web components can read and write to this directory.
Showing posts with label resolve. Show all posts
Showing posts with label resolve. Show all posts
Tuesday, March 20, 2012
Wednesday, March 7, 2012
Crystal Error
When opening a report I get this error....how can I resolve this?
The library "PSDODBC.DLL" cannot be found.Have you checked to make sure your ODBC data source is correctly configured or installed?|||yes, I have checked the odbc connection and it's configured correctly.|||What is referencing PSDODBC.DLL so that it gives the error?|||I am getting this error when I go to print the report. It then will ask me to continue to open report for viewing only? Once that goes away it tells me the physical database cannot be found|||Since you have the DLL, have you tried registering it from the command line?
regsvr32 pdsodbc.dll|||when I do a search for this file it does not appear. and no I don't know how to register it.|||Have you searched Google to download it? The code I provided above will register the DLL when you enter it into the command line.
Remember that it will be case-sensitive.|||I found this when I googled..... but I'm still not sure why I'm getting error.
2) Mystery DLL names.
If you have used the Crystal feature "Convert Database Driver..." you will notice a list of DLL files in the pull down list. However, if you were to try to find these drivers on your PC, you would search for a long time. The reason is that the list of driver names hasn't been updated. These are the names of the DLL files used in the original 16bit version of the Crystal. To get the equivalent 32 bit file names, replace the first 2 letters "PD" with the "P2". So PDSODBC.dll becomes P2SODBC.dll. This is a file that you will actually find on your PC. These old file names also show up in error messages, so it helps to know how to decode them.|||Well, have you converted your database driver, as it says there?|||I guess I'm a little confused here...if I go to the drop down menu on the convert database I get a variety of dll options...where I guess I'm confused is this..
To get the equivalent 32 bit file names, replace the first 2 letters "PD" with the "P2". So PDSODBC.dll becomes P2SODBC.dll. This is a file that you will actually find on your PC. These old file names also show up in error messages, so it helps to know how to decode them.
which files do I replace...BTW..I'm fairly new to crystal reports so bare with me :)|||This (http://support.businessobjects.com/communityCS/TechnicalPapers/cr_convert_database_driver.pdf) can explain it much better than I can.|||I had read that before, but my question with that is that on my convert, the default connection if you will is the pdsodbc.dll and all the other options in the drop down are not odbc connections? Am I missing something here??|||To be honest, that is confusing to me as well.|||LOL...good then I'm not the only one...This is a client site that I have these crystal reports on and they are the same as any other clients site and I am really confused on why this would be happening? the other weird thing about the drop down was that the ODBC connection that was listed is the PSDODBC.DLL?? Strange.|||Well, pdsodbc.dll is the 16bit database driver before the conversion. The file p2sodbc.dll is the 32bit driver. After more research, it seems that you just need the driver to be present and the messages will go away. Sounds logical, right?
Other than that, I don't know what else to say. Sorry.|||Sounds logical, but I even copied the P2 file and renamed it PDSOBDC.DLL to trick it and it didn't work. Well I'm at a loss here...I guess I'll keep digging around. Thanks for all your help, let me know if you come up with something else.|||Sounds logical, but I even copied the P2 file and renamed it PDSOBDC.DLL to trick it and it didn't work.
Then maybe it isn't looking in that directory for the DLL.|||Good point...how can I find out where it's pointing|||That, I don't know. Google would have a better result than me.
The library "PSDODBC.DLL" cannot be found.Have you checked to make sure your ODBC data source is correctly configured or installed?|||yes, I have checked the odbc connection and it's configured correctly.|||What is referencing PSDODBC.DLL so that it gives the error?|||I am getting this error when I go to print the report. It then will ask me to continue to open report for viewing only? Once that goes away it tells me the physical database cannot be found|||Since you have the DLL, have you tried registering it from the command line?
regsvr32 pdsodbc.dll|||when I do a search for this file it does not appear. and no I don't know how to register it.|||Have you searched Google to download it? The code I provided above will register the DLL when you enter it into the command line.
Remember that it will be case-sensitive.|||I found this when I googled..... but I'm still not sure why I'm getting error.
2) Mystery DLL names.
If you have used the Crystal feature "Convert Database Driver..." you will notice a list of DLL files in the pull down list. However, if you were to try to find these drivers on your PC, you would search for a long time. The reason is that the list of driver names hasn't been updated. These are the names of the DLL files used in the original 16bit version of the Crystal. To get the equivalent 32 bit file names, replace the first 2 letters "PD" with the "P2". So PDSODBC.dll becomes P2SODBC.dll. This is a file that you will actually find on your PC. These old file names also show up in error messages, so it helps to know how to decode them.|||Well, have you converted your database driver, as it says there?|||I guess I'm a little confused here...if I go to the drop down menu on the convert database I get a variety of dll options...where I guess I'm confused is this..
To get the equivalent 32 bit file names, replace the first 2 letters "PD" with the "P2". So PDSODBC.dll becomes P2SODBC.dll. This is a file that you will actually find on your PC. These old file names also show up in error messages, so it helps to know how to decode them.
which files do I replace...BTW..I'm fairly new to crystal reports so bare with me :)|||This (http://support.businessobjects.com/communityCS/TechnicalPapers/cr_convert_database_driver.pdf) can explain it much better than I can.|||I had read that before, but my question with that is that on my convert, the default connection if you will is the pdsodbc.dll and all the other options in the drop down are not odbc connections? Am I missing something here??|||To be honest, that is confusing to me as well.|||LOL...good then I'm not the only one...This is a client site that I have these crystal reports on and they are the same as any other clients site and I am really confused on why this would be happening? the other weird thing about the drop down was that the ODBC connection that was listed is the PSDODBC.DLL?? Strange.|||Well, pdsodbc.dll is the 16bit database driver before the conversion. The file p2sodbc.dll is the 32bit driver. After more research, it seems that you just need the driver to be present and the messages will go away. Sounds logical, right?
Other than that, I don't know what else to say. Sorry.|||Sounds logical, but I even copied the P2 file and renamed it PDSOBDC.DLL to trick it and it didn't work. Well I'm at a loss here...I guess I'll keep digging around. Thanks for all your help, let me know if you come up with something else.|||Sounds logical, but I even copied the P2 file and renamed it PDSOBDC.DLL to trick it and it didn't work.
Then maybe it isn't looking in that directory for the DLL.|||Good point...how can I find out where it's pointing|||That, I don't know. Google would have a better result than me.
Thursday, February 16, 2012
Cross Tab Query Help
Sorry to bother you all, I have a Cross Tab query issue which i am not sure
how to resolve in SQL2000
Table stuff(
StartDateTime datetime
EndDateTime datetime
CodeRef varchar(20)
)
I want a report which shows
Month(e.g. Jan) Seconds between Date1 and
Date2
Coderef1 X Y
Coderef2 A B
Coderef3 S T
e.g
Jan Jantime Feb FebTime March MarchTime .
.....
AAAA 1202 22 876 18 288 34
......
BBBB 564 10 299 1 143 2
CCCC
etc etc but I have no clue on how to do in SQL.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1Hi
Please post sample data
"stumpy_uk via SQLMonster.com" <u15773@.uwe> wrote in message
news:798020420af3c@.uwe...
> Sorry to bother you all, I have a Cross Tab query issue which i am not
> sure
> how to resolve in SQL2000
> Table stuff(
> StartDateTime datetime
> EndDateTime datetime
> CodeRef varchar(20)
> )
> I want a report which shows
> Month(e.g. Jan) Seconds between Date1 and
> Date2
> Coderef1 X Y
> Coderef2 A B
> Coderef3 S T
> e.g
> Jan Jantime Feb FebTime March MarchTime
> .
> .....
> AAAA 1202 22 876 18 288 34
> ......
> BBBB 564 10 299 1 143 2
> CCCC
> etc etc but I have no clue on how to do in SQL.
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1
>|||Uri Dimant wrote:
>Hi
>Please post sample data
>> Sorry to bother you all, I have a Cross Tab query issue which i am not
>> sure
>[quoted text clipped - 23 lines]
>> etc etc but I have no clue on how to do in SQL.
StartDateTime EndDateTime CodeRef
21/01/07 11:58 21/01/07 13:20 AAAA
22/01/07 09:00 22/01/05 12:00 AAAA
22/01/07 09:04 22/01/05 09:15 AAAA
22/01/07 10:14 22/01/05 11:24 BBBB
22/01/07 10:18 22/01/05 11:29 BBBB
Thanks
etc etc
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1|||Hi
How could it poosible StartDateTime is older than EndDateTime ? If you want
an accurate advise please post valied data and an expected result
Like ...
create table [stuff](
StartDateTime datetime,
EndDateTime datetime,
CodeRef varchar(20)
)
insert into [stuff] values ('20070121 11:58','20070121 13:20',' AAAA')
insert into [stuff] values ('20070122 09:00','20050122 12:00',' AAAA')
insert into [stuff] values ('20070122 09:04','20050122 09:15',' AAAA')
insert into [stuff] values ('20070122 10:14','20050122 11:24',' bbbb')
insert into [stuff] values ('20070122 10:18','20050122 11:29',' bbbb')
"stumpy_uk via SQLMonster.com" <u15773@.uwe> wrote in message
news:79857273db1e7@.uwe...
> Uri Dimant wrote:
>>Hi
>>Please post sample data
>> Sorry to bother you all, I have a Cross Tab query issue which i am not
>> sure
>>[quoted text clipped - 23 lines]
>> etc etc but I have no clue on how to do in SQL.
> StartDateTime EndDateTime CodeRef
> 21/01/07 11:58 21/01/07 13:20 AAAA
> 22/01/07 09:00 22/01/05 12:00 AAAA
> 22/01/07 09:04 22/01/05 09:15 AAAA
> 22/01/07 10:14 22/01/05 11:24 BBBB
> 22/01/07 10:18 22/01/05 11:29 BBBB
> Thanks
> etc etc
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1
>|||Uri Dimant wrote:
>Hi
>How could it poosible StartDateTime is older than EndDateTime ? If you want
>an accurate advise please post valied data and an expected result
>Like ...
>create table [stuff](
>StartDateTime datetime,
>EndDateTime datetime,
>CodeRef varchar(20)
>)
>insert into [stuff] values ('20070121 11:58','20070121 13:20',' AAAA')
>insert into [stuff] values ('20070122 09:00','20050122 12:00',' AAAA')
>insert into [stuff] values ('20070122 09:04','20050122 09:15',' AAAA')
>insert into [stuff] values ('20070122 10:14','20050122 11:24',' bbbb')
>insert into [stuff] values ('20070122 10:18','20050122 11:29',' bbbb')
>>Hi
>>Please post sample data
>[quoted text clipped - 15 lines]
>> etc etc
Uri,
Sorry its just my cut and paste all the years should be 007 so taking your
example into account its just substitute the 2005 with 2007.
--
Message posted via http://www.sqlmonster.com|||Hi
select CodeRef, sum(case when month(StartDateTime)=1 then
datediff(s,StartDateTime,EndDateTime) end) as 'Jan',
sum(case when month(StartDateTime)=2 then
datediff(s,StartDateTime,EndDateTime) end) as 'Feb'
--
from [stuff]
group by CodeRef
"stumpy_uk via SQLMonster.com" <u15773@.uwe> wrote in message
news:7985b7bee8653@.uwe...
> Uri Dimant wrote:
>>Hi
>>How could it poosible StartDateTime is older than EndDateTime ? If you
>>want
>>an accurate advise please post valied data and an expected result
>>Like ...
>>create table [stuff](
>>StartDateTime datetime,
>>EndDateTime datetime,
>>CodeRef varchar(20)
>>)
>>insert into [stuff] values ('20070121 11:58','20070121 13:20',' AAAA')
>>insert into [stuff] values ('20070122 09:00','20050122 12:00',' AAAA')
>>insert into [stuff] values ('20070122 09:04','20050122 09:15',' AAAA')
>>insert into [stuff] values ('20070122 10:14','20050122 11:24',' bbbb')
>>insert into [stuff] values ('20070122 10:18','20050122 11:29',' bbbb')
>>Hi
>>Please post sample data
>>[quoted text clipped - 15 lines]
>> etc etc
> Uri,
> Sorry its just my cut and paste all the years should be 007 so taking your
> example into account its just substitute the 2005 with 2007.
> --
> Message posted via http://www.sqlmonster.com
>|||Uri Dimant wrote:
>Hi
>select CodeRef, sum(case when month(StartDateTime)=1 then
> datediff(s,StartDateTime,EndDateTime) end) as 'Jan',
> sum(case when month(StartDateTime)=2 then
> datediff(s,StartDateTime,EndDateTime) end) as 'Feb'
> --
> from [stuff]
>group by CodeRef
>>Hi
>>How could it poosible StartDateTime is older than EndDateTime ? If you
>[quoted text clipped - 24 lines]
Thank you Uri why is it so blinking obvious when someone posts it but for
days I have been trying temporary tables / updates etc etc...Thanks once
again!
>> Sorry its just my cut and paste all the years should be 007 so taking your
>> example into account its just substitute the 2005 with 2007.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1
how to resolve in SQL2000
Table stuff(
StartDateTime datetime
EndDateTime datetime
CodeRef varchar(20)
)
I want a report which shows
Month(e.g. Jan) Seconds between Date1 and
Date2
Coderef1 X Y
Coderef2 A B
Coderef3 S T
e.g
Jan Jantime Feb FebTime March MarchTime .
.....
AAAA 1202 22 876 18 288 34
......
BBBB 564 10 299 1 143 2
CCCC
etc etc but I have no clue on how to do in SQL.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1Hi
Please post sample data
"stumpy_uk via SQLMonster.com" <u15773@.uwe> wrote in message
news:798020420af3c@.uwe...
> Sorry to bother you all, I have a Cross Tab query issue which i am not
> sure
> how to resolve in SQL2000
> Table stuff(
> StartDateTime datetime
> EndDateTime datetime
> CodeRef varchar(20)
> )
> I want a report which shows
> Month(e.g. Jan) Seconds between Date1 and
> Date2
> Coderef1 X Y
> Coderef2 A B
> Coderef3 S T
> e.g
> Jan Jantime Feb FebTime March MarchTime
> .
> .....
> AAAA 1202 22 876 18 288 34
> ......
> BBBB 564 10 299 1 143 2
> CCCC
> etc etc but I have no clue on how to do in SQL.
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1
>|||Uri Dimant wrote:
>Hi
>Please post sample data
>> Sorry to bother you all, I have a Cross Tab query issue which i am not
>> sure
>[quoted text clipped - 23 lines]
>> etc etc but I have no clue on how to do in SQL.
StartDateTime EndDateTime CodeRef
21/01/07 11:58 21/01/07 13:20 AAAA
22/01/07 09:00 22/01/05 12:00 AAAA
22/01/07 09:04 22/01/05 09:15 AAAA
22/01/07 10:14 22/01/05 11:24 BBBB
22/01/07 10:18 22/01/05 11:29 BBBB
Thanks
etc etc
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1|||Hi
How could it poosible StartDateTime is older than EndDateTime ? If you want
an accurate advise please post valied data and an expected result
Like ...
create table [stuff](
StartDateTime datetime,
EndDateTime datetime,
CodeRef varchar(20)
)
insert into [stuff] values ('20070121 11:58','20070121 13:20',' AAAA')
insert into [stuff] values ('20070122 09:00','20050122 12:00',' AAAA')
insert into [stuff] values ('20070122 09:04','20050122 09:15',' AAAA')
insert into [stuff] values ('20070122 10:14','20050122 11:24',' bbbb')
insert into [stuff] values ('20070122 10:18','20050122 11:29',' bbbb')
"stumpy_uk via SQLMonster.com" <u15773@.uwe> wrote in message
news:79857273db1e7@.uwe...
> Uri Dimant wrote:
>>Hi
>>Please post sample data
>> Sorry to bother you all, I have a Cross Tab query issue which i am not
>> sure
>>[quoted text clipped - 23 lines]
>> etc etc but I have no clue on how to do in SQL.
> StartDateTime EndDateTime CodeRef
> 21/01/07 11:58 21/01/07 13:20 AAAA
> 22/01/07 09:00 22/01/05 12:00 AAAA
> 22/01/07 09:04 22/01/05 09:15 AAAA
> 22/01/07 10:14 22/01/05 11:24 BBBB
> 22/01/07 10:18 22/01/05 11:29 BBBB
> Thanks
> etc etc
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1
>|||Uri Dimant wrote:
>Hi
>How could it poosible StartDateTime is older than EndDateTime ? If you want
>an accurate advise please post valied data and an expected result
>Like ...
>create table [stuff](
>StartDateTime datetime,
>EndDateTime datetime,
>CodeRef varchar(20)
>)
>insert into [stuff] values ('20070121 11:58','20070121 13:20',' AAAA')
>insert into [stuff] values ('20070122 09:00','20050122 12:00',' AAAA')
>insert into [stuff] values ('20070122 09:04','20050122 09:15',' AAAA')
>insert into [stuff] values ('20070122 10:14','20050122 11:24',' bbbb')
>insert into [stuff] values ('20070122 10:18','20050122 11:29',' bbbb')
>>Hi
>>Please post sample data
>[quoted text clipped - 15 lines]
>> etc etc
Uri,
Sorry its just my cut and paste all the years should be 007 so taking your
example into account its just substitute the 2005 with 2007.
--
Message posted via http://www.sqlmonster.com|||Hi
select CodeRef, sum(case when month(StartDateTime)=1 then
datediff(s,StartDateTime,EndDateTime) end) as 'Jan',
sum(case when month(StartDateTime)=2 then
datediff(s,StartDateTime,EndDateTime) end) as 'Feb'
--
from [stuff]
group by CodeRef
"stumpy_uk via SQLMonster.com" <u15773@.uwe> wrote in message
news:7985b7bee8653@.uwe...
> Uri Dimant wrote:
>>Hi
>>How could it poosible StartDateTime is older than EndDateTime ? If you
>>want
>>an accurate advise please post valied data and an expected result
>>Like ...
>>create table [stuff](
>>StartDateTime datetime,
>>EndDateTime datetime,
>>CodeRef varchar(20)
>>)
>>insert into [stuff] values ('20070121 11:58','20070121 13:20',' AAAA')
>>insert into [stuff] values ('20070122 09:00','20050122 12:00',' AAAA')
>>insert into [stuff] values ('20070122 09:04','20050122 09:15',' AAAA')
>>insert into [stuff] values ('20070122 10:14','20050122 11:24',' bbbb')
>>insert into [stuff] values ('20070122 10:18','20050122 11:29',' bbbb')
>>Hi
>>Please post sample data
>>[quoted text clipped - 15 lines]
>> etc etc
> Uri,
> Sorry its just my cut and paste all the years should be 007 so taking your
> example into account its just substitute the 2005 with 2007.
> --
> Message posted via http://www.sqlmonster.com
>|||Uri Dimant wrote:
>Hi
>select CodeRef, sum(case when month(StartDateTime)=1 then
> datediff(s,StartDateTime,EndDateTime) end) as 'Jan',
> sum(case when month(StartDateTime)=2 then
> datediff(s,StartDateTime,EndDateTime) end) as 'Feb'
> --
> from [stuff]
>group by CodeRef
>>Hi
>>How could it poosible StartDateTime is older than EndDateTime ? If you
>[quoted text clipped - 24 lines]
Thank you Uri why is it so blinking obvious when someone posts it but for
days I have been trying temporary tables / updates etc etc...Thanks once
again!
>> Sorry its just my cut and paste all the years should be 007 so taking your
>> example into account its just substitute the 2005 with 2007.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200710/1
Subscribe to:
Posts (Atom)