Have had a product in place which has worked fine up until this morning.
Sudenly majority of users can't seem to make the first ADO connection to an SQL database. They have had no connection problems in the past.
Have worked the problem to be in the connection string. We where using the servers IP address insteed of the server name. From a small test program it will connect with the name of the server but not the servers IP address.Every computer logs through the domain with DHCP. So the changes from computer to computer are very minor.
Have taken a computer and placed in on the servers hub and checked trough pinging. There seems to be no network problem nor is their a great deal of trafic running through our LAN.
The server has instaled on it
2000 server
SQL 2000
IIS
Crystal reports
Work caried out over last 2 days
* ODBC SQL connections on server changed from User DNS to system DNS
* Crystal reports enterprise added reports
It gets even stranger a computer located on the very furthest part of our network will connect through ADO and on a detailed inspection it has no changes.
I could just go back to VB and change the source code to face towards the server name and be finished with the problem but the laptop that I have been working from has a broken O sector and all backups of the laptop have disappeared. Anyone with any ideas on the actual solution for this one or suggestiosn on how to resolve?
Sudenly majority of users can't seem to make the first ADO connection to an SQL database. They have had no connection problems in the past.
Have worked the problem to be in the connection string. We where using the servers IP address insteed of the server name. From a small test program it will connect with the name of the server but not the servers IP address.Every computer logs through the domain with DHCP. So the changes from computer to computer are very minor.
Have taken a computer and placed in on the servers hub and checked trough pinging. There seems to be no network problem nor is their a great deal of trafic running through our LAN.
The server has instaled on it
2000 server
SQL 2000
IIS
Crystal reports
Work caried out over last 2 days
* ODBC SQL connections on server changed from User DNS to system DNS
* Crystal reports enterprise added reports
It gets even stranger a computer located on the very furthest part of our network will connect through ADO and on a detailed inspection it has no changes.
I could just go back to VB and change the source code to face towards the server name and be finished with the problem but the laptop that I have been working from has a broken O sector and all backups of the laptop have disappeared. Anyone with any ideas on the actual solution for this one or suggestiosn on how to resolve?
