Post reply

Application error

  • February 10, 2012 at 4:29 am

    #250605

    User can not connect with below error.Can any one help me.

    The connection statement looks like this:

    conn.open "Provider=SQLNCLI10; Data Source='xxxxxx';Initial Catalog='yyyyyyyy';User Id=sssss ;Password=@$thm@t3st;"

    Can you help me with the "provider"?

    is it a application error or db error.

  • February 10, 2012 at 4:42 am

    #1445460

    Please let me know how to solve it.

  • February 10, 2012 at 4:48 am

    #1445462

    vijay82 (2/10/2012)

    User can not connect with below error.Can any one help me.

    The connection statement looks like this:

    conn.open "Provider=SQLNCLI10; Data Source='xxxxxx';Initial Catalog='yyyyyyyy';User Id=sssss ;Password=@$thm@t3st;"

    Can you help me with the "provider"?

    is it a application error or db error.

    You didn't post the error, so I'm going to give the typical database developer answer - "It's a problem in the application".

    Of course, if you post back with the error then I might change my mind.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • February 10, 2012 at 5:00 am

    #1445467

    What's the error?

    And please tell me that you did not post a real password to a public site?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 10, 2012 at 5:15 am

    #1445472

    Try running a SQL Profiler on the server, with all login objects selected, to see whether SQL Server sees any attempt to log on.

    Check the security event log too.

    http://90.212.51.111 domain

  • February 10, 2012 at 5:43 am

    #1445486

    sql server is 2008.

    Can you please tell which provider should be used as client is facing some connecting string error.

    The connection statement looks like this:

    conn.open "Provider=SQLNCLI10; Data Source='xxxxxx';Initial Catalog='yyyyyyyy';User Id=sssss ;Password=@$thm@t3st;"

    Ie. can u plz tell me

    either SQLNCLI10 or MSDASQL should be configure on the application server, or is an alternative provider available?

  • February 10, 2012 at 5:48 am

    #1445490

    That depends on what data access library you are using.

    Once more, what's the error?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply