Zeos connect to MSSQL 7 server

Forum related to MS SQL Server

Moderators: gto, cipto_kh, EgonHugeist

j_yanto
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 30.10.2007, 08:52
Location: jakarta

Zeos connect to MSSQL 7 server

Postby j_yanto » 30.10.2007, 09:08

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
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: 31.10.2005, 21:32

MSSQL connection details

Postby Gerard » 27.11.2007, 11:41

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'


Return to “MS SQL Server”

Who is online

Users browsing this forum: No registered users and 1 guest