January 14, 2010 at 7:40 am
Hi All,
I have an application connecting to a 6.5 database, which was moved to a 2000 box four months ago. Many things went wrong and this rarely used application was missed in the testing/upgrading effort. The 6.5 server was since retired...
This past week, the business folks tried to use the App. We have no idea where the source code is. The Network folks do not want to reintroduce the 6.5 server to the live server pool, since it is running an unsupported OS not to mention the unsupported SQL Server platform.... From what we can tell the code is VB v6. So it should be compatible with SS 2000. My question is, if I set up an Alias on the 2000 Server, in theory should it work? And if so, is there anything funky that I need to do to set up a cross-version Alias? I tried a direct TCP/IP config and it was unsuccessful.
January 14, 2010 at 7:53 am
Ok, it been a while...
I don't think 2000 has a 6.5 compatibility mode. Also I think they added some keywords between 6.5 and 2000 so that may be an issue.
Also in terms of the alias are you looking to just alias the server name?
January 14, 2010 at 8:04 am
Yes, just server name.
The hope is the code would work without changes - since we cannot locate the source (written 9 yrs ago, when we didn't have effective software version controls in place) we cannot even verify the App until we can gain a connection...
January 14, 2010 at 8:22 pm
Been a while for me also but I think you will need to add an alias to EACH of the client machines using the Client Network Utility (should be in the SQL Server program group).
An alternative may be to add an "alias" to your DNS server.
January 15, 2010 at 7:28 am
Also you will need to move any accounts over. You should be able to find a script that will reverse SQL passwords from 6.5
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply