Embedded connection string in an OLD DLL

SQL Server Administration
1

got a very strange one here,

the company I work for has an old program built Pre 2000 which connects to a SQL 7 database, the program has been running for a number of years with no issues however the time have come to try and move it to a better SQL version. the connection string for this program is embedded in a DLL which we no longer have the source code for. i know there are programs out there that can decomplie the dll. however i want to see if there is another way.

the current program has the connection string as servername\instance.

my question is, Using Always on High Availability, can you set the listener name to be servername\instance or will it just act as a servername?

Cheers

2

I would be inclined just to use an alias on the client(s):

ps Moving from SQL7 the main thing you will have to look for is old style outer joins. I would setup a trace on the current server to see what the queries are like.

3

Thanks for that i'll have look at to see if it will work,

as for the joins yes I agree this could be an issue but i wanted to check to see if it could be done before going any further

4

ps Moving from SQL7 the main thing you will have to look for is old style outer joins.

What changed? Just curious.

5 
*= and =* were removed in SQL2005.