Data transfer from Labview to SQL Server

[Dpatel]

I am using labview 7.1. We have couple for program which is running on Labview and data is tranfering into Access 2000 database tables. I would like to create a ODBC or DSN pathe so it will write into SQL server table insted of Access.
Can anybody know what do i need to do to change the backend. Right now i am using ODBC from Access 2000 to SQL but i want removed Access 2000 from in bewteen Labview to SQL server.

[chrisger]

hi

you need:

1: ODBC installed on your machine (no MS Access needed for that)
2: A ODBC driver for your database
3: a programming interface to ODBC, e.g. MS-ADO (a COM-Object, download is free at microsoft)

check http://jeffreytravis.com/lost/labsql.html for a bundle of vis for accessing ODBC sources with MS-ADO.
then you are free to access any source defined in your ODBC with free software.

best regards
chris