Post reply

ODBC

  • November 9, 2006 at 4:01 pm

    #173367

    I am trying to access a SQL Server 2005 database with a Perl script. In order to do this I plan on using ODBC. When I create a new Data Service Name using the Microsoft ODBC utility, I get this error:

    Connection failed:

    SQLState: '01000'

    SQL Server Error: 1326

    Server does not exist or access denied.

    Connection failed:

    SQLState: '08001'

    SQL Server Error : 17

    Server does not exist or access denied.

    Anybody know why this is?

  • November 10, 2006 at 2:37 am

    #671031

    Well, either you typed in the name of the server wrong or it is inaccessible or the login credentials are wrong or the login does not have permission to access the database you have set as the default or the server does not allow remote connections or ..........

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • November 10, 2006 at 4:40 am

    #671041

    are you using the new 'SQL Native Client' provider?

Viewing 3 posts - 1 through 2 (of 2 total)

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