RE: Business Connector: ODBC error (SQLSetConnectAttr)
Yuliya
Was anybody able to solve this?
I am sure it is something to do with network and Axapta authentication.
Any guidance will be appriciated greatly.
Thank you
--
Work saves us from three great evils: boredom, vice and need.
"DevMojo" wrote:
> Hi there,
>
> I'm having an annoying problem with the Axapta Business Connector. We use
> this at one of our customers to connect from a .NET WebService to Axapta.
> All works fine mostly, but from time to time I'm getting following error in
> de Event Log:
>
> Axapta COM Connector Session 1.
>
> SQL error: SQL has reported the following error:
>
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed.
> Connect information was: Userid = [bmssa], Database = [AXDB Production],
> Server = [PRODUCTIONSERVER], DSN= [], Other = []
>
> You may refer to the error log file for further details.
>
> Retry the operation?
>
> All subsequent calls will have errors. The only solution is to restart the
> Axapta Business Connector, which is no real solution of course since I'm
> using it as a passthrough (via a WebService) to deliver messages coming from
> BizTalk Server 2004 to Axapta.
>
> Very bizar. Since I have changed the settings for the Axapta Business
> Connector to login in 3-tier this problem is occurring a few times a day.
> Previously I had no problems. Since I also use this Axapta Business
> Connector on the same machine for another application (a .NET scanning
> application), it is not possible (anymore) to change it back to a 2-tier
> login scenario.
>
> Has anyone ever seen (and even better: solved) this before?
>
> Any help would be very much appreciated !!
>
>
> Kind regards,
>
> DevMojo
>
>
>