error accessing sql data

[Kevin Zhou]

In GP 10, I am getting " error accessing sql data" message when I was trying
to reprint the sales order after it has been posted.

Any ideal?

Thanks,

Kevin

[Rheiner]

Does this issue occur only to you? what if other users print the report, does
the same error comes up?

if it only happens to you, then you may have to run the grant.sql script
against the dynamics and company databases. Basically, grant.sql script
grants SELECT, UPDATE, INSERT and DELETE permissions to all tables, views and
stored procedures for all users in the DYNGRP database role. These are the
permissions needed to utilize Microsoft Dynamics GP.

** most of the time, this script can be found under: \Program
Files\Microsoft Dynamics\GP 10.0\SQL\Util

after you run it, try printing the report again to see if the issue will
persist.

let me know how it goes.

Rheiner

[Kevin Zhou]

Hi Rheiner,

No, it occurs to everyone. Do you still think I should run the grant.sql
script?

Thanks alot for your help.

Kevin

[Ian in Ireland]

Open the dex.ini file on the workstation and set the following paramaters.
Then print your report, this will create a DEXSQL.log file in the GP folder
on the workstation that will details the error. However, its most likely that
you will have to rebuild the report from scratch.

SQLLogODBCMessages=TRUE
SQLLogSQLStmt=TRUE

Best regards,
Ian Stewart
www.genesys.ie
http://dynamicsgp.wordpress.com/