hi,
how to acces ms sql server from delphi front end. Can you give a sample code.

thanks...

Can you please provide the versions of SQL Server and Delphi that you are using ?

Hi

Place an ADO Connection in your form. then



procedure TForm1.FormCreate(Sender: TObject);
begin

ADOConnection1.ConnectionString := 'Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=DATABASE;Data Source=SERVERNAME'

or SERVERNAME can be (local) if you're using MSDE on local pc


to connect

Try
ADOConnection1.Open;
Except
End;
end;

hi
I have delphi 5 professional editon and ms sql 2000 but I have no ado componet.

Thanks for the reply but i already migrating to C#.

popskie.