DataBase - SmartList Builder Connection Fail

Dear All,

When i try to use SmartList Builder to get item quantity, the error are show:
1. GPS Error: 58
2. SQL Error: 601 [Microsoft][ODBC SQL Server Driver][SQL Server] could not
continue scan with NOLOCK due to data movement.
3. ODBC Error: 37000
4. A get/change first operation on Table 'IV_Item_MSTR_QTYS' failed
accessing SQL Data.

What happen to it? Why this error occurs? How to solve it?

Thanks,
Wing

  Mariano Gomez replied to Wing

Depending on what version of GP you are running, there may be a service pack
available to solve this issue.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

Might be outgrowing Access but daunted by SQL Server DataBase I am close to completing the consolidation of various small Access databases and a spent the last 10 hours downloading, installing and trying to get my head around Microsoft SQL Server 2008 Express and how it might help me out. It all started when I came encouraging article on keeping your Access database as your front end application and linking to SQL Server database tables. I am finding it MUCH more complicated than I had hoped. Can anyone be happy to use my quite powerful workstation at the office as some kind of server. You may have guessed by now that I am no IT guru by any stretch so please bare this in mind with any suggestions. Access Discussions SQL Server Migration Assistant (1) SQL Server 2005 (1) SQL Server 2008 (1) SQL Server (1

SQL Server DataBase Hall?schen, ich habe mit einem SQL Server noch nie was am Hut gehabt. Alles was ich bisher gemacht hatte, da war Access immer ausreichend. Nun aber ist eine Anforderung, das ein Backend auf einem SQL-Server laufen soll, wobei dar?ber noch nicht fertig diskutiert ist. Ich habe da noch eine alte Vollversion von VB6, dort ist ein SQL-Server dabei (fracht mich aber nicht welche Version, der Karton mit der VB6 steht noch in

Cannot link to SQL server DataBase Can any of you guys help? I am new to using SQL Server. I have a database that I wish to upsize from Access to put the back end on a server, and use Access as a front-end. However, I am stuck at the very first stage - I cannot link Access to the SQL server. I am using SQL Server Management Studio on a single computer for development purposes, no network involved yet. In

proof DataBase https: / / mcp.microsoft.com / authenticate / validatemcp.aspx transcript: 944364 AccessCode: helloworld Access Discussions SQL Server 2008 R2 (1) SQL Server 2008 (1) SQL Server 2005 (1) Microsoft SQL Server Reporting Services (1) Regards Larry Linson Microsoft Office Access (1) Bing Microsoft SQL Server (1

SQL query slow DataBase Hi In the code below I found that it takes 1.3 to split it up or cancel the query? And can I read this faster? string sql = EquipmentID(Equipment) + StartDate.ToOADate().ToString(FloatFormat, myCulture) + EndDate.ToOADate().ToString(FloatFormat, myCulture); sql + = " group by event_id, name"; _Log("Calc thread #2"); OleDbCommand com = new OleDbCommand(sql, con); _Log("Calc thread #3"); From #2 to #3 it takes 1.3 seconds. Remaing less that 0.1 second. So the query is what slows it down. Access Discussions SQL Server (1) Linson Unlike Albert D. Kallal (1) MySQL (1) Windows Server 2003 (1) Visual Studio (1) SharePoint (1) NHibernate (1) Microsoft SQL Server (1) Hi, Besides that your code is full of SQL injection bugs because of