SQL Error 3624,HY000

Business Central/NAV Technical Forum
1

Dear

one of my client is facing this problem in sql database server(ODBC Sql server driver)

3624,HY000[Microsoft ][ODBC sql server driver][Sql Server]

3624,01000[Microsoft][ODBC Sql Server Driver][Sql Server ]Location recbase.cpp:1371

Expression: m_nVars >0

SPID:56

ProcessID 1824

can you please suggest the solution & th reason behind this problem

2

Dear

Plz set the path of Sql Server and try out to set in ODBC DSN to set the path. Check the file xpo_ndl.dll in bin folder of sql server.

Regards

Vivek k Gupta

3

Dear Vivek Kya haal hein.

same sql error is coming again.

can u please guide what is the step to correct it.

Also what is ur mobile no.

Keep in touch

Thanks

4

Dear,

This is the problem of the server. for this rebuild the database and reindex the database by using single user permission.and install the service pack of Sql Server.I am also sending the HotFix detail as given.

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000 Windows CE Edition. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

INF: How to Obtain the Latest SQL Server 2000 Windows CE Edition Service Pack

Back to the top

Hotfix

NOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Windows CE Edition Service Pack 1.

The English version of this fix should have the following file attributes or later:

   Version      File name
   -----------------------------------------------

   1.1.3111     Ssce10.dll
   1.1.3008     Ssceca10.dll
   1.1.3008     Sscecw10.dll (Not included for x86em)

NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.

And reindex the database table.

5

Dear Vivek

Service pack of sql server has been installed

Can you please tell the steps to write the query.

Thanks

Ashish