Has somebody got an example for writing datas with ActiveX to MsAccess?

[happy-student]

Hello,

I'm working with LabView 6i and MsAccess 2000.
At first, I attempted it with SQL-Toolkit, but my SQL-Software is just for Windows '95.
I have no experience with ActiveX. I measure with LabView a SineWave and want to write it to MsAccess.

Has somebody an example?
Thanks

[Dennis_Knutson]

What do you mean that your SQL software is for Win95 only? Every SQL toolkit I've used has been OS independent. The only thing that might be version dependent is the ODBC driver for the database itself. Exactly what toolkit are you using? There are examples of Access ActiveX but I think you'd have much better results with SQL.

[happy-student]

I've got the "SQL Toolkit for G Software for Windows" Version 3.0
During the installation the report: "wrong OS" appeared.
With the ODBC-Administrator I wanted to create a UserDataSourceName. I added the "SQL Toolkit SQLBase" but the ErrorCode 1157 appeared. And the report means, that the setup-routines could not be loaded.

[Underflow]

It's been a while since I've used the SQL Toolkit, but let me see if I can recall some items.

An error box title "Severe" with the contents "Wrong OS" always seemed to come up when installing under win2k. I ignored the warning, and it never seemed to do anything. (The SPC toolkit and probably a couple of others still have the same warning.)

This description works on win2k: If you're writing to an Access database, you probably do not want the SQLBase driver. In the ODBC Administrator, go to the "User DSN" tab. Click on the "Add..." button, and select the "Microsoft Access Driver". (If it doesn't appear, you may have to go to the Access installer disk to find it). Give the next dialog any string you would like for a Data Source Name, bu
t make sure you select the database you want using the "Select..." button.

That should be about all you need for the ODBC setup. To use the database through the SQL toolkit, just specify the Data Source Name that you gave the ODBC connection.

Good luck.

[mikeporter]

Attached is a VI that shows basically how to connect to Access using ADO (ActiveX Data Objects). To use this you absolutely only need one piece of information: the connection string. The easiest thing to do is create a DNS to define the connection, then the connection string is only something like:

DSN=myDBlink;

Where "myDBlink" is the name you gave the DSN when you created it. You might also need a user id and password depending on how (or if) the security is set on the database.

Mike...

[mikeporter]

Just noticed something else, you say you are wanting to save a sinewave to the database. The entire sinewave? If so, you have a bigger problem than how to talk to the database--namely how do you get that much data through ODBC, and if you can get it through, what sort of datatype are you going to use to store it in Access? Access doesn't have anything like a BLOB (Binary Large OBject).

Mike...