'SQL ERROR: Error mapping failed' problem with DBExpress and DElphi 7

[spavkov]

Hello there!

i have this problem with delphi 7 professional:
i want to connect to MSSQL SERVER 7 via DBExpress.
i place one SQLCONNECTION on form and choose this settings,
with double click on this component:

driver name: MSSQL
host name: 127.0.0.1 (i tried localhost and '.' also)
database: bet
username: sa
pass:
OS authentication: false.
etc

and after i try to set SQLCnnnection's property
connected = true
i get error:

SQL ERROR: Error mapping failed.
and DBExpress works fine with mysql and other databases
but not with MSSQL!!!
with other components (ADO, BDE i can connect to
MSSQL with no problem)

anybode has a clue?

 

[nhcys]

you should give the password to the table of sqlserver2000