SQL ODBC Connection Issue

Question

0.00/5 (No votes)

See more:

Win2008-R2

, +

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.

Posted 25-Sep-15 10:51am

Amaan23

Add a Solution

Comments

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

Add a Solution

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

Amaan23 · Answer 1 · 2015-10-03T20:20:00

Solution 1

Connection query was right.

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

Thank you.

Posted 3-Oct-15 20:20pm

Amaan23

Comments

Maciej Los 4-Oct-15 2:57am

Please, mark this as a solution - to remove question from unanswered list.

SQL ODBC Connection Issue

1 solution

Solution 1

Add your solution here

Preview 0

SQL ODBC Connection Issue

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us