OLEDB CONNECT32

[marco_puccetti]

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_puccetti]

Can you be more  detailed?

Thanks

Marco

[JoaquinLazaro]

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

[marco_puccetti]

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

Thanks

Marco

[JoaquinLazaro]

Hi Marco,

Does it work ?

Joaquín

[JoaquinLazaro]

Hi marco.puccetti

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

Joaquín