Hi I have this problem
My management application ( using Delphi ) was using a database in SQL 2000
I planning to upgrade the SQL Server 2000 to 2005 same Standard Version
The migration using simple method :
1. Backup the db in SQL 2000
2. Create a db with same name in SQL 2005 with compatibility back to SQL 2000
3. Restore the backup to SQL 2005 and ready to use
I can select update insert do all the transaction in SQL 2005 normally but the problem is the managment system always report can't connect to SQL Server
and also one problem I cannot change the management system code since it create by somebody outside the company and already long gone or not care about this software anymore.
So my only hope is to see if there something wrong with the SQL Server
I check the typical sql syntax for delphi to connect to SQL Server there is no different between connecting to 2000 or 2005 the connection string also similar to other programming language. ( I also try using my own built application in C# it works well i just
need to change the dsn on the IP part )
From the error report by the old program ( the one using Delphi ) it indicates that it was user pass problem, so I recreate the user in the sql 2005 version to be the same as SQL 2000 than check using the .udl it both connect well, but from the software
still report it can't connect.
It also appear that if I
View Complete Post