Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
I've tried with 32 bit connection.
Marco
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
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.
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 .....;
Marco:
The correct syntax is:
OLEDB CONNECT32 ....
Table:
LOAD *
SQL SELECT .....
Not
LOAD
FROM OLEDB CONNECT !!!!!
Regards
Joaquín
So, how can i load Sql Server data within a script?
Any other suggestions?
Thanks
Marco
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