none
Error 1526

Respuestas

  • _PAGETOTAL has nothing to do with the error. It's an ODBC error. Set up an error handler then use AERROR() to get more details.
    Craig Berntson MCSD, Visual FoxPro MVP www.craigberntson.com
    • Marcado como respuesta Riquel_Dong jueves, 23 de julio de 2009 8:36
    viernes, 17 de julio de 2009 1:12
  • From today I get an error 1526, when printing a Foxpro report containing _pagetotal.
    Jo Simons

    As Craig says, this is nothing to do with _pagetotal, or even VFP.

    You need to find out what the error is. Error 1526 is simply a wrapper for a remote connectivity error. To find the details you need to use the AERROR() function in your error handler when the error number is 1526. The actual error message from the server is contained in the second column of the array that it generates.

    Something like this in your error handler will do it:

    IF m.errnum = 1526
      AERROR(laErr)
      MESSAGEBOX( laErr[2], 16, 'ODBC Error' )
    ENDIF
    




    -- Andy Kramek
    • Marcado como respuesta Riquel_Dong jueves, 23 de julio de 2009 8:36
    viernes, 17 de julio de 2009 9:28
  • You may check to have admin rights on vista system....
    dni
    • Marcado como respuesta Riquel_Dong jueves, 23 de julio de 2009 8:36
    viernes, 17 de julio de 2009 14:32

Todas las respuestas

  • _PAGETOTAL has nothing to do with the error. It's an ODBC error. Set up an error handler then use AERROR() to get more details.
    Craig Berntson MCSD, Visual FoxPro MVP www.craigberntson.com
    • Marcado como respuesta Riquel_Dong jueves, 23 de julio de 2009 8:36
    viernes, 17 de julio de 2009 1:12
  • From today I get an error 1526, when printing a Foxpro report containing _pagetotal.
    Jo Simons

    As Craig says, this is nothing to do with _pagetotal, or even VFP.

    You need to find out what the error is. Error 1526 is simply a wrapper for a remote connectivity error. To find the details you need to use the AERROR() function in your error handler when the error number is 1526. The actual error message from the server is contained in the second column of the array that it generates.

    Something like this in your error handler will do it:

    IF m.errnum = 1526
      AERROR(laErr)
      MESSAGEBOX( laErr[2], 16, 'ODBC Error' )
    ENDIF
    




    -- Andy Kramek
    • Marcado como respuesta Riquel_Dong jueves, 23 de julio de 2009 8:36
    viernes, 17 de julio de 2009 9:28
  • Dear Andy and Craig,

    Thanks for your response. I'm aware that 1526 is a wrapper. the actual error text is:
    "Connectivity error:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near'=' LineNo: 714"

    The application is Mamut Enterprise E5 wich uses an FoxPro Report-editor to generate and change reports.

    The error appeared yesterday after a few Vista updates. On a XP-system the reports run just fine, so I think it has to do with the data in my database.

    Jo Simons
    viernes, 17 de julio de 2009 13:37
  • You may check to have admin rights on vista system....
    dni
    • Marcado como respuesta Riquel_Dong jueves, 23 de julio de 2009 8:36
    viernes, 17 de julio de 2009 14:32
  • Sounds like the ODBC link is not setup. It will require Administrator privledge on the Vista system. Create a new System DSN and use that to connect the reporting tool.


    Craig Berntson MCSD, Visual FoxPro MVP www.craigberntson.com
    viernes, 17 de julio de 2009 20:34
  • To everyone,

    As happens with a lot of things, It starts on his own and it stops the same way.
    I removed all Vista updates and installed them new
    Some items added previous to the database cause the problem. With new entry's there is no problem.
    So I gues that between the Vista updates some things are fouled up.
    Anyway my problem is solved, and I want to thank you al for the comments.

    Bye
    Jo Simons
    jueves, 27 de agosto de 2009 15:44