Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-04 : 07:22:36
|
| Dhaval writes "Hi all,The background--------------Application: A service that runs and reads data from time to time.Development is in Delphi 6.Platform: Win 2K workstation with remote (i think) sql server.I'm using SDAC (by corelab-> crlab.com) components to read data from sql server.I've got a msconnection component that requires a servername, username and password to connect. 1. I can't connect to the server on a client's site.2. The network guy at the client's site told i'd have to access the sql server via an IP Address and not a name (he didn't have the entries in hosts and lmhosts file and is NOT going to do that !!! yes, that's what he replied).The problems/doubts-------------------Q 1. Is there a way i can stick with this service application (already modified/almost re-written to cater to the sql server reading) without him having to modify the hosts and lmhosts file?Q 2. Is there something i'm missing here? I even tried to use gethostbyip to pass on the ip address, get the host name (which returns a FQDN) and set this as the servername. No joy!!!At the risk of losing the client if i don't come up with a working solution, it's an urgent request of feedback.Best regards Dhaval" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-12-04 : 17:49:01
|
| Hi... Dummy question but... Have you tried using the IP-address where the server name is supposed to be? Works most of the time.So, these guys have no name resolution whatsoever? No WINS, no DNS no nothing? Sound like they need to attend some classes or something :) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-04 : 18:01:58
|
| Just create an entry in the Client Network Utility. Open this program up, go to Alias, for the server alias type in the server name, select TCP/IP for the network library, for the server name type in the IP address, and then if your port is not 1433, modify the port to the one that SQL Server is listening on. |
|
|
|
|
|
|
|
|
ping works and servername doesn't