Active X database querying problem..

[D]

Hi

i've downloaded a active X example (that you can get from
http://exchange.ni.com/servlet/com.quiq.servlet.GetObject/activexdb.zip?KEY=
101.97.18400.14&SIG=101.97.18400.14&EXT=mime:application/x-zip-compressed),
but i can't get it working.

All i have done is extracted the contents of the zip and loaded the active x
example. Both the database and the vi are in the same folder. I haven't
changed anything else.

But when i try to read/insert/update values in the table it comes back with
the following error:
Exception occured in DAO.Workspace, ODBC--call failed.. Help Path is
jeterr40.chm and context 5003146 in Number or Rows.vi

i don't know what this means and have no idea of what to do next, i don't
suppose anyone could help?


thanks a lot

D.

[nyc_(is_out_of_here)]

On Sun, 24 Feb 2002 21:11:48 -0000, "D"
wrote:

>Hi
>
>i've downloaded a active X example (that you can get from
>http://exchange.ni.com/servlet/com.quiq.servlet.GetObject/activexdb.zip?KEY=
>101.97.18400.14&SIG=101.97.18400.14&EXT=mime:application/x-zip-compressed),
>but i can't get it working.
>
>All i have done is extracted the contents of the zip and loaded the active x
>example. Both the database and the vi are in the same folder. I haven't
>changed anything else.
>
>But when i try to read/insert/update values in the table it comes back with
>the following error:
>Exception occured in DAO.Workspace, ODBC--call failed.. Help Path is
>jeterr40.chm and context 5003146 in Number or Rows.vi
>
>i don't know what this means and have no idea
of what to do next, i don't
>suppose anyone could help?
>
>thanks a lot
>
>D.
>
>

If my memory is correct, that example was written for Access98.

I have an example using ADO and Access2000 at work.
Email me at LKuo@multiplexinc.com

[Brian Urch]

D -

Check out LabSQL: http://www.jeffreytravis.com/lost/labsql.html

It uses ADO to connect through ODBC. Here is the first paragraph from their
readme file:

"LabSQL is the beginning of an open source project to provide free,
multi-database, multi-platform database connectivity support for LabVIEW.
In this first release, we have used the Microsoft ADO object to provide
connectivity in LabVIEW for Windows for any ODBC-compliant database,
including Access, SQL Server, Oracle, Pervasive, Sybase, etc."

Brian

D wrote
> Hi
>
> i've downloaded a active X example (that you can get from
>
http://exchange.ni.com/servlet/com.quiq.servlet.GetObject/activexdb.zip?KEY=
>
101.97.18400.14&SIG=101.97.18400.14&EXT=mime:application/x-zip-compres
sed),
> but i can't get it working.