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 <pvraghavan...@yahoo.com> wrote:
From: venkat raghavan <pvraghavan...@yahoo.com>
Subject: Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database
To: Axapta-Knowledge-Village@yahoogroups.com
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 <saisharan....@gmail.com> wrote:
From: Sai Sharan <saisharan....@gmail.com>
Subject: [Axapta-Knowledge-Village] Error in Connecting to Another Database
To: Axapta-Knowledge-Village@yahoogroups.com
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....
