Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marco_puccetti
Partner - Creator
Partner - Creator

OLEDB CONNECT32

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

1 Solution

Accepted Solutions
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

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

View solution in original post

14 Replies
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

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

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

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

marco_puccetti
Partner - Creator
Partner - Creator
Author

I've tried with 32 bit connection.

Marco

marco_puccetti
Partner - Creator
Partner - Creator
Author

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

Immagine.png

Immagine1.png

Thanks

Marco

krishna20
Specialist II
Specialist II

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.

Comm_172683.png

maxgro
MVP
MVP

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 .....;

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Marco:

The correct syntax is:

OLEDB CONNECT32 ....

Table:

LOAD *

SQL SELECT .....

Not

LOAD

FROM OLEDB CONNECT !!!!!

Regards

Joaquín

marco_puccetti
Partner - Creator
Partner - Creator
Author

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

Any other suggestions?

Thanks

Marco

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

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