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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Server name vs IP address

Status
Not open for further replies.
tatochka

tatochka

Programmer
May 3, 2001
49
0
0
US
Can somebody tell me why if I specify a server name in Data
Environment property for SQL server I get a message "Connection failed...." If I specify IP address I get the connection. What should I look at to use server name?
 
Sort by date Sort by votes
I use OLE DB with ADO connection. I thought I should not worry about DNS .
 
Upvote 0 Downvote
It could be the WINS Server or it could be the hosts file on your PC needs looking at (assuming NT)
 
Upvote 0 Downvote
The server name (and IP) is in the host file. I am trying to connect from dif computers with dif operating system. When hit on Test Connection button the exact message is "Test connection failed because of an error i initialization provider. [DBNETLIB][ConnectionOpen (Connect().\SQL Server does not exist or access denied". If change server name to IP address connection established. Any ideas?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
NEVER used - get all possible info by ip
Replies
4
Views
96
strongm
strongm
sal21
  • Locked
  • Question
get flag and state name
Replies
2
Views
51
sal21
sal21
sal21
  • Locked
  • Question
check if i have clicked on header column name GIORNI 1
Replies
8
Views
114
strongm
strongm
sal21
  • Locked
  • Question
GET street address by lat and lng 1
Replies
11
Views
134
strongm
strongm
sal21
  • Locked
  • Question
peraphs o.t. database street address 1
Replies
11
Views
124
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top