Zeos connect to MSSQL 7 server

[j_yanto]

Hi everyone,
I want connect to MSSQL 7 server

object ZConnection1: TZConnection
Protocol = 'ado'
HostName = 'ANDROMEDA' >>?? server name or ODBC/DSN name???
Database = 'MLMH'
User = 'SA'
Password = 'XXXXX'
end

but not connected with error message
SQL Error : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Any sample code to resolve above problem.

Regards,
Yanto

[Gerard]

Put your parameters to connect to the database in the databse property of the TZConnection.

e.g.
zConnection1.Database := 'Provider=SQLOLEDB.1;Password=XXXX;Persist Security Info=True;User ID=SA;Initial Catalog=MLMH;Data Source=ANDROMEDA'