Hi venkat Raghavan, Thnx fr ur valuable Info. I created a class for connction and i calld that class from SalesFormLetter_pickingList, But it has shown up with an Another Error. can u help me out of this.
" A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) " On Mon, Sep 6, 2010 at 9:34 AM, venkat raghavan <pvraghavan...@yahoo.com>wrote: > > > 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.... > > > > > -- Saisharan koka, *PH*:9550654880
