How can I implement an ODBC connection to a database using CVI 5.5?

[Howard McVay]

I need to implement ODBC data queries to a Progress database resident on our intranet. I have Progress ODBC drivers for Windows which are known to work in other application environments. I cannot find any examples or methods to do this in CVI 5.5.

[Chris Matthews]

We sell a toolkit for called the Enterprise Connectivity toolkit that includes a library of SQL functions for communicating with ODBC and ADO database sources. You can find info on this toolkit here: http://sine.ni.com/apps/we/nioc.vp?cid=1419〈=US. The toolkit will be your best alternative, but if you don't want it you could use ActiveX communication with Microsoft's Data Access Components (MDAC). You can download the MDAC runtime here: http://www.microsoft.com/data/download.htm#27RTMinfo.

Note, that the SQL toolkit will be a lot easier to program.

Best Regards,

Chris Matthews
National Instruments

[Woolie Willie]

Hi. I realize that you guys want to sell the Toolkit, but that is no reason to not give any support for people wanting to use Microsoft ADO to connect directly. From looking over posts over the past year re: Connectivity Toolkit vs Microsoft ADO ActiveX, there seems to be a significant speed hit. In our application, we need as much speed in accessing the database as possible due to a bottleneck at this spot. Do you guys have any simple sample code which shows a simple connection to a remote SQL Server (or any other brand) database via the Microsoft ADO ActiveX?

[niro]

Hi Willie:
I have a sample available here at
http://www.haitai.com.cn/down/niro/ado.rar.
I just create it from the Active X ADO 2.5.
I don't know whether there is a method can have a much faster speed. You
could
try this, and give me your opinion. OK?

niro
nirofang@hotmail.com

[Woolie Willie]

what is an .rar file? Is this an executable? I would love to see the soruce code that you allude to.

-Rich