July 16, 2008 at 3:18 am
Hi Community,
I have used one ODBC that connects Visual Studio 5 (VB5 & VC++5) application to SQL 6.5 and in Windows NT4.0 client server environment. Will the same ODBC work in a NEW environment with Windows 2003 Server + Same VS 5 Application + SQL Server 2005?
If yes, then things would be pretty simple. Just I will need to install the ODBC using available setup.
If no, then please advice me about how to proceed.
Cheers//Biplob
July 16, 2008 at 2:17 pm
There is no easy answer to this question, because there's no way to tell what 'tricks' your VS 5 implementation is using with SQL 6.5 that is incompatible with SQL Server 2005. Compatibility can only reach back as far as SQL 7.0 - consequently any answer we give you could be wrong.
In essence, you can construct a new ODBC connection within your new box / OS / DB Engine to connect to your existing code. But that does not mean the code will work.
At a minimum, I suspect you will need to install your VS 5 environment onto the new OS - but I don't know if there are compatibility issues there or not.
Good luck. Personally, I'd advocate for biting the bullet and modernize 'everything' including your development tools. Even if everything works today, you don't know when the next security patch inadvertently breaks something in your VS 5 code. So you're between a rock and a hard place - leave yourself open to attacks because of unprotected environment (missing security patches) or having your code break at a very inconvenient time.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply