|
Home > Archive > MS SQL Server ODBC > May 2005 > Lotus Notes ODBC connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Lotus Notes ODBC connection
|
|
| Ben Rum 2005-05-10, 3:23 am |
| I have been using the NotesSQL driver to connect to a Domino server to pull
data, with a Notes ID that didn not require a password.
I was using a UDL connection to set up the ODBC connection details.
However, a Domino server change now requires password authentication, having
put the password in, I am still getting a pop-up window asking for the
password? This is OK running a DTS manually, but how do I embed the
password, so it can run as part of a schedule?
How can the password be embedded ni the UDL or ODBC connection to prevent
the pop-up window?
Many thanks
| |
| Ben Rum 2005-05-11, 7:23 am |
| After further examination, I believe its actually not possible to connect to
a Domino server unattended.. i.e. The Notes login used by the ODBC
connection must not have a password associated with it.
This is relevant for driver versions up to Notes SQL 3.02g, which this
password "problem" is a known issue.
http://www.lotus.com/products/produ...asenotes
rgds,
"Ben Rum" <bundyrum75@yahoo.com> wrote in message
news:%23ZY3jrTVFHA.3244@TK2MSFTNGP15.phx.gbl...
> I have been using the NotesSQL driver to connect to a Domino server to
pull
> data, with a Notes ID that didn not require a password.
> I was using a UDL connection to set up the ODBC connection details.
>
> However, a Domino server change now requires password authentication,
having
> put the password in, I am still getting a pop-up window asking for the
> password? This is OK running a DTS manually, but how do I embed the
> password, so it can run as part of a schedule?
>
> How can the password be embedded ni the UDL or ODBC connection to prevent
> the pop-up window?
>
> Many thanks
>
>
|
|
|
|
|