Sql Error 3617

[Subbulakshmi]

Hi All,

I'm using Team Developer 6.1 and Sql server 2005. Only two of the users are getting the below error when trying to access a menu. We swaped the machine and tested, so who ever logged in the machine they are getting. if they logged in other machine they are not getting the error. Seems machine related.

First the sql query came in the message box and then the sql error.
So i want to know waht could be the reason . We ran the registry cleaner and checked still getting the smae error. How to iterate the issue to solve the problem.

Could you all pease help.

Regards
Subbu

[Ana Paula Bonani]

Hi,

A little research pointed me to this link: http://social.msdn.microsoft.com/Forums ... aproviders

So that doesn't look like a TD problem.

But if you believe that's TD-related we will need a small reprocase please.

Thanks,

[Subbulakshmi]

Hi

Thanks for the reply, i too saw that, but it doest have SP51 as mentioned in the link.

Regards
Subbu

[Subbulakshmi]

Hi,

Even if i give a test case i'm not sure whether it will reproduce in your system because its not occuring to all.

This error SQl Error3617 occurs when trying to execute the below query

Set sgSql = 'SELECT rowid, movement_amount
INTO :CdfInputAdjustSys.siRowId, :MyValue
FROM sysadm.movement_cntrl_unt
WHERE effective_date = :CdfInputAdjustSys.siDate
AND fund_number = :CdfInputAdjustSys.siFundNumber
AND sector_number = :CdfInputAdjustSys.siSectorNumber
AND subsector_number = :CdfInputAdjustSys.siSubsectorNumber
AND movement_type = :CdfInputAdjustSys.siMovementType
AND switch_or_flow = :CdfInputAdjustSys.siSwitchOrFlow
AND dllr_or_unit = :CdfInputAdjustSys.siDllrOrUnit
AND source_system = :CdfInputAdjustSys.siSourceSystem '
Call SalStrTrim( sgSql, sgSql )
If SqlPrepare( hWndForm.hSqlTable, sgSql )
If SqlExecute( hWndForm.hSqlTable )
Call SqlFetchNext( hWndForm.hSqlTable, nFetch )

I suspect that some required DLL might be missing in those machines. May i know what are all the required Dlls related when using SqlExecute statement.

Please advise.

REgards
Subbu

[Ana Paula Bonani]

Hi

If you use a tool like Process Explorer or Dependency Walker it will tell you if you're missing any DLLs. It will also show you which DLLs are required.

Regards,

[Subbulakshmi]

Hi,

I have tried Process exlorer it didnt say any missing DLL's. i copied all DLL's (from the working machine of C:\Program Files\Unify) to the non working machine, but no luck, still getitng the same error.

Any idea?

Regards
Subbu

[Subbulakshmi]

THe error occurs when trying to execute the attached abouve query using SlqprepareandExecute statement. How to break and find out the exact root cause.