adoconnection1.driver = 'sqloledb';
adoconnection1.connectionstring:='Server=MyServer;Database=northwind;Trusted_Connection=yes';you can't mixed DSN and Connect string method
adoconnection1.connectionstring:='Server=MyServer;Database=northwind;Trusted_Connection=yes';you can't mixed DSN and Connect string method
"Provider=SQLOLEDB;Server=YourServerName;Database=YourDatabaseName;UID=YourUserID;PWD=YourPassword;"