Search results for query: *

results: 1. you were right about this one - someone changed the odbc from tcp/ip to named pipes 2. turns out the clients were 8.5 machines upgraded to 9 so the cr oracle7 drivers were already loaded on them. the server did not have the drivers loaded. i could not find the same version on the...

have a report that was working last month on the Server (cmc) using an ODBC connection to a sql server database. It no longer works, but I can run it on my desktop with the same file dsn. i now get the error: Server Used: server.report Error Message: Unable to connect: incorrect log on...

My problem was corrected after the upgrade to 9i. Then I noticed that the ODBC driver and the native oracle drivers had a different command set available. In my case I had to change the functions I was using on the ODBC to the oracle ones (left and right to substr, substring to substr, ifnull...

After the completed upgrade, both the native driver and the sql expressions are now working. Anyone have a suggestion for complex sql expressions since there doesn't seem to be a if or case statement available from within crystal using the native driver for oracle 9i for sql expressions?

I think I might have discovered something. It looks like a patch was installed that now has different ORACLE commands - before when I had the following it was valid {fn IFNULL({fn SUBSTRING("MMDIST"."ACCT_UNIT",5 ,3 )}, {fn SUBSTRING("ICCATEGORY"."INV_ACCT_UNIT",5 ,3 )} )} but now...

Yes, but the errors occur right after closing the datasource window. Did you have to do anything special to get the sql expressions to work on ce? Before: SELECT "APVENMAST"."VENDOR_SNAME", "PURCHORDER"."PO_DATE", "PURCHORDER"."PO_NUMBER", "PURCHORDER"."VENDOR", "POLINE"."ITEM"...

Thanks! I will try that. Unfortunately I can't use sql expressions as the report won't run on eportfolio then, and that is our distribution method.

Our system is oracle 8i and CR/CE 9. I have a report that runs fine using ODBC and the only thing I changed was the data source to use the Oracle Server driver instead. We have other reports using this driver that work. Errors after setting data source on all the tables: (on the client using...

Trying to get more information about failed instances, like email addresses sent to, printername, and/or error message. Thanks! :)

since you have been using csp like me, can you give some suggestions about getting data out of property bags? I tried exactly what it said in the sdk but it doesn't print. response.write " test " 'this works response.write InfoObj.Properties("SI_NAME") 'this works...

run fine in crystal reports, but get the default error message "Crystal Reports: Print Engine Error " when I try to run it on enterprise. Tried both saving it with and without saved data.

I have several reports that have been modified to use sql expression to improve response time. However, the report will run fine on the client running in CR, but will not run on Crystal Enterprise. Any ideas? We are running Crystal Reports/Enterprise 9 with Oracle 8i and Lawson 8.0.3.