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
Can you be more detailed?
Thanks
Marco
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
Ok, it seems to be ok how you have mentionned.
Thanks
Marco
Hi Marco,
Does it work ?
Joaquín
Don't leave opened posts, if it works mark an answer as 'correct answer' to close it
Joaquín