OLE DB error when connecting to SQL Server

[OpenIT Solutions]

Hi All,

I have a user that is getting an OLE DB connection error when we try to connect to an SQL Server database. The connection test is fine. Does anyone know how to trace/debug OLE DB connections? Can EA be run in a debug mode where details of errors are output to a log file?

Thanks,

Jon.

[OpenIT Solutions]

Hi All,

FYI have an answer myself for this one now...turns out that in some cases the clever little dba was not granting write permision to the user in the SQL Server database....hance the conection test worked, but when they tried to access the model EA through up the error.

Regards,

Jon.