Dear Sai Sharan, It worked for you in VPC because, both salesFormLetter and SalesFormLetter_PickingList classes Runon property is by default set to "CalledFrom". In VPC both AOS and Client resides in the same virtual machine, the Runon behaviour will be obviously on server. What you can do is, you can write a class for connecting to the other database and set the Runon property for that class to Server. Then you can call that class from SalesFormLetter_PickingList. Hope it will help you. Regards, Venkat
--- On Mon, 9/6/10, venkat raghavan <[email protected]> wrote: From: venkat raghavan <[email protected]> Subject: Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database To: [email protected] Date: Monday, September 6, 2010, 9:17 AM Dear Sai Sharan, Make sure that Runon property is set to server. Regards, Venkat. --- On Sat, 9/4/10, Sai Sharan <[email protected]> wrote: From: Sai Sharan <[email protected]> Subject: [Axapta-Knowledge-Village] Error in Connecting to Another Database To: [email protected] Date: Saturday, September 4, 2010, 6:30 PM Hi all, i had a senario where i need to save some data from Ax_Database to another database. I had Written a code for connecting to the Externa database. It worked fine when i Executed my code in VPC(VirtualPC)., But when i Execute the same code in Client System it showed me a Problem saying that 1.ODBC operation failed.Unable to log on to the database. 2.[Microsoft][SQL Native Client]Login timeout expired. 3.Object 'OdbcConnection' could not be created. i wrote my code in SalesFormLetter Class and i caled from SalesFormLetter_PickingList. waiting fr ur valuable sugessions....
