C/ODBC connection slow after upgrade to 3.70a

jadetunji

After an upgrade to 3.70a and win 2003 server from 3.01b and win 2000 server respectively, the push into Navision that usually takes approx 5min now runs for ever and eventually crashes. Are there any changes required to the code below to eliminate this problem?

Thanks for your assistance

###########################################

!!CB!! 184
Menu Item: &Send Data to Finance System
Resource Id: 9251
Keyboard Accelerator: (none)
Status Text:
Menu Settings
Enabled when: NOT SalIsNull( dfAudId ) AND NOT cbSent AND SalSendMsg( hWndForm , PAM_GetScreenMode , 0 , 0 ) = MODE_View AND NOT cbPretend
Checked when:
Menu Actions
!
Call SalWaitCursor( TRUE )
! Connecting to Navision database ... to send data to Monthly_Feed_From_ROB (AR 18-3-2002)
! If NOT LoginToNavision( 'Navision' , ghSqlNavi , 'Navision Test' )
Call SalMessageBox( 'Unable to connect to Navision database', 'Error Connecting',MB_Ok )
! Query on the view v_Monthly_Feed_From_Rob to populate Navision table (AR 14-03-02)
!
! Added contract_no also as part Monthly Feed From ROB (AR 18-07-2002)
Call SqlPrepareAndExecute(ghSql, ' select Invoice_Id,
Item,
OEF,
Address_Id,
convert(varchar(25),Invoice_Date,103),
PO_No,
Contract_No,
Item_Type,
Cost_Centre,
Expense_Head,
Quantity,
Item_Charge,
Total_Charge,
Vat_rate,
Name,
Description,
convert(varchar(25),From_Date,103),
convert(varchar(25),To_Date,103),
Processed,
Customer_Agreement_Id,
Vat_Code,
Audit_Id,
Real_Expense_Head
From v_Monthly_Feed_From_Rob
into :Invoice_id,
:Item,
:OEF,
:Address_id,
:Invoice_date,
:PO_no,
:Contract_No,
:Item_type,
:Cost_centre,
:Exp_head,
:Qty,
:Item_charge,
:Total_charge,
:Vat_rate,
:Name,
:Desc,
:From_date,
:To_date,
:Processed,
:Cust_ag_id,
:Vat_code,
:Audit_id,
:Real_Exp_head')
!
! Added contract_no also as part Monthly Feed From ROB (AR 18-07-2002)
While SqlFetchNext(ghSql,nFetchErr)
Set sSql = 'insert into Monthly_Feed_From_ROB
(Invoice_Id,
Item,
OEF,
Address_Id,
Invoice_Date,
PO_No,
Contract_No,
Item_Type,
Cost_Centre,
Expense_Head,
Quantity,
Item_Charge,
Total_Charge,
Vat_Rate,
Name,
Description,
From_Date,
To_Date,
Processed,
Customer_Agreement_Id,
Vat_Code,
Audit_Id,
Real_Expense_Head)
values
( :Invoice_id,
:Item,
:OEF,
:Address_id,
:Invoice_date,
:PO_no,
:Contract_No,
:Item_type,
:Cost_centre,
:Exp_head,
:Qty,
:Item_charge,
:Total_charge,
:Vat_rate,
:Name,
:Desc,
:From_date,
:To_date,
:Processed,
:Cust_ag_id,
:Vat_code,
:Audit_id,
:Real_Exp_head)'
Call SqlPrepareAndExecute( ghSqlNav, sSql )
Call SqlPrepareAndExecute( ghSql , 'update audit_log set sent_to_ss = "Y" where audit_id = :dfAudId' )
Set cbSent = TRUE
Call SalWaitCursor( FALSE )
!
Menu Item Name:

themave

Sorry to say, but each upgrade is slower then the prior version in my opinion. If you read the various forums you will a pattern,

we just upgraded from 2.0 to 2.6 and the system is really slow.
we just upgraded from 2.6 to 3.1 and the system is really slow.
we just upgraded from 3.1 to 3.7 and the system is really slow.
we just upgraded from 3.7 to 4.0 and the system is really slow.

Sorry it is not really any help, just an observation, you make after ready the board for a few weeks, and going over old post.