rmassey
Posts: 12
|
| Posted: 05/11/2004, 1:54 PM |
|
Ok I need some help if possible. I looked through the entire forum and on google with no results. As you see the error below and I have tried objconnection.connectiontimeout, objconnection.commandtimeout setting both to 360. I have tried server script timeout to 360 and I even set MS SQL database server to timeout = 0 which indicates no time out. Each time CCS returns the error below. I go into SQL analyzer and I can run the query which says it runs for 45 seconds or so each time. Although each time CCS runs it is right at 30 seconds when it returns the error. Our network bandwidth is running good and I checked that. I even indexed my tables I am searching on and that didn't help even for 1 second.  Anyone else have any suggestions I could try? I have been searching on this problem and tried everything I could think of on extending the timeout to no prevail. TIA I also created a new raw project thinking it was something I did and I get the same thing. I also published the project from my machine to my Intranet server and same error. It's like something is over riding my settings at 30 seconds and no matter what I try I cannot pin point it. Strange deal... Thanks again.
Error:===========================
Form: Grid vNOVAClinstarPatients_aud
Error: [Microsoft][ODBC SQL Server Driver]Timeout expired (Microsoft OLE DB Provider for ODBC Drivers)
-Robert
|
 |
|
rmassey
Posts: 12
|
| Posted: 05/11/2004, 2:02 PM |
|
To help understand the queries here is a start project for my application.
CCS SQL Statement...
SELECT *
FROM vNOVAClinstarPatients LEFT JOIN audit ON
vNOVAClinstarPatients.Clinstar_Account_No = audit.account
WHERE Clinstar_PAT_SSN LIKE '%{s_Clinstar_PAT_SSN}%'
AND Clinstar_Med_Rec_No LIKE '%{s_Clinstar_Med_Rec_No}%'
AND Clinstar_Account_No = {s_Clinstar_Account_No}
AND Clinstar_PAT_FirstName LIKE '%{s_Clinstar_PAT_FirstName}%'
AND Clinstar_PAT_LastName LIKE '%{s_Clinstar_PAT_LastName}%'
vNOVAClinstarPatients view...
SELECT
CAST(Right(c.PAT_ACCT_NBR,7) as Numeric) AS Clinstar_Account_No,
CAST(n.PAT_ACCT_NBR AS Numeric) AS NOVA_Account_No,
c.INTN AS Clinstar_PID,
c.PAT_NAME_FIRST AS Clinstar_PAT_FirstName,
c.PAT_NAME_LAST AS Clinstar_PAT_LastName,
c.PAT_NAME_MI AS Clinstar_PAT_MiddleInitial,
c.FULLNAME AS Clinstar_PAT_FullName,
c.PAT_ADDR_1 AS Clinstar_PAT_Address1,
c.PAT_CITY AS Clinstar_PAT_City,
c.PAT_STATE AS Clinstar_PAT_State,
c.PAT_ZIP_CODE AS Clinstar_PAT_ZIP,
c.PHONE_NBR AS Clinstar_PAT_Phone,
c.SEX AS Clinstar_PAT_Sex,
c.PAT_SSN AS Clinstar_PAT_SSN,
Right(c.UNIT_NBR,6) AS Clinstar_Med_Rec_No,
c.ADM_DT AS Clinstar_Admit_Date,
CAST(n.PK_NOVA AS CHARACTER) AS NOVA_PID,
n.PAT_NAME_FIRST AS NOVA_PAT_FirstName,
n.PAT_NAME_LAST AS NOVA_PAT_LastName,
n.PAT_NAME_MI AS NOVA_PAT_MiddleInitial,
n.FULLNAME AS NOVA_PAT_FullName,
n.PAT_ADDRESS AS NOVA_PAT_Address1,
n.PAT_CITY AS NOVA_PAT_City,
n.PAT_STATE AS NOVA_PAT_State,
n.PAT_ZIP AS NOVA_PAT_ZIP,
CAST(n.PAT_PHONE AS CHARACTER) AS NOVA_PAT_Phone,
n.PAT_SEX AS NOVA_PAT_Sex,
SUBSTRING(CAST(n.PAT_SS_NBR AS CHARACTER),1,3) + '-' + SUBSTRING(CAST(n.PAT_SS_NBR AS CHARACTER),4,2) + '-' + SUBSTRING(CAST(n.PAT_SS_NBR AS CHARACTER),6,4) AS NOVA_PAT_SSN,
CAST(n.PAT_MED_REC_NBR AS CHARACTER) AS NOVA_Med_Rec_No,
n.PAT_ADM_DATE_8 AS NOVA_Admit_Date,
CAST(n.PAT_HIST_NBR AS CHARACTER) AS NOVA_History_No,
CAST(n.RAD_FLAG AS CHARACTER) AS NOVA_RAD_Flag
FROM
vClinstar_ADM_DEMOG c
FULL OUTER JOIN
vBIOENCOUNTERS n
ON
CAST(Right(c.PAT_ACCT_NBR,7) AS Numeric) = CAST(n.PAT_ACCT_NBR AS Numeric)
Audit table...
SELECT
[id],
[account],
[name],
[old_hist],
[new_hist],
[del_ind],
[old_mrn],
[new_mrn],
[him_flag],
[rad_flag],
[last_visit_date],
[HIMUSERID],
[RADUSERID]
FROM
[audit]
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/11/2004, 7:06 PM |
|
You wrote that CCS returns this error but the error message seems rather like something returned by the Web application, not CCS.
Please confirm where exactly do you see this error. Is it a pop-up diaog in CCS or is this error shown on your Web page?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
rmassey
Posts: 12
|
| Posted: 05/11/2004, 9:41 PM |
|
Sorry peter, the error is returned in the web app and not CCS. I solved the problem but doesn't make since why I had to do what I did. That is I had CCS build my connection string instead of using a SQL DSN. Once I built the connection string using the CSS wizard it worked fine and my data retrieval was nice and fast. I am not sure why the DSN change mattered without further investigating. Which I currently don't have time to do since I need to move on this project as the deadline nears. I will try to update this if I get the time to find out why this mattered. I will probably just use the connection string builder for now on since the other acted the way it did even on another server.
Thanks again...
|
|
|
|
|
 |
|
|
|
