ODBC Servername reverts to old servername once I click OK

[Guest Aaron J]

Hi All,

 

We're currently experiencing some issues with ODBC connectivity in Windows

2003. Basically when I define an OBDC String for example for SQL Server and

populate the following details as follows:

 

Select System DSN

Click Add

Select SQL Server

Enter Name, Description and Servername e.g. SQLSERVER01

Then select TCPIP

Test Connection OK

 

Then after a couple of hours the SQL Servername loses the SQLSERVER01 and

reverts back to the previous Servername of the above DSN Previously used and

deleted. i.e. Servername reverts to: OLDSERVER in ODBC.

 

Thanks in advance,

Aaron Jumani.