Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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

14 Replies
marco_puccetti
Partner - Creator
Partner - Creator
Author

Can you be more  detailed?

Thanks

Marco

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Yes, of course

Test.JPG

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
Partner - Creator
Partner - Creator
Author

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

Thanks

Marco

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi Marco,

Does it work ?

Joaquín

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi marco.puccetti

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

Joaquín