LabWindows/CVI 8.01 ActiveX SQL access denied.

[JonathanN]

Hi luyy,

Do other co-workers experience the same behavior you are describing? Do they see everything working with LabWindows/CVI 7.0 and not with 8.0?

One test would be to find a machine with LabWindows/CVI 7.0 on it, install the latest LabWindows/CVI Run-Time Engine (8.1) which installs cviauto.dll and see if you can still run that 7.0 application.  This would tell us if there is an issue with the LabWindows/CVI Automation dll or for sure something's wrong with that computer.  I would recommend testing this out on a machine other than your current 7.0 machine so you always have a working application. 

Best Regards,

[Whitman_Cougar]

Hi, Jonathan,

Yes, you are right. Everything is working fine with CVI 7.0 but not with CVI8.0. My co-worker experienced the same behavior at the fourth PC which has CVI8.0 RTE and IDE installed.

Then I removed CVI8.0 RTE and IDE from this fourth PC. Consequently, I installed the CVI8.1 RTE from NI web. Then I renamed the CVI7.0 cviauto.dll to cviauto.dll.bak in my application directory. Then I re-ran my CVI7.0 application code which would call CVI8.1 cviauto.dll located in c:\windows\system32. Then the same error message "Access is denied" showed up again. Then I renamed the CVI7.0 cviauto.dll.bak back to cviauto.dll in my application directory, my CVI7.0 application code works fine again.

Please let me know what you think,

Thanks,

[JonathanN]

Hi luyy,

Thanks for digging around and narrowing down the issue.  It appears the issue is possibly a bug but I am going to need to replicate the issue on our side.  What database are you using (Access, MySQL, SQL Server, etc).  Is it possible to send me a very basic CVI application that I can run that demonstrates the behavior.  This way I don't have to "assume" what steps you called and I know exactly what functions you called.

The workaround is to use that CVI 7.0 automation DLL.  Sorry for the inconvenience

Best Regards,

[Whitman_Cougar]

Hi, Jonathan,

We use SQL Server here. Attached please find the basic SQL server access code. I tried this code on both my CVI7.0 and CVI8.0 machines and had the exact same behavior. You can easily run the program at your side by just changing the SQL server name in ADODB_New_Connection in main.c to your SQL server name. The ActiveX Controller ADO2.8 used here is also enclosed.

Please let me know your finding,

Thanks,

[JonathanN]

Hi luyy,

I was able to replicate the behavior you have been seeing so it appears to be a bug. I am filing a Corrective Action Request to R&D to notify them of the issue. It was weird as sometimes I received the error "The RPC server is unavailable" and sometimes I received the access denied error. However, when I switched back to the 7.0 version of that automation DLL, everything worked fine. '

Anyway, sorry for the inconvenience and as I now the only workaround is to use the older version.

Thanks for the find

Best Regards,

[Whitman_Cougar]

Hi, Janathan,

We have a project which has PXI chassis and its latest software which needs CVI8.0 or higher. We want to ecord PXI RF measurement into the SQL database. What is your estimated time frame to get R&D response?

Thanks,

[JonathanN]

Hi luyy,

What version of SQL Server were you using? I forgot to ask if you had tried testing your application with different versions of SQL Server?

This was reported to R&D (# 45NCADOF) for further investigation.  However, I cannot give any timeframe of when this behavior will be addressed. Is it not possible to use CVI 7.0 for you current application? Why is it a necessity to upgrade to 8.0?

You could try simply to use the 7.0 DLL but I am not sure how this will act (might cause errors if using newer ActiveX features).

Anyway, if I do hear anything from R&D, I will let you know.

Best Regards,

Message Edited by Jonathan N on 01-25-2007 03:13 PM

[Whitman_Cougar]

Hi, Jonathan,

Our company's IS persons are not easy to deal with. They have already been mad to me because of this issue. So I don't think they will be so generous to allow me to do all kinds of experiments on their databases. In addition, the SQL server version shouldn't be matter from my point of view because CVI7.0 application works.

Furthermore, I tried CVI8.0 application with CVI7.0 cviauto.dll, but it doesn't work. It says:"The DLL version doesn't match the import library.". You can duplicate this at your side.

I wish I didn't need to upgrade to CVI8.0.....

Anyway, please let me know as soon as you hear anything from R&D about this.

Thank you,

[JonathanN]

Hi luyy,

I thought you would receive that error as I did as well.  I would like to take this discussion offline and perhaps talk with you personally. Is your profile up to date with your contact information? If so, if you give me permission I can get our web team to give me your phone number and we can chat.

Best Regards,

[Whitman_Cougar]

Hi, Jonathan,

I approve it.

Thanks,