LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excell via ODBC

Hi,

I have ported a aloder LV project from a Win3.11 engine
to a Win NT4

This project accesses .xls data via ODBC

Question : in ODBC access setting, folder "User DNS"
you must select a Workbook ( a *.xls file )

This means it accesses only this named file.

How to make ODBC access any in LV specified file without
reconfiguring the ODBC Data Sources ?

Or can LV rename a *.xls to a given constant name ? this would
solve my problem too

Thanks

Jean-Luc
0 Kudos
Message 1 of 2
(2,268 Views)
Maybe this helps, allthough it's no exact awnser to your question (I
think..).

You can create, modify and read the ODBC sources through the registry:

for user dsn:

HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/

All the available drivers are in ODBCINST.INI, all sources are in ODBC.INI.
You could modify a ODBC NSD's source file to point to the desired file.

Use regedit to debug.

Hope it helps,

Wiebe.


"Jean-Luc" wrote in message
news:3c56de68$0$4607$626a54ce@news.free.fr...
> Hi,
>
> I have ported a aloder LV project from a Win3.11 engine
> to a Win NT4
>
> This project accesses .xls data via ODBC
>
> Question : in ODBC access setting, folder "User DNS"
> you must select a Workbook ( a *.xls file )
>
> This means it accesses only this named file.
>
> How t
o make ODBC access any in LV specified file without
> reconfiguring the ODBC Data Sources ?
>
> Or can LV rename a *.xls to a given constant name ? this would
> solve my problem too
>
> Thanks
>
> Jean-Luc
>
>
0 Kudos
Message 2 of 2
(2,268 Views)