CLOB Datatype

[ChiTownDiva]

Happy Hump Day!

Some fields in our database changed datatypes from LONG, RAW and BLOB to CLOB, so of course our reports don't work on the web because the database is running off of a native connection.

I understand the way around this is to change drivers and use CROR8. So, I changed the driver the report uses but when I run the report that's pointing to the updated driver via CE, it fails. I get the "cannot open SQL database" error message.

How do you change the driver in CE?

Thanks in advance for any help with this...


chiTownDivaus

 

[synapsevampire]

Unfortunately you'll need to open each report and use Database->Set Location.

If you had used Views instead of Tables in your development efforts (not just Crystal), you could have gone in and cast the Views CLOB objects back to whatever type you used prior, and then going forward used a new View to use CLOBs (where required) and not impacted prior development.

I never let developers use tables directly. I write a script and create a View for every table and give them permission on the Views only.

-k

 

[ChiTownDiva]

Hey thanks Synapsevampire....

My problem isn't with the reports, but with the CE server. When I run a report that uses the new driver, I get a "cannot open SQL Server" error.

Unfortunately, we cannot use views we have to use tables. Any other ideas?

Thanks in advance.

ChiTownDiva