Zeoslib Portal

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

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'