From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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,262 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,262 Views)