problem connecting to the SQL server.

[ice]

I have a problem here, when i use MS Access to link my program is runs.Then I tried to use MS SQL but when i add in the DSN,it show an error message in the explorer.

explorer says:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed

*I hope that someone out there will help. Please!

[DaveN]

Error occurs :

IF the SQL Server does not like the logon name or password being submitted.

DaveN

[ice]

I didn't know whether the following line is correct. Can some one kindly check for me.Because error occur in my program when i add this line to my program.

config.ADMINSETTING_DatabaseDSN = "Driver={sql server};server=yvon;Database=eye;DSN=eye;PWD=;UID=eye;";