RE: ODBC Connection failed in batch processing

[Tom Kim]

Do you have an ODBC System DSN for this external database on the machine
you're running the batch from? It should have the same name has the DSN
you're using in your AX ODBC connection instance. Hope this helps. --Tom
--
Tom Kim
http://axinfo.blogspot.com/

"ODBC failed in batch processing" wrote:

> HI,
> I created one class with ODBC Connection to get data from external
> database into ax database, myself trying to run the class in Batch Processing
> it throws the following error
>
> Error:
>
> ODBC operation failed.
> Unable to log on to the database.
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> Object 'OdbcConnection' could not be created
>
> I have one doubt , my computer name is SERVER and also my SqlServer Instance
> name is SERVER, is the error because of this name clashing,
> its very urgent please send me the proper solution, if anybody knows.
>
> Regards,
> Rajesh kumar.P

[Luegisdorf]

Hi Rajesh

Assuming you are using AX2009, May be your AOS-user or your AOS-machine does
not contain such a ODBC Data Source as you have on your local client machine.
In AX2009, the batches are proceeded on server.

Hope this information helps.
Best regards
Patrick

[Prabu S]

Hi,
To connect an external database, you can use through creating system DSN.
Once if you able to connect DSN, then it is very easy AX to access third
party database using ODBC class.

Please note: while creating DSN, give default database as your database name
in the drop down box.

Thanks,
Prabu S

[ODBC failed in batch processing]

Hi Tom kim,
Thanks a lot its working fine, after created ODBC in System DSN
Regards,
Rajesh kumar.P