Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL connection issues with tcp/ip

Status
Not open for further replies.
ceeleelewis

ceeleelewis

Programmer
Sep 26, 2002
45
US
I am trying to set a connection in ODBC to connect to an SQL Server on
another computer in my network(not a domain).
SQL is set to listen in port 1433, but when I run netstat -an there is no
sign that the port is listening.
This is preventing me to connect via TCP/IP.
This is the Error Reported when trying to set connection in OBDC
=========
Connection failed: -SQLState: '01000'
SQL Server Error: 10061 -[Microsoft][ODBC SQL Server Driver][TCP/IP
Sockets]ConnectionOpen -(Connect()).
Connection failed: -SQLState: '08001' SQL Server Error:
 
Status
Not open for further replies.

Similar threads

datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
285
dhookom
dhookom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
303
Swi
Swi
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
288
serino
serino
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
141
serino
serino
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
162
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top