odbc using native client fail RRS feed

  • Question

  • I installed sql2005 on server, created odbc connection , sucess connection.
    I installed native client on pc. pc ping server sucessfully. I created odbc using sa with valid password (as i do in server), when completing give error " sql server does not exist or access denied" , and can not connect with server.
    how can i resolve the problem.

    Sunday, August 26, 2007 8:17 PM

All replies



       I am using ODBC connection to connect to SQL in a script task. While execution of the package the following error is thrown :-


    "The script threw an exception: ERROR [HYT00] [Microsoft][SQL Native Client]Query timeout expired"

    But this is very random. The error is coming randomly. Sometime the package runs and sometimes not.



    Monday, August 4, 2008 4:51 AM