Click here to Skip to main content
14,385,487 members
Rate this:
Please Sign up or sign in to vote.
See more: , +
Dear Friends,

Need your help in below issue.

when i type SERVERNAME in ODBC connection (SQL Server Native client 10.0) its does not connect( Gave 08001 Error, HYT00) and when i typed servername\sql instance name it will work.

I tried restarting "SQL Server browser" Service, but that didn't help.

I need to make odbc connection just with servername not with servername\instancename.

Appreciate your help and comments on this.

Thank you in advance

P.S, Using Windows 2008 R2, its just a workgroup server.
Richard MacCutchan 26-Sep-15 4:29am
If the connection string is not valid then you cannot do it. Read the documentation to see what is allowed.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Connection query was right.

Changed the port to 1433 in 'ALL IP' in SQL Server Configuration, and it worked perfectly.

Thank you.
Maciej Los 4-Oct-15 2:57am
Please, mark this as a solution - to remove question from unanswered list.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100