SQL toolkit error message

[Marg_SZ]

Hello, I'm try out the CVI example program "weather" which uses SQL toolkit. Instead of using DSN, I changed it to using "Provider=Microsoft.JET.OLEDB.4.0; Data Source=C:\\...\\samples.mdb;" but I got this error when I ran it.

"Microsoft JET Database Engine: No value given for one or more required parameters."

Please see the attached picture for details. Does anybody know what's wrong with it? And how to fix it?

Thanks for any idea.

[HeroOfHyrule]

Marg_SZ,

I did a little searching, but the results for NI Internal searches did not provide much. However, I did find some useful info online. I'll link it here for you. 

[Marg_SZ]

Thank you for replying, Rob.

I read the possible reasons but I don't think any of them is true here because the CVI sample program "weather" runs well when it uses DSN to connect the database samples.mdb. I just want to try to connect it with "Provider=Microsoft.JET.OLEDB.4.0; Data Source=C:\\...\\samples.mdb;" so we do not need to ask our customer to configure ODBC.

Any more ideas?

Thanks,

Margaret 

[vix]

Hello Margaret,

unfortunately SQL Toolkit 2.2 has some bugs (confirmed by NI) when you use direct connection strings (not when you use DSN).

See my messages in this thread