Is Sybase, VB6, Crystal Reports and Windows 8 a feasable scenario?
You should get rid of VB6 and Crystal Reports as soon as possible, but yes, all together they work.
With a lot of problems but they work.
Remember SAP owns Sybase and Crystal. They will tell you that if the scenario above is your scenario, then you are in deep s*t (like me).
Does Crystal Reports 8 works with Windows 8? Yes, with a lot of limitations. Again, get rid of this version as soon as possible. Migrate to XI.
What is the minimum version of Sybase Client suitable for Windows 8? Version 15. That's it.
But there's a catch. There's no more a ODBC driver. Don't try to force an ODBC driver, ok? Instead, you'll have to figure out how to work with the driver Adaptive Server.
What if I decide to migrate all my reports to Reporting Services (rdl format)?
That's the one million dollars question.
1 - RPT Crystal Reports can't be converted to RDL. There's no magical machine that will do that to you. You'll have to rebuild the reports from scratch (Oh, that was cruel, I know).
2 - Sybase Store Procedures and Reporting Services don't work well together. It seems that there's something in the DNA of Sybase Database that hates Microsoft technology. So, if you are using Sybase and you want to try Reporting Services, you will probably have a lot of weird problems (at least, that's my experience).
3 - There are complicated issues related to ODBC and OLEDB when it comes to Reporting Services. Sometimes the server application don't recognize the drivers installed in the server macine. In my case, the server application couldn't recognize the adaptive driver of Sybase.
OK, and what is the solution!!!! That's what you are screeming right now. Well, I don't know. I didn't mirate. I'm struggle with my scenario and doing the best I can.
All I can do is share my experience with you so you save time (and money).
And that's it folks!
If you have questions, write them down on the comments section.
Bye!
Nenhum comentário:
Postar um comentário