My Delphi application uses ADO to connect to Sql Server Express 2005 on a Windows Server 2003 in a local network. Since i migrated from delphi 7 to delphi 2009 i get an exception when i try to connect from some vista boxes. Connecting on the same boxes with same application but compiled under Delphi 7 succeeds!
I get this error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
After disabling uac on the vista machine everything is fine but that is no solution, it should also run under uac as it does with delphi 7.
Provider=SQLOLEDB.1;Password=xxxxxx;Persist Security Info=True;User ID=sa;Initial Catalog=Easy;Data Source=SERVER2003\SQLEXPRESS