Post reply

ODBC drop and SQL Server

  • August 11, 2011 at 7:14 am

    #255644

    Hi Good morning everyone,

    A group of users of one our systems recently have being have this problem: lost ODBC connection to the server.

    I wonder if this has anything to do with the SQL Server itself or it is just a network issue.

    Thank you for your advice

    Yan

  • August 12, 2011 at 6:18 am

    #1367853

    Depends. Was SQL Server down or restarting during this incident?

    If not, it's probably a network issue or the ODBC was deleted, or the users lost permissions to reach the ODBC, or...

    It could be a lot of things. First thing, check to see if SQL was down, then check to see that the ODBC still exists, then check user permissions on both ends. Once you've verified it's nothing you can do anything about, go to the network guys and say "What's the deal?"

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 12, 2011 at 7:10 am

    #1367897

    Thank you for the advice.

    While ODBC drops, the SQL Server is running fine. It does not happen to all users at the same time. Network guy has been working on this issue as well.

    To troubleshotting the problem, I copied the database to an another server and made some users link to that server and changed their ODBC connection. I want to see what will be happen to both groups.

    What do you think

    Thank you and have a nice day

    Yan

  • August 12, 2011 at 8:10 am

    #1367949

    That's definitely one approach. Not knowing what your environment is like, I can't say for certain that it will help you narrow down the problem, but it's a good idea nonetheless.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 12, 2011 at 9:02 am

    #1367994

    Thank you! Have a nice weekend.

    Yan

  • August 15, 2011 at 1:45 pm

    #1368807

    Are you able to see something on the SQL Server Errorlog or on the Server eventlog?



    My blog

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

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