Jump to content

labview throws error while trying to open a DB connection


Recommended Posts

Hi,

Iam a beginner to labview,Currently i am facing a problem with the ActiveX data objects library ,where when i try to open a connection. the thing i do here is creating a automation refnum ,passing it through a open automation vi and using a invoke method to open a connection ,while doing this when the automation ref num is being passed through the open Automation vi it throws the below quoted error

ERROR text:

"Error 3005 occurred at Automation Open: Object specified is not creatable in Open SQLServer Connection.vi

This error code is undefined. Undefined errors might occur for a number of reasons. For example, no one has provided a description for the code, or you might have wired a number that is not an error code to the error code input. 

Additionally, undefined error codes might occur because the error relates to a third-party object, such as the operating system or ActiveX. For these third-party errors, you might be able to obtain a description of the error by searching the Web for the error code (3005) or for its hexadecimal representation (0x00000BBD)."

not sure why lab view is throwing the error .Interesting thing here is ,i use the same method to open connection in a different project. There the operation runs successfully without any error.

DB used here is MSSQL

lab view version is 2018

It would be of much help if someone could provide me with the solution .uploading a screen snip of my VI.

image_2021-12-01_152713.png

Link to comment

Hi Gribo,

Thanks for the reply and suggestion.I am a LabVIEW  learner and this was a experimentation with ActiveX libraries.The error implied that LabVIEW was not able to create a connection object,but while creating the Automation refnum i was selecting the Connection object from "Microsoft ActiveX data objects library".This got me confused as to why an object already Listed and available to be created at the Active X library would throw such and error.

However i was able to solve the error and establish a successful connection.Once again thanks for the reply..

Logaranjit G

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.