How can I use SQL TOOLKIT concurrently with Database Connectivity ?

[jpday]

I have installed LabVIEW 6.1 with the Database Connectivity Toolkit and the SQL Compatibility Toolkit (e.g. _SQL folder). I am trying to make the transition from the SQL Toolkit VIs to the Database Connectivity toolkits, but for compatability with existing systems I would like to be able to run the two sets of VIs concurrently (but not in the same app).
When I read into 6.1 a connection VI that I wrote with LabVIEW 6.0 and the SQL toolkit the connection reference type gets changed from a number to type connection (see attachments) . Does compatbility mean that my SQL toolkit VIs are converted to a form compatible with the new ADO ?
Can I use the SQL Toolkit VIs or the Database connectivit
y VIs in the same installation of 6.1 ?
Can I have the SQL Toolkit VIs appear on the functions pallette and function as they did when only the SQL toolkit was installed ?

[JeffBoettcher]

First, direct answers to your direct questions:

1. Does compatbility mean that my SQL toolkit VIs are converted to a form compatible with the new ADO ?

Yes

2. Can I use the SQL Toolkit VIs or the Database connectivity VIs in the same installation of 6.1 ?

No

3. Can I have the SQL Toolkit VIs appear on the functions pallette and function as they did when only the SQL toolkit was installed ?

No


Now an elaboration:

Having the old SQL Toolkit and the new Database Connectivity Toolset installed on the same version of LabVIEW on the same computer is not supported.

Once you install the Database Connectivity Toolset, any VIs written with the SQL Toolkit will run, but with the ADO layer, as you suspected.

Internally, the only way we can ha
ve both the SQL Toolkit and the Database Connectivity Toolset installed on the same computer for troubleshooting customer issues is to have them installed on different versions of LabVIEW. I, for example, have LabVIEW 5.1.2, 6.0.3, and 6.1 all installed on my computer, and I have the SQL Toolkit install on LabVIEW 5.1.2, and the Database Connectivity Toolset installed on LabVIEW 6.0.3. In this configuration I can still run SQL Toolkit VIs independent of the Database Connectivity Toolset if I open and run them in LabVIEW 5.1.2.

[jpday]

Thanks,
This is exactly what I needed to know. I may have missed it,but I think the documentation does not spell these issues out as carefully as you have. I think it would be helpful to have this explanation in the documenation.

[Brian Gangloff]

In response to your #2 below:
Actually it is possible to have the old SQL Toolkit and new Database
connectivity in the same installation of LabVIEW. I have only tried it on
6i, but don't see why it wouldn't work on 6.1. The trick is not to install
the SQL toolkit compatabitily VI's. The old SQL toolkit uses the Intersolve
dll through ODBC while the new Database connectivity uses ADO so it is
possible to use both methods not only in the same LabVIEW install, but it
the same running application. It has been a while since I originally did
this, so I am posting only to mention that it is possible and not exactly
how to do it. If anyone is interested in more details just respond.

Brian

"Jeff B" wrote in message
news:506500000005000000D1650000-1012609683000@exchange.ni.com...
> First, direct answers to your direct questions:
>
> 1. Does compatbility mean that my SQL toolkit VIs are converted to a
> form compatible with the new ADO ?
>
> Yes
>
> 2. Can I use the SQL Toolkit VIs or the Database connectivity VIs in
> the same installation of 6.1 ?
>
> No
>
> 3. Can I have the SQL Toolkit VIs appear on the functions pallette
> and function as they did when only the SQL toolkit was installed ?
>
> No
>
>
> Now an elaboration:
>
> Having the old SQL Toolkit and the new Database Connectivity Toolset
> installed on the same version of LabVIEW on the same computer is not
> supported.
>
> Once you install the Database Connectivity Toolset, any VIs written
> with the SQL Toolkit will run, but with the ADO layer, as you
> suspected.
>
> Internally, the only way we can have both the SQL Toolkit and the
> Database Connectivity Toolset installed on the same computer for
> troubleshooting customer issues is to have them installed on different
> versions of LabVIEW. I, for example, have LabVIEW 5.1.2, 6.0.3, and
> 6.1 all installed on my computer, and I have the SQL Toolkit install
> on LabVIEW 5.1.2, and the Database Connectivity Toolset installed on
> LabVIEW 6.0.3. In this configuration I can still run SQL Toolkit VIs
> independent of the Database Connectivity Toolset if I open and run
> them in LabVIEW 5.1.2.

[jpday]

Brian,
I would very much like to know the details of how to do this.
I think the new ADO is probably worth migrating to; however, I have a number of existing apps. using the SQL toolkit, and more significantly one the people in the group is using a MAC which of course does not use ADO.
It would be very useful to be able to use SQL Toolkit and ADO from the same app.
Thanks,
John