How to connect to SQL Server?
Hello,
Our reports have to connect to SQL and we set the configuration [PathtoDatebase] is
=============================================
'Provider=SQLOLEDB.1;Data Source=.;Initial Catalog=Demo;User ID=sa;Password=123;Persist Security Info=True;' .
=============================================
And then we modify the procedure
=============================================
procedure Page1OnBeforePrint(Sender: TfrxComponent);
var
begin
ADODatabase1.DatabaseName := <PathToDatabase>;
ADODatabase1.Connected := true;
end;
=============================================
on our reports .
But we can't view the report successfully !
How can we set the correct connection string ?
Our reports have to connect to SQL and we set the configuration [PathtoDatebase] is
=============================================
'Provider=SQLOLEDB.1;Data Source=.;Initial Catalog=Demo;User ID=sa;Password=123;Persist Security Info=True;' .
=============================================
And then we modify the procedure
=============================================
procedure Page1OnBeforePrint(Sender: TfrxComponent);
var
begin
ADODatabase1.DatabaseName := <PathToDatabase>;
ADODatabase1.Connected := true;
end;
=============================================
on our reports .
But we can't view the report successfully !
How can we set the correct connection string ?