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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.