LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

help! ADO ActiveX-ctl. and MS Access

i can't read or write to an Access-database (*.mdb) with the MS ADO ActiveX
Control. everytime i try to use
a method or property of "Recordset" i get an error (code = 1, "An input parameter
is invalid."), but i can get
and set the file, the recordset itself and so on.

does anyone has a solution (don't have
the sql-toolkit)

thanx
0 Kudos
Message 1 of 3
(1,078 Views)
I had little luck using ADO I found using recordset and connection objects
more fruitful. I also found that those objects only seemed to work with
local ODBC databases. I may still have some examples somewhere though you
may have to replace the objects with whatever data objects are loaded on
your machine. I also found very old object libraries can be a bit buggy
(Microsoft like) Later upgrades from the Microsoft website are better (MDAC)
.. It is also very difficult in the labview environment (5.1 at least ) to
tell what has caused your error exactly, they tend to be pretty generic
errors reported,. I was using Access 97 haven't tried 2000 yet .
Regards
Leo
"christian sackmann" wrote in message
news:3a0817a0@newsgroups.ni.com...
>
> i can't read or wri
te to an Access-database (*.mdb) with the MS ADO
ActiveX
> Control. everytime i try to use
> a method or property of "Recordset" i get an error (code = 1, "An input
parameter
> is invalid."), but i can get
> and set the file, the recordset itself and so on.
>
> does anyone has a solution (don't have
> the sql-toolkit)
>
> thanx
0 Kudos
Message 2 of 3
(1,078 Views)
I use LabView to connect with MS Access 2000 and it works well.

"Leo" wrote:
>I had little luck using ADO I found using recordset and connection objects>more
fruitful. I also found that those objects only seemed to work with>local
ODBC databases. I may still have some examples somewhere though you>may have
to replace the objects with whatever data objects are loaded on>your machine.
I also found very old object libraries can be a bit buggy>(Microsoft like)
Later upgrades from the Microsoft website are better (MDAC)>.. It is also
very difficult in the labview environment (5.1 at least ) to>tell what has
caused your error exactly, they tend to be pretty generic>errors reported,.
I was using Access 97 haven't tried 2000 yet .>Regards>Leo>"ch
ristian sackmann"
wrote in message>news:3a0817a0@newsgroups.ni.com...>>>>
i can't read or write to an Access-database (*.mdb) with the MS ADO>ActiveX>>
Control. everytime i try to use>> a method or property of "Recordset" i get
an error (code = 1, "An input>parameter>> is invalid."), but i can get>>
and set the file, the recordset itself and so on.>>>> does anyone has a solution
(don't have>> the sql-toolkit)>>>> thanx>>
0 Kudos
Message 3 of 3
(1,078 Views)