NotesSQL & .NET windows application

HCL Domino Domino Forum
1

We have a .NET windows application that is using NotesSQL to connect and write to a Notes database on our network. The application is going to be triggered by Windows Scheduler and will run as a service. The application will sit on a Windows server that has the Notes client and NotesSQL installed. We have found that if Notes client is not opened, when the application is launched by the server, it hangs because of a Notes password prompt. We have selected the user security settings to not prompt for a password from other notes based programs. We have also configured the ODBC DSN to use the specific notes id and have input the password. We are using File DSN. We have even tried to synchronize the notes ID with the Windows domain in order to bypass the prompt. Nothing has worked thus far. I have checked the notes.ini and the keyfilename is referring to the correct ID file.

Any ideas how we can bypass this password prompt?

Thanks,

J

2

Subject: NotesSQL & .NET windows application

Have you considered using something like Proposion’s N2N software ?

It work VERY well for this kind of thing.

3

Subject: RE: NotesSQL & .NET windows application

Maybe not the best solution but did you try sendkeys to send the password to the prompt?

4

Subject: RE: NotesSQL & .NET windows application

We thought about that, but something like that would never pass QC inspection in our organization.

5

Subject: RE: NotesSQL & .NET windows application

We don’t have that luxury at this point. I’d rather just find the solution using the tools we have. I’m sure there must be something that is causing this.

6

Subject: NotesSQL & .NET windows application

You may want to try installing and using the Client Single Logon service for the Notes client. You would then have a Windows service and you should have no prompt when your Notes ID password and your Windows logon password match.