topic Re: OLEDB CONNECT32 in QlikView

OLEDB CONNECT32

marco_puccetti — Wed, 15 Jul 2015 11:04:49 GMT

Hello i need to load Sql Server Tables within QlikView but i get this error:

.\DEMO\VITTORIA\ETL_TEMPLATE\ETL\OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XXX;Data Source=USER\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=USER;Use Encryption for Data=False;Tag with column collation when possible=False]' Impossibile trovare il percorso specificato.

Is it necessary to set the path of oledb command in the application context where is the oledb file?

Thanks

Marco

Re: OLEDB CONNECT32

Joaquin_Lazaro — Wed, 15 Jul 2015 11:18:04 GMT

Hello Marco:

No it isn`t. You just need

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XXX;Data Source=USER\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=USER;Use Encryption for Data=False;Tag with column collation when possible=False] ;

Hope this helps you

Joaquín

Re: OLEDB CONNECT32

Joaquin_Lazaro — Wed, 15 Jul 2015 11:29:14 GMT

Hello Marco:

One question, is your OLEDB driver 32 or 64 bits ? because the path are different.

Your sentence is for a 32 bits driver, for 64 bits driver is OLEDB CONNECT32 TO .....

Regards

Joaquín

Re: OLEDB CONNECT32

marco_puccetti — Wed, 15 Jul 2015 12:42:11 GMT

I've tried with 32 bit connection.

Marco

Re: OLEDB CONNECT32

marco_puccetti — Wed, 15 Jul 2015 13:13:57 GMT

Hello, below the post (the two screenshot in which i show how the data are showed by the GUI, but not with the command).

Thanks

Marco

Re: OLEDB CONNECT32

krishna20 — Wed, 15 Jul 2015 13:19:41 GMT

Hi Macro,

Please check whether the ODBC SQL Client successfully installed in your PC or not.

If yes. Please Enable Force to 32 bit option in the Edit script (Qlikview) under the Data Menu at the below.

Re: OLEDB CONNECT32

maxgro — Wed, 15 Jul 2015 13:25:32 GMT

try to change the order of the linesin your script: first the connection (oledb....), then the preceding load (load...; sql select...) in this way

oledb connect32....;

load *;

sql select * from .....;

Re: OLEDB CONNECT32

Joaquin_Lazaro — Wed, 15 Jul 2015 13:25:50 GMT

Marco:

The correct syntax is:

OLEDB CONNECT32 ....

Table:

LOAD *

SQL SELECT .....

Not

LOAD

FROM OLEDB CONNECT !!!!!

Regards

Joaquín

Re: OLEDB CONNECT32

marco_puccetti — Wed, 15 Jul 2015 13:28:58 GMT

So, how can i load Sql Server data within a script?

Any other suggestions?

Thanks

Marco

Re: OLEDB CONNECT32

Joaquin_Lazaro — Wed, 15 Jul 2015 13:32:11 GMT

Marco,

The OLEDB CONNECT is one sentence at the begining of the script, then you can do one or more loads

OLEDB CONNECT32 ...

Personas:

LOAD *;

SQL SELECT * FROM PERSONAS

Cars:

LOAD *;

SQL SELECT * FROM CARS

Products:

LOAD *;

SQL SELECT * FROM PRODUCTS

.... and so on

Regards

Joaquín

Re: OLEDB CONNECT32

marco_puccetti — Wed, 15 Jul 2015 13:55:40 GMT

Can you be more detailed?

Thanks

Marco

Re: OLEDB CONNECT32

Joaquin_Lazaro — Wed, 15 Jul 2015 14:01:36 GMT

Yes, of course

Step 1. Erase de FROM clause in line 43

Step 2. Mark completely the OLEDB sentence in line 44, cut it with Ctrl+X and paste it before line 41 wirh Ctrl+V

Step 3. Reload

Re: OLEDB CONNECT32

marco_puccetti — Wed, 15 Jul 2015 14:44:26 GMT

Ok, it seems to be ok how you have mentionned.

Thanks

Marco

Re: OLEDB CONNECT32

Joaquin_Lazaro — Wed, 15 Jul 2015 14:49:57 GMT

Hi Marco,

Does it work ?

Joaquín

Re: OLEDB CONNECT32

Joaquin_Lazaro — Thu, 16 Jul 2015 06:25:40 GMT

Hi marco.puccetti

Don't leave opened posts, if it works mark an answer as 'correct answer' to close it

Joaquín