Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Unanswered: Problem with ODBC

    Hi
    I had an old project that I'd like to run again. So I've installed SQL Server 2008, created a Database. Now the project was in Java and I had to add an ODBC user data source.
    Ok now I give it a name, description, I tried leaving the Server blank and tried typing 127.0.0.1 (I just want to run on my PC)
    I click next, when I click next again with the check box "Connect to SQL to obtain default settings for the additional configuration options." checked. I get this error
    Connection failed:
    SQLState: '01000'
    SQL Server Error: 2
    [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
    Connection failed:
    SQLState: '08001'
    SQL Server Error: 17
    [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

    Any help would be appreciated, thanks in advance

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    That message could mean anything.

    Find a tutorial on connecting to SQL Server (search for "tutorial connecting SQL Server 2008" or something like that), go through it, take copious notes, and if you still have problems, post your notes in a reply. That will give us more to go on.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Did you install a named instance of SQL Server? Using the loop back address will only attempt a connection to the default instance. If it is not that, I would check to make sure the service is running.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •