Oracle 10G conection

    Hi,


    I have been succeden in working with Coquent on DBase III. But, now, as the IT Hospital solution is on Oracle plataform, I move Conquest to Oracle.
    But something odd happens: the OS is Windows, 1.4.12c, Oracle 10G.


    When I run throught interface (no service), works fine, but when I run as service, a password error occurs. The odd is that the password have 2 '%' on it.


    the Troublelog shows the following:


    20070206 23:01:39 ***Error connecting datasource:conquest1 user:itsok password:hsl2009202249es1


    where I put the password between ',


    20070206 22:51:56 ***Error connecting datasource:conquest1 user:hslgestao password:hsl\\13762540es1


    I would like do not change the password, so.


    I????ll be glad for some help ....

    try to use "password" Quote before and after


    another prolem when rebuilding the database,


    [CONQUESTSRV1] ***Error: 936: S1000: [Oracle][ODBC][Ora]ORA-00936: missing expression


    any ideas???

    I discovery some Oracle errors by enabling the tracing on ODBC conection (Contol Painel). Windows records a log which can be viewed, but it????s a long one.


    The my problem of password with %%, I tried puting escape (\%\%) and between '.


    But, with double quote (") WORKS !!!!!!


    Thank????s


    YES,


    The error is on SELECT. I discovered by enabling debug GUI. There is an [AND[/b] after WHERE ????



    [PACSFE1] ***Failed SQLExecDirect : SELECT StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,StationNam,Institutio,PatientNam,PatientBir,PatientSex,PatientID FROM DICOMStudies WHERE AND PatientID = '725772'
    [PACSFE1] ***Error: 936: S1000: [Oracle][ODBC][Ora]ORA-00936: missing expression



    I do not know how to solve !!!!!


    -------------------------------------------------------------
    PACSFE1] 0000,0002 26 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.1"
    [PACSFE1] 0000,0100 2 US CommandField 1
    [PACSFE1] 0000,0110 2 US MessageID 10
    [PACSFE1] 0000,0700 2 US Priority 0
    [PACSFE1] 0000,0800 2 US DataSetType 0
    [PACSFE1] 0000,1000 54 UI AffectedSOPInstanceU "1.2.392.200036.9125.4.0.84872214.3976598528.841116714"
    [PACSFE1] [recompress]: recompressed with mode = j2 (strip=0)
    [PACSFE1] Importconverter0.0 executes: ifequal "NONE","MAMMOGRAPHIC"
    [PACSFE1] Importconverter0.1 not executed because of previous statement
    [PACSFE1] FreeStore Left 235948 on F:\
    [PACSFE1] ***Failed SQLExecDirect : SELECT StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,StationNam,Institutio,PatientNam,PatientBir,PatientSex,PatientID FROM DICOMStudies WHERE AND PatientID = '725772'
    [PACSFE1] ***Error: 936: S1000: [Oracle][ODBC][Ora]ORA-00936: missing expression
    [PACSFE1] ***Error saving to SQL: \1.2.392.200036.9125.3.20345042108.64512605134.18922340\1.2.392.200036.9125.4.0.84872214.3976598528.841116714.dcm
    [PACSFE1] UPACS THREAD 1: ENDED AT: Wed Feb 07 17:40:37 2007
    [PACSFE1] UPACS THREAD 1: TOTAL RUNNING TIME: 42 SECONDS

    The string should have read like this:


    SELECT StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,StationNam,Institutio,PatientNam,PatientBir,PatientSex,PatientID FROM DICOMStudies WHERE StudyInsta = '1.3.6.1.4.1.2452.1.1.1000.20000529164628.1' AND PatientID = '111111-1111'


    And has done so for countless images. Is there something strange with your image (missing studyuid). Other images saved correctly?


    Marcel

    Marcel,


    When I change the dicom.ini paramenter WorkListMode from 1 to 0, I saw no more error. I am filling a 250GB with images from CT (incl. MAMMO), MR and CR for testing. Until now, no errors.


    Carlos Alexandre

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login