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!

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

PDA SQL Server Connections using dns name

Status
Not open for further replies.

AndyLee100

Technical User
Jun 26, 2003
174
GB
I am trying to connect to a SQL Server database from a PDA app written in C#.

The server name in the connection string is the dns name\sql instance name.

It will not connect to the database and says 'SQL server does not exist or access denied' or something like that.

However if I swap the dns name for the IP address it will connect ok.
The problem is I cannot use the IP address, it must be the dns name (the customer has insisted on this).

I have tested it in our office and it will work with the dns name but it will not work on our customers site.

Does anyone have any ideas how to fix this or what the problem might be ?

Thanks

Andy
 
sounds like a simple DNS problem.
Can you ping the server via the DNS name on the PDA?

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!
 
Thanks for the reply

Yes we can which is the strange thing and it replies with the correct IP address.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top