News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) FRx 6.7 ODBC issue

Microsoft Dynamics SL (Archived)

FRx 6.7 ODBC issue

(0) Share

Report

Report

Posted on by Sean Romigh

45

Currently in our pre-production system FRx will not process any reports if we do not set the authentication mode for the ODBC to Windows. If we set it to SQL Server we get DSN errors. We are currently running Dynamics 6.5 SP1 as well. Our production and test systems are working fine having the ODBC set to SQL Server.

Any ideas?

-Sean

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Sean Romigh 45 on at

Like (0)

Report

Re: Re: FRx 6.7 ODBC issue

Thank you for the suggestion. I checked and there is no option for checking Windows Authentication.
Toni Savage 260 on at

Like (0)

Report

Re: FRx 6.7 ODBC issue

With 7.0, it sounds familiar, but not with 6.5. I would check to see if “Use Windows Authentication” is checked in the production FRx Company Information, System Specific Information tab if they are using SP-9 or newer.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans