用ADO
将ADOConnection.connectionstring:= 'Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=work;Data Source=BAAL'
将ADOConnection.connectionstring:= 'Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=work;Data Source=BAAL'
AdoConnection.LoginPrompt := False;
AdoConnection.Connected := True;
为baal,选默认的数据库为work.test,成功后即可.
在delphi中可使用ado直接连接或使用database通过odbc连接。
但是如连接不上关键在于SQL SERVER的USE ID,在SQL SERVER安装时的设定;