Re: Lotus Notes ODBC connection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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/product4.nsf/wdocs/notessqlreleasenotes

rgds,


"Ben Rum" <bundyrum75@xxxxxxxxx> wrote in message
news:%23ZY3jrTVFHA.3244@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>


.

Relevant Pages

  • Re: Reading mm datasource
    ... When in Word on my machine, I click on open datasource, pick Connect ... > do not seem to have a specific driver name for the connection string. ... But before you go much further, I hadn't realised you were taking that particular approach to making the connection, and AFAIK the consequence is likely to be that you will be opening your data source, using the "OLE DB Provider for ODBC data sources" which is an approach I know little about but will ...
    (microsoft.public.word.mailmerge.fields)
  • Re: VFP Updates?
    ... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: Access and processor usage
    ... and you are using an ODBC connection, that would be your bottle neck. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)