Hi!

I have no real idea, but it seems for me that such thing are depended on:
1. Visibility of SQL Server IP address to that machine (if you use URL name).
2. ODBC and ODBC SQL Server driver version.
3. other networking things related to IP network.

>Hi guys, thanks for all the responses. I tried to pass the ip address of the SQL server instead of the name and it works on some machines. However it doesn't wok on all. I would like to be able to allow the client to use the Server Name or the TCP/IP address. Sometime what i notice is that you can ping the server from MSDOS but it won't connect from the ODBC datasource or from a DSN less connection. Can someone explain why the variations ??? Oh and sometimes it will connect using ODBC but not using the DSN less connection I'm using from my app.