Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2006-02-20 : 09:01:32
|
| I apologise if this is the wrong forum and maybe someone can direct me to the correct one.I am opening a Crystal report in Abobe Acrobat from a web page and getting the data form SQL Server tables using ODBC and File DSN. Once I have run the report - and it works fine, my pc grinds to a halt and is soooo slooow I have to reboot it and actually switch the power off. Does anyone have any suggestions ? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-02-21 : 07:17:04
|
is the query slow? how long does it take in QA?look in task manager to see how much memory does Adobe uses.maybe it uses it all and your pc needs to write it to a file...maybe give us more info.Go with the flow & have fun! Else fight the flow  |
 |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2006-02-22 : 04:52:26
|
| My pc has a bug creating the file DSN. A colleague created one on her pc and mailed it to me and this works ok for speed. I now have a second problem ! If I change the source database in the ODBC ( I have a live and test database) and I go into my Crystal report and chnge the database location it still looks at the original database. I have to logoff the server and then update to the new one. However, I think this is a query for a Crystal Forum and not for here. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-02-22 : 05:52:49
|
| i'd reinstall my pc if i were you...Go with the flow & have fun! Else fight the flow |
|
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2006-02-24 : 04:38:51
|
| Can I just reinstall the ODBC drivers ? |
|
|
|
|
|
|
ODBC problem