Not able to access DB from ActiveX DLL

[Rajanikanth]

Hi all,

I am getting following error message due to which i am not able to access database

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: _ Reason: Not defined as a valid user of a trusted SQL Server connection.
/myhome/adduser.asp, line 28

I using ODBC DSN with NT authentication. I am accessing Data from SQLServer 6.5 using ActiveX DLL. I used ADO to connect to the database in DLL

Can u help me out ?

Thanks & Regards
Rajanikanth

[Douglas Chrystall]

Raj,

What you will probably find is the generic account that IIS uses to run your dll, does not have permissions to perform a trusted connection through to your SQL Server. Check the permissions for the IUSER account, on your web server.

Douglas


------------
Rajanikanth at 5/12/01 8:27:46 AM

Hi all,

I am getting following error message due to which i am not able to access database

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: _ Reason: Not defined as a valid user of a trusted SQL Server connection.
/myhome/adduser.asp, line 28

I using ODBC DSN with NT authentication. I am accessing Data from SQLServer 6.5 using ActiveX DLL. I used ADO to connect to the database in DLL

Can u help me out ?

Thanks & Regards
Rajanikanth