topic File DSN Connection Problem in QlikView

File DSN Connection Problem

Wed, 24 Feb 2010 06:00:12 GMT

Hi All,

I have created a File DSN by connecting to MS Oracle.But i dont see that in the DSN list when in connect from Qlikview.

What is the problem?

Please help.

File DSN Connection Problem

Miguel_Angel_Baeyens — Wed, 24 Feb 2010 09:10:08 GMT

Hello Sandhya,

Are you using Windows 7 or x64 Qlikview Version? It's happening to me in this case, I mean. I can create without problem the DSN but it's not shown in the system.

File DSN Connection Problem

Wed, 24 Feb 2010 09:26:27 GMT

File DSN Connection Problem

Wed, 24 Feb 2010 09:26:44 GMT

Hi Miguel,

I am using Windows x64.

File DSN Connection Problem

Miguel_Angel_Baeyens — Wed, 24 Feb 2010 09:37:32 GMT

Then be sure you have downloaded x64 version of ODBC driver. Only then it will be shown in your DSN dialog when loading the script. It's documented in some developer forums and manufacturers sites that you can succesfully install 32bit odbc driver in your system, and you can even check them doing some tricks in Windows configuration (check among many others previous link). But the thing is that the dialog QlikView calls when using the wizard in the script screen is calling the one that only shows your 64 bit drivers. May it be a bug? I'm not sure.

Otherwise, I haven't found any solution yet.

File DSN Connection Problem

Wed, 24 Feb 2010 09:41:55 GMT

Ok i will check that.Than

File DSN Connection Problem

Wed, 24 Feb 2010 09:45:01 GMT

Ok thank you.

File DSN Connection Problem

Wed, 24 Feb 2010 09:47:00 GMT

Sorry there was some net problem.

Thank you.

I have created an ODBC connection :

ODBC

CONNECT TO Sample (XUserId is QAbUTQRMFDeCWaNOFTcQH, XPassword is

MLKBUQRMFDeCGMB);

How shall i put this into configuation text file and assign it to a variable and connect through that?

Please suggest.

File DSN Connection Problem

Wed, 24 Feb 2010 09:47:03 GMT

Sorry there was some net problem.

Thank you.

I have created an ODBC connection :

ODBC

CONNECT TO Sample (XUserId is QAbUTQRMFDeCWaNOFTcQH, XPassword is

MLKBUQRMFDeCGMB);

How shall i put this into configuation text file and assign it to a variable and connect through that?

Please suggest.

File DSN Connection Problem

Miguel_Angel_Baeyens — Wed, 24 Feb 2010 09:53:16 GMT

Hello Sandhya,

I'd copy that line into say, one .txt file -fist line with FieldName "ConnectionString" and second line with actual connnection string as posted above- and then load it into a variable:

ConnStr:LOAD ConnectionString FROM File;SET vConnStr = PEEK('FieldNameHere', 0, 'ConnStr')

Hope this helps