Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sambireddy

    OLE DB error for SQL server in crystal 10

    I am using Crystal Reports 10 to run the reports created by vendor. The reports are created using OLE DB driver for SQL server 2000 from ctored procedures.When I refresh the report, it gives an error saying that "Failed to open a rowset;Details:ADO Error code::0x80040e14;Source:Microsoft OLE DB...
  2. sambireddy

    Connecting to Informix

    Hi Parkypark, I am trying to connect to the same Siemens Hipath Informix database through Crystal 8.5. If you could please let me know. Thanks
  3. sambireddy

    Connecting to Informix

    I am tring to create a DSN to connect to Informix database using all kinds of drivers. What ever the driver I use it gives me an error saying that "Specified driver could not be loaded due to system error 126("driver name")". Can somebody help me?
  4. sambireddy

    TRIM function in SQL expression field

    I am using the oracle version 9, when I use trim in TOAD it works
  5. sambireddy

    TRIM function in SQL expression field

    When I typed TRIM it gave me an error "ODBC ERROR:[ORACLE][ODBC]Driver not capable".
  6. sambireddy

    TRIM function in SQL expression field

    The field I am trimming contains data as follows: " T7350092" "528250677* " " 9921215 " The report has a parameter to input the above values.As the table contains more than 300000 records,I thought I should not use trim in record...
  7. sambireddy

    TRIM function in SQL expression field

    Bob,thanks for the solution.When I used LTRIM and RTRIM together, it did work for RTRIM(EX:to trim the spaces in the right) not for LTRIM(Ex:to trim spaces in the left) or TRIM(to trim spaces on left and right).Any solution please?
  8. sambireddy

    TRIM function in SQL expression field

    In crystal 8.5 there is no trim function for SQL expression fields that I have seen.I saw LTRIM and RTRIM.Any idea how to use TRIM for an SQL expression field for ORACLE database?

Part and Inventory Search

Back
Top