Database toolkit problem

[diguana]

Hello

I have a problem with running DB toolkit.

After installation I try to open example or build very simple code with DB Tools Open Connection.

The result is broken arrow shows me that the DB ..Open connection.vi is not executable.

I have installed LV 8.5.1 and DB toolkit from CD. All examples are visible after loading DatabaseEx.llb

but none of them are possible to run. All of them have the same problem, DB .vis are not executable.

I have Developer Suite packet. CVi is installed on C://Program  Files, but LV is installed on D://

Does it be a problem for DB toolkit ?

In LV I can see all DB*.vi in Connectivity tree.

Where I made a mistake ?

Konrad 

[Neil_Li]

Which OS are you running LabVIEW on? XP or 2000? LabVIEW database toolkit depends on the MDAC, http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displa... From you desciption, it seems this component is missed on your computer.

[diguana]

My OS Windows XP SP2.

MDAC 2.8 is currently installed on my PC.

What do you suggest ?

Konrad

[Neil_Li]

What error message did LabVIEW tell you ? Click the broken arrow you can find the error messages.

[diguana]

My procedure looks like that:

Tools>>Create Data Link the window Error list appears where: No VIs with errors.

 When I close this window then I can see: Initialize.vi with broken arrow and the same Error list.

When I open block diagram then I see Prompt and Open UDL.vi with broken arrow....

Second case: I create empty VI, put DB Open .... with some reference and Run. Errors -->look into .jpeg

Property node is set up on unknown control Connection... Where is this control ?

KNRD

[diguana]

I think that the problem can be connected with my folder installation.

CVI is already installed on C: (in CVI DB Toolkit works correctly).

LV is installed on 😧

When I install DB Toolkit then there is no window to change installation path.

Maybe, by default, the DB installer create something in C:\Program Files\National Instruments\ forder

expept in D:\NI LabView\Database.

In D:\NI LabView\Database\MDAC  in mdac_eula.txt is something about Microsoft Data Access Components 2.5.

Which version should be installed on my PC ? How to check ?

Konrad

[diguana]

Hello

I made some system check.  MDAC already installed on my PC are:

- MDAC 2.8 SP1 on Win XP SP2 

- MDAC 2.8 SP1 redistribution

Does DB toolkit cooperate only with MDAC 2.5 ?

Does NI dosn't have DB toolkit for 8.5.1 and MDAC 2.8 ?

Konrad

[pincpanter]

Hello Konrad,

I have the same MDAC installed and the DB toolkit is working. I use it with LV 7.1, but this shouldn't care.

[diguana]

On my PC doesn't work.

I think the problem is with ADO connection object...

Conn ObjectReference.ctl .... connection reference, there is dotted wire.

I reinstall LV and DB tool, problem still exist...

Help, I need this urgently :-((

Konrad

[pincpanter]

Try to reconnect the control to the proper object. Follow this procedure:

1) go to the front panel and right click on the _Connection terminal, then select ADODB._Connection if present

2) If not successful, do it again and select Browse:

3) search and select Microsoft Activex Data Objects (not sure about the correct version: I'd choose the more recent)

4) in the lisbox below, select _Connection

Message Edited by pincpanter on 09-01-2009 02:12 PM