20
Hi.. I created a new window and to fill the scrolling window i used a stored procedure. I tested the stored procedure and it works. However, when i call this stored procedure in GP this message prompted:
[Microsoft][SQL Native Client][SQL Server]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
Please help
*This post is locked for comments
Go back to your DSN and uncheck
Use ANSI Quoted Identifyers
Use ANSI NULLS, paddings and warnings.
This under Control Panel->Administrator tools
Also, uncheck Perform translation for character data on the next page.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (