topic Re: QlikView ODBC Lotus Notes File DSN in QlikView

QlikView ODBC Lotus Notes File DSN

Sun, 26 Sep 2010 11:52:37 GMT

Hi,

I'm trying to connect to a lotus notes db with an odbc driver. I can use the odbc driver only with file dsn (else errorcode 126).
How can I use this connection in QlikView. Tried ODBC connect "file dsn name" etc. Nothing seems to work? Anyone who successfully implemented this? Thanks in advance for your help.
Regards Elzo

QlikView ODBC Lotus Notes File DSN

Miguel_Angel_Baeyens — Sun, 26 Sep 2010 11:57:29 GMT

Hello Elzo,

Is there any chance your ODBC driver is 32 bits and you are using a 64 bit version of QlikView? Are some other DSNs working fine? Does the Connect button in the script editor allows you to connect and creates the line CONNECT TO ...

Regards

Re. :Re: QlikView ODBC Lotus Notes File DSN

shamad — Sun, 26 Sep 2010 17:33:22 GMT

You can use IBM Lotus NotesSql odbc driver 32 bits

Re. :Re: QlikView ODBC Lotus Notes File DSN

Mon, 27 Sep 2010 05:47:38 GMT

Hi,

I tried this ODBC Driver: Lotus NotesSQL ODBC Driver 8.0.x for Windows 2000, 2003, XP

For testing I created a sample file dsn connection to a sql database (32 bit). All I'm getting in the script is "ODBC CONNECT TO ;"
I can select the tables but running script shows up with an odbc error (whats ok because the dsn isn't specified in the connect to statement.
So how can I create a simple file dsn connection in Qlikview? Thanks for your help

Re. :Re: QlikView ODBC Lotus Notes File DSN

Miguel_Angel_Baeyens — Mon, 27 Sep 2010 07:23:41 GMT

Hello Elzo,

It seems you have some problems when recognizing that driver, otherwise your odbc connect to dnsfilename would be correct. If the version of QlikView you are running is 64 bits, try installing a 32 bits version and using the same DSN to connect to the database.

Try also to connect in Excel, Access or some other software just to check if they are able to run fine the odbc you have already created.

Regards.

Re: QlikView ODBC Lotus Notes File DSN

Anonymous — Thu, 08 Dec 2011 13:26:34 GMT

To use Notes data through ODBC, you must have:

Notes SQL, the Lotus Notes ODBC driver
An ODBC Driver Manager version 3.5 or later
One of the following:
One of the following:

OK, and then few steps: (this works in windows 7 x64)

1) Install NotesSQL - driver to C:\NotesSQL

2) add your Lotus Notes directory to the %PATH% Variable

3) Reboot

4) run c:\windows\syswow64\odbccad.exe

5) You should now find the NotesSql ODBC driver to create the ODBC connection normally

Re. :Re: QlikView ODBC Lotus Notes File DSN

prieper — Fri, 27 Jan 2012 11:47:36 GMT

Thanks Ilpo for the detailed steps.

We had similar problems, think that in addition to the installation of a Lotus Client you need to establish in Lotus once a connection to the database, if located on another server (create a tile).

At least this seemed to have helped in our case.

HTH
Peter