Hi Ashish Singh,
i had followed what u have to told me , but now getting a new error. I
think may be this is an error in Sql Server. I need a way to resolve this
error. The error that i got was.
'' 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 Sat, Sep 4, 2010 at 11:14 PM, Ashish Singh <compa...@gmail.com> wrote:
>
>
> Hi Sai Sharan,
>
> You can see the code in the standard DAX 2009 classes for your reference *
> \Classes\SIGSigningProvider_SQLServer_Server*
>
> Couple of suggestions for you, try to incorporate them.
>
> a) Try to incroporate the Permission class.
> b) Use the CCADO classes rather than ODBC classes for connecting to the
> another database.
> c) Be careful when supplying the login user name, make sure that the user
> name that you are using to connect to other system should not be used more
> than once.
> d) Put the code inside the Try Catch statement, else you will not be able
> to figure out as to why some error had happened at least that is the case
> for the CCADO classes.
>
> This is the sample code that i have posted from you. Here you can see that
> i written the code inside the try catch block and see the last part where i
> had done the exception handling this will give you detailed error message as
> to why error is popping up. This code is consuming the CCADO classes.
>
>
> void openConnection()
> {
> System.Exception clrException;
> InteropPermission permission = new
> InteropPermission(InteropKind::ClrInterop);
> Str localConnectionString;
> ;
> try
> {
> permission.assert();
> // BP deviation documented
> sqlConnection = new
> System.Data.SqlClient.SqlConnection(sqlConnectionString);
> if(sqlConnection.get_State() != System.Data.ConnectionState::Open)
> {
> sqlConnection.Open();
> }
> else
> {
> info("Connection is already open !");
> }
> CodeAccessPermission::revertAssert();
> }
> catch(Exception::CLRError)
> {
> // BP deviation documented
> clrException = CLRInterop::getLastException();
> if (clrException != null)
> {
> clrException = clrException.get_InnerException();
> if (clrException != null)
> {
> //store error - don't throw here
> throw error(clrException.get_Message());
> }
> }
> }
> }
> Hope this will help you.
>
> Have a nice day.
>
> Regards,
> ashish singh
> *<*
> *accenture*
>
> On Sat, Sep 4, 2010 at 6:30 PM, Sai Sharan <saisharan....@gmail.com>wrote:
>
>>
>>
>> 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
